Solved: EJB-QL Problem

Former Member · ‎2005 Jun 01

Hi again,

I'm getting an error while trying to query my database through a deployed webservice (ejb).

My EJB-QL Statement from my ejb-jar.xml:

[code]SELECT OBJECT(p) FROM UsersBean p WHERE p.name=?1[/code]

Getting following error:

=====

[code]com.sap.engine.services.ejb.exceptions.BaseRemoteException: Exception in method getUser.

at com.dcx.mcg.itp.aa.projects.eeim.beans.DataObjectImpl0.getUser(DataObjectImpl0.java:474)

at com.dcx.mcg.itp.aa.projects.eeim.beans.Data_Stub.getUser(Data_Stub.java:316)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187)

at $Proxy401.getUser(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:146)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:68)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:92)

at SoapServlet.doPost(SoapServlet.java:51)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:340)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:318)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:821)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:239)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

Caused by: com.sap.engine.services.ejb.exceptions.BaseTransactionRolledbackLocalException: Exception in method com.dcx.mcg.itp.aa.projects.eeim.beans.UsersLocalHomeImpl0.findByName(java.lang.String).

at com.dcx.mcg.itp.aa.projects.eeim.beans.UsersLocalHomeImpl0.findByName(UsersLocalHomeImpl0.java:1058)

at com.dcx.mcg.itp.aa.projects.eeim.beans.DataBean.getUser(DataBean.java:411)

at com.dcx.mcg.itp.aa.projects.eeim.beans.DataObjectImpl0.getUser(DataObjectImpl0.java:446)

... 32 more

Caused by: com.sap.engine.services.ejb.exceptions.BaseEJBException: Exception in method UsersBean0.FindByName(java.lang.String).

at com.dcx.mcg.itp.aa.projects.eeim.beans.UsersBean0PM.ejbFindByName(UsersBean0PM.java:456)

at com.dcx.mcg.itp.aa.projects.eeim.beans.UsersLocalHomeImpl0.findByName(UsersLocalHomeImpl0.java:1023)

... 34 more

Caused by: com.sap.sql.log.OpenSQLException: The SQL statement "SELECT "P"."ID" FROM "DCX_EEIM_USERS" "P" WHERE "P"."NAME" = ?" contains the semantics error[s]: type check error: the expression >>"P"."NAME"<< (CLOB) is not comparable and must not be used with "="

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:145)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:46)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:126)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:109)

at com.sap.sql.jdbc.common.CommonPreparedStatement.<init>(CommonPreparedStatement.java:154)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:306)

at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81)

at com.dcx.mcg.itp.aa.projects.eeim.beans.UsersBean0PM.ejbFindByName(UsersBean0PM.java:395)

... 35 more

Caused by: com.sap.sql.sqlparser.CommonSQLParserException: type check error: the expression >>"P"."NAME"<< (CLOB) is not comparable and must not be used with "="

at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:203)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:42)

... 41 more

; nested exception is:

javax.ejb.TransactionRolledbackLocalException: com.sap.engine.services.ejb.exceptions.BaseTransactionRolledbackLocalException: Exception in method com.dcx.mcg.itp.aa.projects.eeim.beans.UsersLocalHomeImpl0.findByName(java.lang.String).