4 Replies Latest reply: Jul 16, 2014 9:48 AM by Joe Weinstein-Oracle RSS

    Weblogic 12.1.3 JDBC driver

    ArashJ

      I migrated our application from 12.1.2 ADF to 12.1.3 and we have issues, a possible cause can be JDBC 4.1 , I want to use JDBC 4.0 driver for our datasource, I found ojdbc6.jar file in WLS 12.1.3 too, if this is JDBC 4.0 how can I use it ,if not and I copy over ojdbc6.jar from 12.1.2 ADF ,how can I define it in datasource list of drivers.

        • 1. Re: Weblogic 12.1.3 JDBC driver
          Joe Weinstein-Oracle

          Show some info about your actual symptoms. What WLS version was your app working in?

          • 2. Re: Weblogic 12.1.3 JDBC driver
            ArashJ

            Hi Joe,


            our app is working on ADF 12.1.2 with proxy user but it doesnt work on ADF 12.1.3, I logged issue in ADF forum but no luck only problem could be JDBC difference , casue we get follwoing exceptions:

             

             

             

            <oracle.adf.model> <DBTransactionImpl> <closeTransaction> <[1532] *** closing jdbc connection now **** (weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@36)>

            <oracle.adf.model> <DBTransactionImpl> <createPreparedStatement> <[1533] DBTransactionImpl.createPreparedStatement failed...>

            <oracle.adf.model> <DBTransactionImpl> <createPreparedStatement> <[1534] java.sql.SQLException: Closed Statement

            at oracle.jdbc.driver.OracleClosedStatement.setFetchSize(OracleClosedStatement.java:6214)

            at oracle.jdbc.driver.OracleStatementWrapper.setFetchSize(OracleStatementWrapper.java:282)

            at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setFetchSize(Unknown Source)

            at oracle.jbo.server.OracleSQLBuilderImpl.doStatementSetRowPrefetch(OracleSQLBuilderImpl.java:1206)

            at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3748)

            at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:398)

            at com.enlogix.commonmodelcode.frwkext.CustomAppModuleImpl.beforeDisconnect(CustomAppModuleImpl.java:201)

            at oracle.jbo.server.ApplicationModuleImpl.callBeforeDisconnect(ApplicationModuleImpl.java:7582)

            at oracle.jbo.server.DBTransactionImpl.closeTransaction(DBTransactionImpl.java:1545)

            at oracle.jbo.server.DBTransactionImpl.disconnect(DBTransactionImpl.java:5585)

            at oracle.jbo.server.DBTransactionImpl2.disconnect(DBTransactionImpl2.java:364)

            at oracle.jbo.server.DBTransactionImpl.disconnect(DBTransactionImpl.java:5861)

            at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:446)

            at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9542)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4526)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.finalizeResource(ApplicationPoolImpl.java:1337)

            at oracle.jbo.pool.ResourcePool.removeResourceInternal(ResourcePool.java:851)

            at oracle.jbo.pool.ResourcePool.setState(ResourcePool.java:1168)

            at oracle.jbo.pool.ResourcePool.removeResource(ResourcePool.java:863)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.removeDeadInstance(ApplicationPoolImpl.java:2652)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4557)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2453)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2263)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2298)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3162)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:590)

            at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:224)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:523)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:518)

            at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1507)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1398)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1366)

            at parameters.ProxyAuthUserLoginBean.performProxyUserLogin(ProxyAuthUserLoginBean.java:133)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

            at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

            at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

            at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)

            at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

            at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)

            at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

            at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

            at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

            at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

            at java.security.AccessController.doPrivileged(Native Method)

            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

            at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

            >

            <oracle.adf.model> <DBTransactionImpl> <processConnProperties> <[1535] mPCollUsePMgr is false>

            <oracle.adf.model> <DBTransactionImpl> <processConnProperties> <[1536] ViewObjectImpl.mDefaultMaxRowsPerNode is 70>

            <oracle.adf.model> <DBTransactionImpl> <processConnProperties> <[1537] ViewObjectImpl.mDefaultMaxActiveNodes is 30>

            <oracle.adf.model> <DBTransactionImpl> <processProperties> <[1538] Default locking mode changed to: optimistic>

            <oracle.adf.model> <ApplicationPoolImpl> <prepareApplicationModule> <[1539] An exception occured during checkout.>

            <oracle.adf.model> <ApplicationPoolImpl> <prepareApplicationModule> <[1540] oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: rollback

            at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3773)

            at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:398)

            at com.enlogix.commonmodelcode.frwkext.CustomAppModuleImpl.prepareSession(CustomAppModuleImpl.java:140)

            at oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:7088)

            at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:170)

            at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9542)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4526)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2453)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2263)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2298)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3162)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:590)

            at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:224)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:523)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:518)

            at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1507)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1398)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1366)

            at parameters.ProxyAuthUserLoginBean.performProxyUserLogin(ProxyAuthUserLoginBean.java:133)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

            at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

            at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

            at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)

            at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

            at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)

            at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

            at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

            at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

            at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

            at java.security.AccessController.doPrivileged(Native Method)

            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

            at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

            Caused by: java.sql.SQLException: Closed Statement

            at oracle.jdbc.driver.OracleClosedStatement.setFetchSize(OracleClosedStatement.java:6214)

            at oracle.jdbc.driver.OracleStatementWrapper.setFetchSize(OracleStatementWrapper.java:282)

            at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setFetchSize(Unknown Source)

            at oracle.jbo.server.OracleSQLBuilderImpl.doStatementSetRowPrefetch(OracleSQLBuilderImpl.java:1206)

            at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3748)

            ... 90 more

            ## Detail 0 ##

            java.sql.SQLException: Closed Statement

            at oracle.jdbc.driver.OracleClosedStatement.setFetchSize(OracleClosedStatement.java:6214)

            at oracle.jdbc.driver.OracleStatementWrapper.setFetchSize(OracleStatementWrapper.java:282)

            at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_OraclePreparedStatementWrapper.setFetchSize(Unknown Source)

            at oracle.jbo.server.OracleSQLBuilderImpl.doStatementSetRowPrefetch(OracleSQLBuilderImpl.java:1206)

            at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3748)

            at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:398)

            at com.enlogix.commonmodelcode.frwkext.CustomAppModuleImpl.prepareSession(CustomAppModuleImpl.java:140)

            at oracle.jbo.server.ApplicationModuleImpl.prepareSession(ApplicationModuleImpl.java:7088)

            at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:170)

            at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9542)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4526)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2453)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2263)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2298)

            at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3162)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:590)

            at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:224)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:523)

            at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:518)

            at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1507)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1398)

            at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1366)

            at parameters.ProxyAuthUserLoginBean.performProxyUserLogin(ProxyAuthUserLoginBean.java:133)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

            at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

            at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

            at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)

            at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

            at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)

            at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)

            at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)

            at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)

            at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)

            at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

            at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

            at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

            at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

            at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

            at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

            at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

            at java.security.AccessController.doPrivileged(Native Method)

            at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

            at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

            at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

            at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

            at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

            at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

            at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

            >

            JBO-27122: SQL error during statement preparation.  Statement: rollback

            <org.apache.myfaces.trinidadinternal.renderkit.core.StyleContextImpl> <StyleContextImpl> <isDisableStyleCompression> <DISABLE_CONTENT_COMPRESSION_IN_PRODUCTION_STAGE>

            <org.apache.myfaces.trinidadinternal.skin.SkinImpl> <SkinImpl> <_isContentCompressionDisabled> <DISABLE_CONTENT_COMPRESSION_IN_PRODUCTION_STAGE>

            • 3. Re: Weblogic 12.1.3 JDBC driver
              ArashJ

              Thanks Joe. I found the casue and now it is working. we need to set statement cache size to 0, but in 12.1.2 we didnt need to do it.

              • 4. Re: Weblogic 12.1.3 JDBC driver
                Joe Weinstein-Oracle

                OK, if that workaround is fine for you, good, but the symptoms indicate a problem to debug.