Hello Phuwarin,
what JBoss version are you using? Looks like it misses these
functions.
alex
Tuesday, September 24, 2002, 5:50:13 AM, you wrote:
PSsc> Hi Dain,
PSsc> I got the error message when using this command:
PSsc> SELECT Object(r) FROM Role as r WHERE UCASE(r.roleDesc)
PSsc> LIKE CONCAT(UCASE(?1),'%')
PSsc> 09:21:35,125 WARN [ServiceController] Problem starting service
PSsc> jboss.j2ee:servi
PSsc> ce=EJB,jndiName=RoleRemoteHome
PSsc> org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested
PSsc> throwa
PSsc> ble: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ucase"
PSsc> at lin
PSsc> e 1, column 39.
PSsc> Was expecting one of:
PSsc> "NOT" ...
PSsc> "(" ...
PSsc> <COLLECTION_VALUED_PATH> ...
PSsc> <STRING_VALUED_PATH> ...
PSsc> "CONCAT" ...
PSsc> "SUBSTRING" ...
PSsc> <BOOLEAN_VALUED_PATH> ...
PSsc> <DATETIME_VALUED_PATH> ...
PSsc> <ENTITY_VALUED_PATH> ...
PSsc> <IDENTIFICATION_VARIABLE> ...
PSsc> <NUMERIC_VALUED_PATH> ...
PSsc> "LENGTH" ...
PSsc> "LOCATE" ...
PSsc> "ABS" ...
PSsc> "SQRT" ...
PSsc> "+" ...
PSsc> "-" ...
PSsc> <INTEGER_LITERAL> ...
PSsc> <FLOATING_POINT_LITERAL> ...
PSsc> <NUMERIC_VALUED_PARAMETER> ...
PSsc> )
PSsc> But when I remove the UCASE command, I got anther error message:
PSsc> SELECT Object(r) FROM Role as r WHERE r.roleDesc LIKE
PSsc> CONCAT(?1,'%')
PSsc> 09:29:54,153 WARN [ServiceController] Problem starting service
PSsc> jboss.j2ee:servi
PSsc> ce=EJB,jndiName=RoleRemoteHome
PSsc> org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested
PSsc> throwa
PSsc> ble: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "CONCAT"
PSsc> at li
PSsc> ne 1, column 55.
PSsc> Was expecting:
PSsc> <STRING_LITERAL> ...
PSsc> )
PSsc> Any suggestion or comment?
PSsc> Thanks,
PSsc> -phu
PSsc> Dain Sundstrom
PSsc> <[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
PSsc> Sent by: cc:
PSsc> [EMAIL PROTECTED] Subject: Re:
[JBoss-user] EJB-QL For LIKE
PSsc> eforge.net
PSsc> No Phone Info Available
PSsc> 09/23/2002 09:56 PM
PSsc> Please respond to jboss-user
PSsc> Anthony Geoghegan wrote:
>> EJB-QL does not support like statements with input parameters:
>> It's to do with CMP field's data type not being known till runtime. Thus
PSsc> the
>> like comparison can only be used on string literals
PSsc> Not really. The spec guys wanted to support feature poor (i.e., crappy)
PSsc> datastores, so they crippled EJB-QL. Parameters in LIKE clauses will be
PSsc> supported in EJB 2.1.
>> Example:
>>
>> SELECT OBJECT(o) FROM Orders AS o WHERE o.customer LIKE '%Bloggs%'
>> See no input parameters.
>>
>> However JBossQL and certainly DeclaredSQL may provide a better avenue for
>> you to pursue if this is what you want.
PSsc> You can do this today in JBossQL. I would guess you want something like
PSsc> this:
PSsc> SELECT Object(t)
PSsc> FROM tableName t
PSsc> WHERE UCASE(t.firstName) LIKE CONCAT(UCASE(?1), '%')
PSsc> -dain
-------------------------------------------------------
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
