Hibernate version: 3.2.2

Name and version of the database you are using: Oracle 10g

Hi all,

Just wondering if this is feasible using Criteria queries, and how...

Let's say I want to fetch the rows of a table consisting of 2 DATE columns (DATE1 and DATE2) in which DATE1 and DATE2 are from the same month and year.

The only solution I found so far was to fetch all the rows, and then iterate and check for each row whether DATE1 and DATE2 were matching my restriction. Obviously, this way is far from being the best performance-wise.

Does anyone know any solution that would avoid fetching all the rows?

Thanks in advance,
alexis

Hi Sixel,
what kind of restriction do you want?
You can also use HQL (closer to SQL if you're not comfortable with Criteria) to make queries.

Chucky - Don't forget to rate if this helps

As I said, I need to fetch only the rows with DATE1 and DATE2 within the same month


I'm actually quite comfortable with Criteria queries, and the above problem is just a stripped down example from a much more complex query I use.
HQL is not a solution for me in this case, I have to stick to using Criteria.

Thanks for the help,
alexis