WLW: Making multiple method calls to a JDBC control from a single pageflow method.
(Doc ID 1149754.1)
Last updated on FEBRUARY 10, 2022
Applies to:
Oracle Workshop for Weblogic - Version 9.1 to 10.3 [Release Weblogic Platform to AS10gR3]Information in this document applies to any platform.
Symptoms
Users who upgrade an 8.x application to a 9.x/10.x application may experience issues in making multiple method calls to a JDBC control from a single page flow method.
Below is the exception trace:
java.sql.SQLException: The transaction is no longer active - status: 'Committed'. No further JDBC access is allowed within this transaction.
at weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:178)
at weblogic.jdbc.wrapper.JTSConnection.checkConnection(JTSConnection.java:188)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:92)
at weblogic.jdbc.wrapper.Connection.getMetaData(Connection.java:422)
at org.apache.beehive.controls.system.jdbc.parser.SqlStatement.createPreparedStatement(SqlStatement.java:129)
at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:274)
at com.bea.wlw.runtime.core.control.internal.JdbcControlImpl.invoke(JdbcControlImpl.java:139)
at com.verizon.vbuild.ctl.db.test.testDbBean.insertTest(testDbBean.java:123)
at com.verizon.vbuild.ctl.custom.test.testImpl.createTestEmployee1(testImpl.java:37)
at com.verizon.vbuild.ctl.custom.test.testBean.createTestEmployee1(testBean.java:175)
at resources.testCommon.TestCommonController.begin(TestCommonController.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
.....
at weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:178)
at weblogic.jdbc.wrapper.JTSConnection.checkConnection(JTSConnection.java:188)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:92)
at weblogic.jdbc.wrapper.Connection.getMetaData(Connection.java:422)
at org.apache.beehive.controls.system.jdbc.parser.SqlStatement.createPreparedStatement(SqlStatement.java:129)
at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:274)
at com.bea.wlw.runtime.core.control.internal.JdbcControlImpl.invoke(JdbcControlImpl.java:139)
at com.verizon.vbuild.ctl.db.test.testDbBean.insertTest(testDbBean.java:123)
at com.verizon.vbuild.ctl.custom.test.testImpl.createTestEmployee1(testImpl.java:37)
at com.verizon.vbuild.ctl.custom.test.testBean.createTestEmployee1(testBean.java:175)
at resources.testCommon.TestCommonController.begin(TestCommonController.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
.....
Changes
Upgrade from WLW 8.1 to WLW 9.x / WLW10.x.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |