Whats wrong with this NamedQuery ?.

[Steven Rodeo]

Hi Folks,

I have and entity that has the following NamedQuery

@NamedQuery(name = "myQuery", query = "SELECT o FROM HELLOWORLD o WHERE BINARY o.bName LIKE :bName and o.AK = :AK"),

The EAR that contains this Entity is not getting deployed. It fails with the following error. Any Ideas ?..

Exception occured in J2EEC Phase
com.sun.enterprise.deployment.backend.IASDeploymentException:
Exception Description: Syntax error parsing the query [myQuery: SELECT o FROM HELLOWORLD o WHERE BINARY o.bName LIKE :bName and o.AK = :AK], line 1, column 37: unexpected token [BINARY].

Internal Exception: line 1:37: unexpected token: BINARY
at oracle.toplink.essentials.exceptions.EJBQLException.unexpectedToken(EJBQLException.java:389)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.handleANTLRException(EJBQLParser.java:350)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.addError(EJBQLParser.java:278)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.reportError(EJBQLParser.java:378)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.arithmeticPrimary(EJBQLParser.java:3617)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.arithmeticFactor(EJBQLParser.java:3513)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.arithmeticTerm(EJBQLParser.java:3407)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleArithmeticExpression(EJBQLParser.java:1021)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.arithmeticExpression(EJBQLParser.java:2304)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.simpleConditionalExpression(EJBQLParser.java:2282)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalPrimary(EJBQLParser.java:2218)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalFactor(EJBQLParser.java:2155)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalTerm(EJBQLParser.java:2030)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.conditionalExpression(EJBQLParser.java:1989)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.whereClause(EJBQLParser.java:507)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.selectStatement(EJBQLParser.java:184)
at oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParser.document(EJBQLParser.java:135)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.parse(EJBQLParser.java:166)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParseTree(EJBQLParser.java:127)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:215)
at oracle.toplink.essentials.queryframework.EJBQLPlaceHolderQuery.processEjbQLQuery(EJBQLPlaceHolderQuery.java:111)
at oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2059)
at oracle.toplink.essentials.internal.sessions.AbstractSession.processEJBQLQueries(AbstractSession.java:2046)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:724)
at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:604)
at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:280)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:229)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:93)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:126)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:120)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:91)
at com.sun.jdo.spi.persistence.support.ejb.ejbc.PersistenceProcessor.loadPersistenceUnitBundle(PersistenceProcessor.java:513)
at com.sun.jdo.spi.persistence.support.ejb.ejbc.PersistenceProcessor.createTablesInDB(PersistenceProcessor.java:353)

I am trying to deploy this on a glassfish container.

Best Regards
_SR

[Mark Uppeteer]

well it is obviously the 'BINARY' word. Are you sure that that is allowed ?

[Paul Sturrock]

"shoe maker" please check your private messages.

[Steven Rodeo]

Yep I tried executing the exact query on a MySQL DB and it works great!. Any Ideas ?.

[Craig Taylor]

I haven't really used NamedQuery that much so this may be wrong but I believe that you'd need to use NativeQuery as otherwise everything is assumed to be the Hibernate Query Lang... (HQL) syntax.

[Paul Sturrock]

Craig Taylor wrote:I haven't really used NamedQuery that much so this may be wrong but I believe that you'd need to use NativeQuery as otherwise everything is assumed to be the Hibernate Query Lang... (HQL) syntax.

He's not useing Hibernate, but other than that you are spot on I think. BINARY is not an EJBQL keyword.

[Steven Rodeo]

Donno what is the alternative, the whole purpose of this adventure is to, return some MySQL table contents which are case sensitive.

[Paul Sturrock]

Steven Rodeo wrote:

Donno what is the alternative, the whole purpose of this adventure is to, return some MySQL table contents which are case sensitive.

Why does it being case sensitive mean you need to use the binary keyword? In EJBQL you could just use UPPER. Even if you did it in native SQL you could use the upper function.

[Mark Uppeteer]

Could it by any chance be the hibernate dialect property that isn't configured correctly ?

http://lijinjoseji.wordpress.com/2007/01/08/hibernate-dialect-property-for-different-databases/

[Jerwin Louise Uy]

Hi,

The answer is already in the exception -

Internal Exception: line 1:37: unexpected token: BINARY
at oracle.toplink.essentials.exceptions.EJBQLException.unexpectedToken(EJBQLException.java:389) 

BINARY is not valid EJBQL.

Use NativeQuery instead. Note that using functions or proprietary functions in NativeQuery API will not make your application portable (if you decide to swap the DB).

@All
Definitely not using Hibernate. Please take a good look at the exception. Oracle Toplink is an implementation of EJB3.0.


Regards.