Top 10 solution documents for JDBC
By jhpierce -Oracle on Dec 09, 2013
The following are the top 10 documents that are linked to SRs as solutions, for JDBC issues, during the last quarter.
||Troubleshooting ORA-3137  Errors Encountered When Using Oracle JDBC Driver: Oracle Customer Support has observed a large volume of issues reported by customersexperiencing ORA-3137  and occasionally ORA-3137  errors when connecting to an Oracle RDBMS using the Oracle JDBC driver. This document enumerates troubleshooting approaches that have proven successful.|
|401934.1||Starting With Oracle JDBC Drivers: This FAQ provides practical information when starting with Oracle JDBC drivers. A description of the Oracle JDBC drivers is provided so that you can choose which Oracle JDBC driver can be used with your Java application.|
|1050942.1|| How to Trace the Network Packets Exchanged Between JDBC and the RDBMS in
Release 11.2: From release 11.2, the JDBC Thin Driver includes a network trace capability. This capability allows you to trace the network packets that the driver exchanges with the server.
|1555793.1|| : JDBC thin connections using Single Client Access Name (SCAN) fail with errors:
ORA-12520: TNS:listener could not find avail hndler for requested typ of server
ORA-12516: TNS : listener could not find instance with matching protocol stack
|1564251.1||"java.lang.ArrayIndexOutOfBoundsException" After Upgrading To JDBC 11.2 : Asdescribed in BUG 16626549, there is a synchronization problem in big5pow method. Bug 16626549 - JDBC DRIVER THROWING JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION|
|131812.1||: This article explains how to run a simple Java stored procedure demo called Hello.java.|
|1440234.1|| : When using the 18.104.22.168 JDBC driver against an 22.214.171.124 database, calls
to a stored procedure return resultset information successfully.
However, when using the Universal Connection Pool (UCP) JDBC adapter,
the same call returns the exception below:
Exception in thread "main" java.lang.RuntimeException: unexpected invocation exception: null at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke (PreparedStatementProxyFactory.java:138)
|1384829.1||How to Release Temporary LOB Segments without Closing the JDBC Connection: This JDBC code sample demonstrates how LOB resources can be released without having to close the JDBC connection.|
|1364680.1||JDBC Connection Failure Reporting TNS-1153 Error In The Listener Log: The problem was caused by the inclusion of multiple JDBC jar files in the classpath. In this case, classes12.jar and ojdbc6.jar files were included in the classpath. These two jar files were from different JDBC versions and this was causing the issue.|
|762286.1||End To End Examples of using SSL With Oracle's JDBC THIN Driver: The following how-to demonstrates, creating a self signed oracle wallet for the server and client, configuring the database to use TCPS with the server key, configuring an SQL client to connect to TCPS and create simple java clients that shows how to connect through to TCPS in several different examples.|