Hi,
I have a custom application (an installer) that uses ojdbc6.jar to roll out a database schema on an Oracle 12c database. The database itself is installed and managed by a 3rd party - I have sysdba access but not file level access. Running this application with the odjbc6.jar driver for Oracle 12cR1 fails and downgrading to ojdbc6.jar for Oracle 11gR2 works. The failure can be described as a freeze of the installer with the database server showing no database activity on the session. There don't appear to be any transactions pending either. The manufacturer of the installer indicates there should be a database fault. The database maintenance team indicates that the database works as expected.
I have run the debug version (ojdbc6_g.jar) for each and recorded the commands for the two versions - the steps are the same and there are no errors. For the older version, the steps simply continue. The last command before the freeze is a custom stored procedure that inserts two records into two tables.
Is there a known issue on the ojdbc6.jar for 12cR1 that causes this?
Note: it appears that there is a firewall between the client and the database. Is there a difference, such as connection pooling, connection timeout, mtu settings, etc that could be affected by the firewall? That the installer is using a single database connection. A network trace did not show any connection drop either.
The 12c database server affected
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
"CORE 12.1.0.2.0 Production"
TNS for Solaris: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
The ojdbc6.jar that does not work:
Created-By: 20.12-b01 (Sun Microsystems Inc.)
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Implementation-Version: 12.1.0.1.0
Repository-Id: JAVAVM_12.1.0.1.0_LINUX.X64_130403
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0
Main-Class: oracle.jdbc.OracleDriver
The ojdbc6.jar file that works:
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.5
Created-By: 1.5.0_51-b10 (Sun Microsystems Inc.)
Implementation-Vendor: Oracle Corporation
Implementation-Title: JDBC
Implementation-Version: 11.2.0.4.0
Repository-Id: JAVAVM_11.2.0.4.0_LINUX.X64_RELEASE
Specification-Vendor: Sun Microsystems Inc.
Specification-Title: JDBC
Specification-Version: 4.0
Main-Class: oracle.jdbc.OracleDriver