We have the following select statement in an Entity Bean:
* @ejb:select signature="Collection ejbSelectAlleIkkeOppdaterteIDesk()"
* query="SELECT OBJECT(k) FROM Kunde AS k WHERE k.tilstand = 1 AND
k.rtgsStatus = false AND k.tillatLaaneadgang = '0'"
But JBoss-3.2.1 does not like it:
2003-09-15 09:20:33,100 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Kunde.findAlleKunder] SQL: SELECT
t0_k.id FROM KUNDE t0_k WHERE t0_k.tilstand = 1
2003-09-15 09:20:33,101 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.Kunde.ejbSelectAlleIkkeOppdaterteIDesk]
EJB-QL: SELECT OBJECT(k) FROM Kunde AS k
WHERE k.tilstand = 1 AND k.rtgsStatus = false AND k.tillatLaaneadgang = '0'
2003-09-15 09:20:33,190 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
2003-09-15 09:20:33,196 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2003-09-15 09:20:33,196 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2003-09-15 09:20:33,205 ERROR [org.jboss.ejb.EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT
OBJECT(k) FROM Kunde AS k WHERE k.tilstand = 1 AND k.rtgsStatus = false AND
k.tillatLaaneadgang = '0''; - nested throwable:
(org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "\'0\'" at line 1, column
106.
Was expecting one of:
"ABS" ...
"LENGTH" ...
"LOCATE" ...
"SQRT" ...
"(" ...
"+" ...
"-" ...
<INTEGER_LITERAL> ...
<FLOATING_POINT_LITERAL> ...
<NUMERIC_VALUED_PARAMETER> ...
<NUMERIC_VALUED_PATH> ...
)
Looking into the specification, ejb-2_0-fr2-spec.pdf, I find this
strange. Anyone know what the proble is? (In the Oracle schema, the
field tillatLaaneadgang is defined as char(1).
--
Jon Haugsand, [EMAIL PROTECTED]
http://www.norges-bank.no
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
