sorry for stupid question, but didn't you accidently add '(' when formatted for
readability?
you can also remove brackets around IS NULL expression.
alex
Monday, January 27, 2003, 12:48:06 PM, you wrote:
JH> Is anyone able to tell me what is wrong with the following ejbql
JH> expression (formatted for readability):
JH> <ejb-ql><![CDATA[
JH> SELECT OBJECT(p) FROM Pant AS p, Verdipapir AS vp
JH> WHERE ( p.tilstand = 1 OR p.tilstand = 3 ) AND
JH> ( p.uttrekningsDato IS NOT NULL ) AND
JH> ( p.isin = vp.isin ) AND
JH> ( vp.tilstand = 1 OR vp.tilstand = 3 ) AND
JH> ( ( vp.forfallsDato IS NULL ) OR vp.forfallsDato >= ?1 )]]>
JH> </ejb-ql>
JH> It fails with the following:
JH> 11:41:44,830 WARN [ServiceController] Problem starting service
jboss.j2ee:service=EJB,jndiName=norgesbank/bank/sil/entiteter/verdipapir/VerdipapirLocal
JH> org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested
throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered
"vp.forfallsDato IS NULL ) OR vp.forfallsDato >="
JH> at line 1, column 211.
JH> Was expecting one of:
JH> "ABS" ...
JH> "LENGTH" ...
JH> "LOCATE" ...
JH> "SQRT" ...
JH> "(" ...
JH> "+" ...
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
