Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

JBO-27122 SQL error during Statement preparation

254 views

Skip to first unread message

Jeff

unread,

Mar 28, 2006, 4:02:31 PM3/28/06

I currently have an app developed on JDeveloper 9.0.3 and deployed to
WebSphere 5.1
The first time access this page it works correctly, the second time it
throws this error.

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement
preparation. Statement: SELECT Product.APPNAME,
Product.PRODID, Product.DESCRIPTION, Product.PRICE,
Product.THUMBNAIL, Product.DESCRIPTION_ES,
Product.DESCRIPTION_FR FROM ETC.ECOM_PRODUCT Product WHERE
(SPECIALCHARGE <> 'Y' OR SPECIALCHARGE IS NULL) AND APPNAME = ? AND
((DISABLED <> 'Y' OR DISABLED IS NULL)) ORDER BY PRODID
at
oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:576)
at
oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:2837)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:539)
at
oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:586)
at
oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:2801)
at
oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:2788)
at
com.etc.oesys.onlinestore.DisplayPagedDataAction.setupPaging(DisplayPagedDataAction.java:176)
at
com.etc.oesys.onlinestore.DisplayPagedDataAction.setupPage(DisplayPagedDataAction.java:29)
at
com.etc.oesys.onlinestore.controller.ShowProductsAction.execute(ShowProductsAction.java:61)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.processActionPerform(CustomRequestProcessor.java:80)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.process(CustomRequestProcessor.java:148)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.etc.oesys.onlinestore.CustomActionServlet.process(CustomActionServlet.java:88)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java:333)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1014)
at
org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:961)
at
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:544)
at
oracle.jbo.html.struts11.BC4JRequestProcessor.processForward(BC4JRequestProcessor.java:67)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:252)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.process(CustomRequestProcessor.java:148)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.etc.oesys.onlinestore.CustomActionServlet.process(CustomActionServlet.java:88)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
## Detail 0 ##
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is
closed.
at
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.setMaxRows(WSJdbcStatement.java:1090)
at
oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:538)
at
oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:2837)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:539)
at
oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:586)
at
oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:2801)
at
oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:2788)
at
com.etc.oesys.onlinestore.DisplayPagedDataAction.setupPaging(DisplayPagedDataAction.java:176)
at
com.etc.oesys.onlinestore.DisplayPagedDataAction.setupPage(DisplayPagedDataAction.java:29)
at
com.etc.oesys.onlinestore.controller.ShowProductsAction.execute(ShowProductsAction.java:61)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.processActionPerform(CustomRequestProcessor.java:80)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.process(CustomRequestProcessor.java:148)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.etc.oesys.onlinestore.CustomActionServlet.process(CustomActionServlet.java:88)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.ServicingServletState.service(StrictLifecycleServlet.java:333)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1014)
at
org.apache.struts.action.RequestProcessor.internalModuleRelativeForward(RequestProcessor.java:961)
at
org.apache.struts.action.RequestProcessor.processForward(RequestProcessor.java:544)
at
oracle.jbo.html.struts11.BC4JRequestProcessor.processForward(BC4JRequestProcessor.java:67)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:252)
at
com.etc.oesys.onlinestore.CustomRequestProcessor.process(CustomRequestProcessor.java:148)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.etc.oesys.onlinestore.CustomActionServlet.process(CustomActionServlet.java:88)
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at
com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

0 new messages