On Monday 14 January 2002 19:22, Dain Sundstrom wrote:
> The reason you are not getting a where clause is because your where clause
> is invalid. The engine does not throw an exceptions when it can't parse a
> statement (this is a bug). EJB-QL does not allow the '>=' operator for
> datetime types. The BNF follows:
>
Bingo. I did glance through the BNF but only looking at operand types and
whether input parameters are supported.
Thanks.
Peter
> comparison_expression ::=
> string_value { =|<>} string_expression |
> boolean_value { =|<>} boolean_expression} |
> datetime_value { = | <> | > | < } datetime_expression |
> entity_bean_value { = | <> } entity_bean_expression |
> arithmetic_value comparison_operator single_value_designator
>
> As for the statement "Date and time values should use standard Java long
> milliseconds value," this didn't make much sense to me. I use the JBoss
> JDBC type mapping to set the parameters, so it should work.
>
> -dain
>
> > -----Original Message-----
> > From: Peter Levart [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 14, 2002 11:59 AM
> > To: [EMAIL PROTECTED]
> > Subject: [JBoss-dev] EJB QL parser bug?
> >
> >
> > The following is writen to the server.log for one of my CMP
> > 2.0 finder
> > methods (CVS jboss3.0alpha) during deployment:
> >
> > 2002-01-14 17:46:40,443 DEBUG
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContactBean.fin
> > dInDatetimeRange]
> > EQL-QL: SELECT DISTINCT OBJECT(c) FROM Contact AS c WHERE
> > c.datetime >= ?1
> > AND c.datetime < ?2
> > 2002-01-14 17:46:41,098 DEBUG
> > [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ContactBean.fin
> > dInDatetimeRange]
> > SQL: SELECT DISTINCT t1_c.id FROM ContactBean t1_c
> >
> >
> > ...Where is the "WHERE" caluse in the SQL? Can this be a bug
> > or am I missing
> > something?
> >
> > Does anybody know how to interpret the following EJB 2.0
> > spec. statement
> > (11.2.11 Restrictions):
> >
> > "Date and time values should use standard Java long
> > milliseconds value."
> >
> > This is "very" precise, I must say. X values should use Y
> > value, hm....
> >
> > Does this mean that parameters to findXXX methods should be
> > "long" type when
> > used in date and time comparisons in EJB QL? What type of
> > parameters does
> > JBossCMP expect (accept) when used in such comparisons?
> >
> > I tried the following:
> >
> > <query>
> > <query-method>
> > <method-name>findInDatetimeRange</method-name>
> > <method-params>
> > <method-param>long</method-param>
> > <method-param>long</method-param>
> > </method-params>
> > </query-method>
> >
> > <result-type-mapping>Local</result-type-mapping>
> >
> > <ejb-ql>SELECT DISTINCT OBJECT(c) FROM Contact AS c WHERE
> > c.datetime >= ?1 AND c.datetime < ?2</ejb-ql>
> > </query>
> >
> > and the following:
> >
> > <query>
> > <query-method>
> > <method-name>findInDatetimeRange</method-name>
> > <method-params>
> > <method-param>java.util.Date</method-param>
> > <method-param>java.util.Date</method-param>
> > </method-params>
> > </query-method>
> >
> > <result-type-mapping>Local</result-type-mapping>
> >
> > <ejb-ql>SELECT DISTINCT OBJECT(c) FROM Contact AS c WHERE
> > c.datetime >= ?1 AND c.datetime < ?2</ejb-ql>
> > </query>
> >
> > and even the following:
> >
> > <query>
> > <query-method>
> > <method-name>findInDatetimeRange</method-name>
> > <method-params>
> > <method-param>java.sql.Timestamp</method-param>
> > <method-param>java.sql.Timestamp</method-param>
> > </method-params>
> > </query-method>
> >
> > <result-type-mapping>Local</result-type-mapping>
> >
> > <ejb-ql>SELECT DISTINCT OBJECT(c) FROM Contact AS c WHERE
> > c.datetime >= ?1 AND c.datetime < ?2</ejb-ql>
> > </query>
> >
> > The "datetime" field in Contact bean is:
> >
> > <cmp-field>
> > <field-name>datetime</field-name>
> > <column-name>datetime</column-name>
> > <sql-type>DATETIME</sql-type>
> > <jdbc-type>TIMESTAMP</jdbc-type>
> > </cmp-field>
> >
> >
> > Entity creation and reading of this fileld work correctly for this
> > configuration...
> >
> > Regards, Peter
> >
> > _______________________________________________
> > Jboss-development mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-development
>
> _______________________________________________
> Jboss-development mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-development
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
