aspose file tools*
The moose likes Websphere and the fly likes I am getting sql error while retrive the data from server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "I am getting sql error while retrive the data from server " Watch "I am getting sql error while retrive the data from server " New topic
Author

I am getting sql error while retrive the data from server

sachin pate
Greenhorn

Joined: May 03, 2013
Posts: 18
Tue Sep 10 17:19:41 GMT+05:30 2013: < PartInfoManager > <ERROR> <getPartDetails> SQLException occurred[ com.ibm.db2.jcc.b.SqlException -- DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null ]
Stacktrace Begins--->

com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null
at com.ibm.db2.jcc.b.id.e(id.java:1640)
at com.ibm.db2.jcc.b.jd.a(jd.java:1716)
at com.ibm.db2.jcc.c.fb.a(fb.java:200)
at com.ibm.db2.jcc.c.fb.b(fb.java:88)
at com.ibm.db2.jcc.c.s.b(s.java:60)
at com.ibm.db2.jcc.c.xb.d(xb.java:293)
at com.ibm.db2.jcc.b.jd.bb(jd.java:1709)
at com.ibm.db2.jcc.b.jd.eb(jd.java:1780)
at com.ibm.db2.jcc.b.jd.a(jd.java:2232)
at com.ibm.db2.jcc.b.jd.V(jd.java:505)
at com.ibm.db2.jcc.b.jd.executeQuery(jd.java:488)
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java:484)
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:515)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:156)
at com.dcx.eng.eengp.psv.ejb.part.PartInfoManagerEJB.getPartDetails(PartInfoManagerEJB.java:1984)
at com.dcx.eng.eengp.psv.ejb.part.EJSRemoteStatelessPartInfoManager_f259ce7c.getPartDetails(EJSRemoteStatelessPartInfoManager_f259ce7c.java:32)
at com.dcx.eng.eengp.psv.ejb.part._PartInfoManager_Stub.getPartDetails(_PartInfoManager_Stub.java:551)
at com.dcx.eng.eengp.psv.psvInterface.PartAccess.getPartDetails(PartAccess.java:229)
at com.dcx.eng.eengp.psv.psvInterface.PSVIIOPInterfaceImpl.getPartDetails(PSVIIOPInterfaceImpl.java:349)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.getPartDetails(PartInfoController.java:1468)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.thisPage_onenter(PartInfoController.java:732)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager._fireEvent(HttpEventManager.java:371)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager.fireEvent(HttpEventManager.java:258)
at com.dcx.eng.eengp.psv.helper.html.HttpPm.StartPageProcessing(HttpPm.java:284)
at com.dcx.eng.eengp.psv.servlets.BaseController.service(BaseController.java:172)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)

<---Stacktrace Ends

Tue Sep 10 17:19:41 GMT+05:30 2013: < PartInfoManager > <ERROR> <getPartDetails> Exception occurred[ com.dcx.eng.eengp.psv.utils.EEngPException -- null ]
Stacktrace Begins--->

com.dcx.eng.eengp.psv.utils.EEngPException
at com.dcx.eng.eengp.psv.ejb.part.PartInfoManagerEJB.getPartDetails(PartInfoManagerEJB.java:2014)
at com.dcx.eng.eengp.psv.ejb.part.EJSRemoteStatelessPartInfoManager_f259ce7c.getPartDetails(EJSRemoteStatelessPartInfoManager_f259ce7c.java:32)
at com.dcx.eng.eengp.psv.ejb.part._PartInfoManager_Stub.getPartDetails(_PartInfoManager_Stub.java:551)
at com.dcx.eng.eengp.psv.psvInterface.PartAccess.getPartDetails(PartAccess.java:229)
at com.dcx.eng.eengp.psv.psvInterface.PSVIIOPInterfaceImpl.getPartDetails(PSVIIOPInterfaceImpl.java:349)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.getPartDetails(PartInfoController.java:1468)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.thisPage_onenter(PartInfoController.java:732)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager._fireEvent(HttpEventManager.java:371)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager.fireEvent(HttpEventManager.java:258)
at com.dcx.eng.eengp.psv.helper.html.HttpPm.StartPageProcessing(HttpPm.java:284)
at com.dcx.eng.eengp.psv.servlets.BaseController.service(BaseController.java:172)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)

<---Stacktrace Ends

Nested Stacktrace Begins--->

com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null
at com.ibm.db2.jcc.b.id.e(id.java:1640)
at com.ibm.db2.jcc.b.jd.a(jd.java:1716)
at com.ibm.db2.jcc.c.fb.a(fb.java:200)
at com.ibm.db2.jcc.c.fb.b(fb.java:88)
at com.ibm.db2.jcc.c.s.b(s.java:60)
at com.ibm.db2.jcc.c.xb.d(xb.java:293)
at com.ibm.db2.jcc.b.jd.bb(jd.java:1709)
at com.ibm.db2.jcc.b.jd.eb(jd.java:1780)
at com.ibm.db2.jcc.b.jd.a(jd.java:2232)
at com.ibm.db2.jcc.b.jd.V(jd.java:505)
at com.ibm.db2.jcc.b.jd.executeQuery(jd.java:488)
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java:484)
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:515)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:156)
at com.dcx.eng.eengp.psv.ejb.part.PartInfoManagerEJB.getPartDetails(PartInfoManagerEJB.java:1984)
at com.dcx.eng.eengp.psv.ejb.part.EJSRemoteStatelessPartInfoManager_f259ce7c.getPartDetails(EJSRemoteStatelessPartInfoManager_f259ce7c.java:32)
at com.dcx.eng.eengp.psv.ejb.part._PartInfoManager_Stub.getPartDetails(_PartInfoManager_Stub.java:551)
at com.dcx.eng.eengp.psv.psvInterface.PartAccess.getPartDetails(PartAccess.java:229)
at com.dcx.eng.eengp.psv.psvInterface.PSVIIOPInterfaceImpl.getPartDetails(PSVIIOPInterfaceImpl.java:349)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.getPartDetails(PartInfoController.java:1468)
at com.dcx.eng.eengp.psv.servlets.PartInfoController.thisPage_onenter(PartInfoController.java:732)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager._fireEvent(HttpEventManager.java:371)
at com.dcx.eng.eengp.psv.helper.html.HttpEventManager.fireEvent(HttpEventManager.java:258)
at com.dcx.eng.eengp.psv.helper.html.HttpPm.StartPageProcessing(HttpPm.java:284)
at com.dcx.eng.eengp.psv.servlets.BaseController.service(BaseController.java:172)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1443)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1772)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)

<--- Nested Stacktrace Ends
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29261
    
140

The -516 error is the most important part of that message. Here's the documentation for that error which says "THE DESCRIBE STATEMENT DOES NOT SPECIFY A PREPARED STATEMENT".

It seems odd your EJB would have "describe" in the SQL. Can you post the SQL that comes from that EJB?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I am getting sql error while retrive the data from server
 
Similar Threads
Web service throws “Could not create default AuthenticationToken during propagation login”
out of memory issue in jsp
Could not find FacesContextFactory on WAS 7.0
NoSuchMethodException: does not contain handler
GuardedMessageContext incompatible with MessageContext