hi all,
I'd like how to formulate a query when there is a cmr field involved.
I want a query like this:
* @ejb.finder
* signature="java.util.Collection findInPeriod( int pCalendarId,
java.sql.Date pFromDate, java.sql.Date pToDate )"
* query="SELECT OBJECT(Holyday) FROM WaHolyday Holyday WHERE
(Holyday.calendarId = ?1) AND ((Holyday.absenceDayStart > ?2) AND
(Holyday.absenceDayEnd < ?3 ))"
* result-type-mapping="Local"
in my HolydayBean.
but i also have:
/**
* Retrieves the calendar Id of this holyday.
*
* @return Returns the calendar Id of this holyday.
* @ejb.persistent-field
* @jboss.column-name
* name="calendar_id"
*/
public abstract int getCalendarId();
/**
* Sets the Holyday's calendar.
*
* @param pCalendarId The id of the calendar to assign to
*/
public abstract void setCalendarId(int pCalendarId);
So I've understood that I can't use calendar_id for cmp mapping too.( Am
I right ?)
So how could I formulate the previous query ?
-------------------------------------------------------
This sf.net email is sponsored by: See the NEW Palm
Tungsten T handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user