cancel
Showing results for 
Search instead for 
Did you mean: 

EJB-QL Problem

Former Member
0 Kudos
97

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).

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)

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.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

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)

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)

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.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

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)

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

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)

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.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

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)

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)

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

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)

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)[/code]

=====

Regards

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Daniel,

the error is that your column name is declared as CLOB in your DB and not as VARCHAR. CLOB is a not comparable DB type. Try to declare your column as VARCHAR or something like this or contains your column name records with more than 1333 characters

Have also a look here:

http://help.sap.com/saphelp_nw04/helpdata/en/31/8fbc011886498a91eea9f1e68628dc/content.htm

Answers (4)

Answers (4)

Former Member
0 Kudos

Solved the problem finally...

After I set the length of the strings in the dictionary, they where defined after deoployment as VARCHAR2.

Thanks for your hint again, Andre.

Regards

Daniel

Former Member
0 Kudos

Oh thanks André, sounds like the problem.

The problem is:

I'm creating my database tables (on a oracle server) with deploying a dictionary. All CLOB fields are decalred as string there.

Is there any way to map the datatypes or create VARCHAR fields with the dictionary?

Former Member
0 Kudos

Thanks for your answer.

With your statement the query is still NOT working.

Still get following error:

...
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 "=" 
...

Any ideas?

Regards

Daniel

SidBhattacharya
Product and Topic Expert
Product and Topic Expert
0 Kudos

Looks like an error in ur query definition

Try this

SELECT OBJECT(p) FROM UsersBean as p WHERE p.name=?1