Re: [JBoss-user] Problem with JBoss and ejbql
* Jon Haugsand Is anyone able to tell me what is wrong with the following ejbql expression (formatted for readability): ejb-ql![CDATA[ SELECT OBJECT(p) FROM Pant AS p, Verdipapir AS vp WHERE ( p.tilstand = 1 OR p.tilstand = 3 ) AND ( p.uttrekningsDato IS NOT NULL ) AND ( p.isin = vp.isin ) AND ( vp.tilstand = 1 OR vp.tilstand = 3 ) AND ( ( vp.forfallsDato IS NULL ) OR vp.forfallsDato = ?1 )]] /ejb-ql It seems as = is not allowed. It worked when I changed into vp.forfallsDato ?1 OR vp.forfallsDato = ?1. -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no --- 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
Re: [JBoss-user] Problem with JBoss and ejbql
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
Re: [JBoss-user] Problem with JBoss and ejbql
* Alex Loubyansky
sorry for stupid question, but didn't you accidently add '(' when formatted for
readability?
you can also remove brackets around IS NULL expression.
Actually, I originally did not have the parenthesis, but I included them
and retried against JBoss. So, no, I did not include them just now.
(The warning text also says so:
Encountered vp.forfallsDato IS NULL ) OR ...)
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 + ...
--
Jon Haugsand, [EMAIL PROTECTED]
http://www.norges-bank.no
---
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
