- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- EJB-QL Problem
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
EJB-QL Problem
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 06-01-2005 5:16 PM
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
- SAP Managed Tags:
- SAP NetWeaver Application Server for Java
Accepted Solutions (1)
Accepted Solutions (1)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answers (4)
Answers (4)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SidBhattacharya
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Looks like an error in ur query definition
Try this
SELECT OBJECT(p) FROM UsersBean as p WHERE p.name=?1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Integrate an external task system to Cloud ALM. in Technology Q&A
- SAP Document and Reporting Compliance - 'Colombia' - Contingency Process in Technology Blogs by SAP
- Empty Result Array Issue in Business Rules Service for Partner Creation Approval Process in Technology Q&A
- Can I add two variable (Page variable and data variable) in a component? in Technology Q&A
- GOS problem => read local file before opening menu in Technology Q&A
| User | Count |
|---|---|
| 94 | |
| 11 | |
| 11 | |
| 10 | |
| 9 | |
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.