X

Proactive insights, news and tips from Oracle Fusion Middleware Support. Learn Oracle from Oracle.

Top 10 solution documents for JDBC

Guest Author

The following are the top 10 documents that are linked to SRs as solutions, for JDBC issues, during the last quarter.

 

 

1361107.1 Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver: Oracle
Customer Support has observed a large volume of issues reported by
customersexperiencing ORA-3137 [12333] and occasionally ORA-3137 [1010]
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 11.2.0.2 JDBC driver against an 11.2.0.2 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)
oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke  (CallableStatementProxyFactory.java:101)
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.

 

 

 

 

 

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.