It is expecting a number not a string.
Regards,
Adrian
On Mon, 2003-09-15 at 08:54, Jon Haugsand wrote:
> 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).
--
xxxxxxxxxxxxxxxxxxxxxxxx
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
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
