Yes, that's what I was trying to avoid... :(
I was looking for any way to do a similar thing inside the EQL. I'm using
EJB 2.0, WLS 8.1.
thanks
On EJB 2.1, you can have:
java.util.Collection findByDate(java.util.Date dateBeg, java.util.Date
dateEnd)
And an EQL Query with a predicate:
WHERE myDateField BETWEEN ?1 AND ?2
The code that calls the method:
Date date = ..
MyHome home = .
Calendar c = Calendar.getInstance();
c.setTime(date);
c.set(HOUR_OF_DAY, 0);
c.set(MINUTE, 0);
c.set(SECOND, 0);
c.set(MILLISECOND, 0);
Date dateBeg = c.getTime();
c.add(DAY_OF_MONTH, 1);
Date dateEnd = c.getTime();
Collection bag = home.findByDate(dateBeg, dateEnd);
Also, you can, depending on your server/db, create a SQL statement to do
the same, but it depends a lot on your config
and thus it's not portable.
HTH,
JP
mcrod wrote:
Hi,
I want to query a CMP that has a field Date mapped to an Oracle Date col
table. The data is stored in the database with year, month, day and time.
What I want is, return all registers with a certain year, month and day.
Not
considering the time. The signature must be:
java.util.Collection findByDate(java.util.Date date)
So, as the Date I am passing as a parameter has an empty time, and the
time
is present in the database field, how to build a query that ignores it ?
===
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message signoff EJB-INTEREST. For general help, send email to
[EMAIL PROTECTED] and include in the body of the message help.
