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
>