Hi Michael,
Michael Bouschen wrote On 04/03/06 11:12,:
> Hi Marina,
>
>>Graf, Michael,
>>
>>Can it be just an old build problem? The date on the build (from error
>>message) is Jan 04.
>
> I tested this with the latest build and got the same error message.
> Maybe we should simply allow parenthesis around a LIKE argument. I will
> file an ENHANCEMENT issue for this.
This might result in a non-portable application. Can we improve the message
instead?
What do others think?
thanks,
-marina
>
> Regards Michael
>
>
>>
>>thanks,
>>-marina
>>
>>Michael Bouschen wrote:
>>
>>>Hi Graf,
>>>
>>>the error message "unexpected token: LIKE" is misleading.
>>>Please remove the parenthesis around the LIKE argument:
>>> SELECT k FROM Kategoria k WHERE UPPER(k.megnevezes) LIKE :megnevezes
>>>
>>>Regards Michael
>>>
>>>
>>>>Hi Marina
>>>>
>>>>The exception that was throw:
>>>>
>>>>Exception Description: Error encountered when building the
>>>>@NamedQuery [findKategoriakByNameCaseInsensitive] from entity class
>>>>[class gl.exlybris.ejb.kategoria.Kategoria].
>>>>Internal Exception: Exception [TOPLINK-8001] (Oracle TopLink
>>>>Essentials - 10g release 4 (10.1.4.0.0) (Build 060104Dev)):
>>>>oracle.toplink.essentials.exceptions.EJBQLException
>>>>Exception Description: Syntax Recognition Problem parsing the EJBQL
>>>>[SELECT k FROM Kategoria k WHERE UPPER(k.megnevezes) LIKE
>>>>(:megnevezes)]. The parser returned the following [unexpected token:
>>>>LIKE].
>>>>Local Exception Stack:
>>>>Exception [TOPLINK-7158] (Oracle TopLink Essentials - 10g release 4
>>>>(10.1.4.0.0) (Build 060104Dev)):
>>>>oracle.toplink.essentials.exceptions.ValidationException
>>>>Exception Description: Error encountered when building the
>>>>@NamedQuery [findKategoriakByNameCaseInsensitive] from entity class
>>>>[class gl.exlybris.ejb.kategoria.Kategoria].
>>>>Internal Exception: Exception [TOPLINK-8001] (Oracle TopLink
>>>>Essentials - 10g release 4 (10.1.4.0.0) (Build 060104Dev)):
>>>>oracle.toplink.essentials.exceptions.EJBQLException
>>>>Exception Description: Syntax Recognition Problem parsing the EJBQL
>>>>[SELECT k FROM Kategoria k WHERE UPPER(k.megnevezes) LIKE (:nev)].
>>>>The parser returned the following [unexpected token: LIKE].
>>>>
>>>>where 'megnevezes' stands for 'name.
>>>>
>>>>Graf László
>>>>
>>>>
>>>>
>>>>Marina Vatkina wrote:
>>>>
>>>>
>>>>>Graf,
>>>>>
>>>>>UPPER is a supported Java Persistence Query language function.
>>>>>But I don't think it's supported with LIKE:
>>>>>
>>>>>"string_expression [NOT] LIKE pattern_value [ESCAPE escape_character]
>>>>>The string_expression must have a string value. The pattern_value
>>>>>is a string literal or a string-valued
>>>>>input parameter in which an underscore (_) stands for any single
>>>>>character, a percent (%) character
>>>>>stands for any sequence of characters (including the empty
>>>>>sequence), and all other characters stand for
>>>>>themselves."
>>>>>
>>>>>What exception do you get?
>>>>>
>>>>>thanks,
>>>>>-marina
>>>>>
>>>>>Graf László wrote:
>>>>>
>>>>>
>>>>>>Hi Hong,
>>>>>>You were right. There is an error in the server.log.
>>>>>>I used two named queries which contain the UPPER SQL function.
>>>>>>It seams that this is an illegal function for EBQL
>>>>>>
>>>>>>@NamedQueries({
>>>>>>@NamedQuery(name="findKategoriakByNameCaseInsensitive",
>>>>>> query="SELECT k FROM Kategoria k WHERE
>>>>>>UPPER(k.megnevezes) LIKE UPPER(:nev)"),
>>>>>>@NamedQuery(name="findKategoriakByNameCaseSensitive",
>>>>>> query="SELECT k FROM Kategoria k WHERE k.megnevezes
>>>>>>LIKE :nev")
>>>>>>})
>>>>>>
>>>>>>Any suggestion?
>>>>>>
>>>>>>Thank you.
>>>>>>
>>>>>>Graf László
>>>>>>
>>>>>>
>>>>>>
>>>>>>Hong Zhang wrote:
>>>>>>
>>>>>>
>>>>>>>Hi, Graf
>>>>>>> Do you have a sun-application.xml packagd inside the ear and
>>>>>>>it also specifies a context root? If that's the case, the context
>>>>>>>root specified in the sun-application.xml takes high precedence.
>>>>>>> Also did you look at the server.log to check if everything is
>>>>>>>normal, no exceptions, and the web module is loaded at the
>>>>>>>context root as expected?
>>>>>>>
>>>>>>> If you don't have a sun-application.xml and server.log looks
>>>>>>>all normal to you, please attach you application and the
>>>>>>>server.log. I will try it out for you see what I can find out.
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>>- Hong
>>>>>>>
>>>>>>>Graf László wrote:
>>>>>>>
>>>>>>>
>>>>>>>>Hi all,
>>>>>>>>
>>>>>>>>Using a NetBeans 5.5 for Windows and Sun Java System Application
>>>>>>>>Server Platform Edition 9.0 Beta (build b32g) for Linux, I did
>>>>>>>>create an enterprise application named 'exlybris'.
>>>>>>>>
>>>>>>>>The server works fine, I did deploy the application without any
>>>>>>>>problem. This EAR contains an EJB module, named
>>>>>>>>'exlybris-EJBModule.jar', and a web module, named
>>>>>>>>'exlybris-WebModule.war', as you can see in my application.xml
>>>>>>>>below:
>>>>>>>>
>>>>>>>><?xml version="1.0" encoding="UTF-8"?>
>>>>>>>><application version="5"
>>>>>>>>xmlns="http://java.sun.com/xml/ns/javaee"
>>>>>>>>xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>>>>>xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
>>>>>>>>http://java.sun.com/xml/ns/javaee/application_5.xsd">
>>>>>>>> <display-name>exlybris</display-name>
>>>>>>>> <module>
>>>>>>>> <web>
>>>>>>>> <web-uri>exlybris-WebModule.war</web-uri>
>>>>>>>> <context-root>/exlybris-WebModule</context-root>
>>>>>>>> </web>
>>>>>>>> </module>
>>>>>>>> <module>
>>>>>>>> <ejb>exlybris-EJBModule.jar</ejb>
>>>>>>>> </module>
>>>>>>>></application>
>>>>>>>>
>>>>>>>>The EJB module contains three container-managed EJB3 and the WEB
>>>>>>>>module contains a simple index.html only. The server can be
>>>>>>>>reached at the address 'http://ip-address:8080'. My question is,
>>>>>>>>if the context root of my web module is '/exlybris-WebModule',
>>>>>>>>why the server gives me the message
>>>>>>>>
>>>>>>>>
>>>>>>>> HTTP Status 404 -
>>>>>>>>
>>>>>>>>------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>
>>>>>>>>*type* Status report
>>>>>>>>
>>>>>>>>*message*
>>>>>>>>
>>>>>>>>*description* _The requested resource () is not available._
>>>>>>>>
>>>>>>>>------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Sun Java System Application Server Platform Edition 9.0 Beta
>>>>>>>>
>>>>>>>>when I access the URL
>>>>>>>>'http://ip-address:8080/exlybris-WebModule/' ?
>>>>>>>>Please help me.
>>>>>>>>
>>>>>>>>Thank you,
>>>>>>>>
>>>>>>>
>>>>>>>---------------------------------------------------------------------
>>>>>>>
>>>>>>>To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
>>>>>>>For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>>>>>>>
>>>>>>
>>>>>>---------------------------------------------------------------------
>>>>>>To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
>>>>>>For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>>>>>>
>>>>>
>>>>>---------------------------------------------------------------------
>>>>>To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
>>>>>For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>>>>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>