*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 19
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: 30130
    
150

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
 
 
subject: I am getting sql error while retrive the data from server
 
Similar Threads
Could not find FacesContextFactory on WAS 7.0
NoSuchMethodException: does not contain handler
Web service throws “Could not create default AuthenticationToken during propagation login”
GuardedMessageContext incompatible with MessageContext
out of memory issue in jsp