WLW: Making multiple method calls to a JDBC control from a single pageflow method. (Doc ID 1149754.1)

Last updated on APRIL 06, 2017

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)
.....

Changes

Upgrade from WLW 8.1 to WLW 9.x / WLW10.x.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms