Monday May 16, 2016

The top 10 JDBC documents that are linked as solutions from December 2015 to May 2016

The following are the top 10 JDBC documents that are linked as solutions for JDBC issues, from December 2015 to May 2016.

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.
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 customers experiencing 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.
793415.1 How to Perform the Equivalent of SQL*Net Client Tracing with Oracle JDBC Thin Driver
The Oracle JDBC thin driver uses a java based implementation of  the SQLNET protocol (JavaNet layer).
1050942.1 How to Trace the Network Packets Exchanged Between JDBC and the RDBMS in Release 11.2 
Note discusses how to trace what is sent and received between the Oracle JDBC Driver release 11.2 and Oracle database.
755605.1 Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION
A 10.2 thin jdbc driver is identifying itself as 8.1.5 client and hence the connection is failing with error ORA-28040: No matching authentication protocol
467804.1 How To Determine The Exact JDBC Driver Version For Standalone Programs Retrieve diagnostic information about your JDBC/JDK environment that is especially useful for Support Analysts.
Includes: database version, JDBC driver version, JDK version, PATH, BOOTSTRAP, list of jars in the JRE extensions directory, CLASSPATH and JDBC URL.
1555793.1 DBC Connections Using SCAN Fail With ORA-12516/ORA-12520
ORA-12520: TNS:listener could not find available handler for requested type of server
ORA-12516: TNS : listener could not find instance with matching protocol stack
467808.1 Standard JDBC diagnostics for Application Servers
Retrieve diagnostic information about your JDBC/JDK environment used within a Java Enterprise container that is especially useful for Support Analysts. Includes: database version, JDBC driver version, JDK version, PATH, BOOTSTRAP, JRE Extensions directory, CLASSPATH and JDBC URL and debug flags information. ( Application Server specific)
334471.1 Understanding Transparent Application Failover (TAF) and Fast Connection Failover (FCF)   This note is intended to give explanation on two RAC concepts, Transparent Application Failover (TAF) and Fast Connection Failover (FCF).
1641167.1 Understanding Inactive Sessions From JDBC Connection Pool  Inactive/stale connections are noticed when using JDBC connection pools. Why do they get generated, and how to identify and control them?

Friday Apr 22, 2016

The 15 Most Recently Created Notes for JDBC as of 6 March 2016

The 15 most recently created notes for JDBC as of 6 March 2016.

2125991.1 XA Branch Cannot See Commited Data from Another XA Branch during 2PC XA Transaction using 2 Data Sources on Same Database
2125484.1 "unsupported key type found the default TGT: 18" Error While Running A Program Using JDBC And Kerberos To Connect To The Database 
2125139.1 Oracle JDBC 11.2 Statement.getUpdateCount() Returns Negative Number
2125145.1 What is the difference between Oracle THIN and THICK client (Oracle JDBC OCI)? 
2125129.1 Where Do I Download The Latest Version of Oracle JDBC Driver ?
2124718.1 How to upgrade JDBC driver?
2124694.1 How to apply JDBC patches?
2124621.1 Performance Degradation After Upgrade Of JDBC OracleOCIConnectionPool.getProxyConnection
2124104.1 Cursor Leak / ORA-1000 From PreparedStatement.getMetaData() Method On Malformed Statements
2122800.1 "IO Error: No appropriate protocol" When Trying to Connect to Oracle Database 12.1 with TLSv1.1 and TLSv1.2 Protocols
2122149.1 The free Method Does Not Release A Temporary Lob After Calling getArray
2117469.1 Stuck Thread at java.util.WeakHashMap.transfer and javax.crypto.JceSecurity.getCodeBase During JDBC connection 
2116293.1 Weblogic 12.1.3 - Oracle JDBC Driver Fails with Value conflicts occurs Exception 
2115033.1 How to Reduce the Time a JDBC Connection Takes to Switch to the Next Host in the Address List of a Connect Description String if the Address Attempted is Unavailable ? 
2113774.1 Multi-threaded Clients Currently Cannot Use SSL

Friday Sep 11, 2015

JDBC and UCP: Oracle OpenWorld and JavaOne (October 25–29, 2015) Middleware sessions

The following are the Oracle OpenWorld (October 25–29, 2015 | San Francisco) Middleware JDBC and UCP sessions:

  • Next-Generation Database: Java Connection Pool for Multitenant and Sharded Databases [CON8460]
  • Next-Generation Database: Portable JavaScript Stored Procedures with Java 8 Nashorn [CON8461]
  • Dialog with the Oracle Database Java Developers and Architects [MTE9501]
  • Master Data Management Using Oracle Table Access for Hadoop and Spark [CON8459
  • Market Basket Analysis Using Oracle In-Database Container for Hadoop [CON8462]
  • Next-Gen Database Enhancements for Java Application Performance and Scalability [CON10310]

The following are the JavaOne (October 25–29, 2015 | San Francisco) Middleware JDBC and UCP sessions:

  • High Availability with Java EE Containers, JDBC, and Java Connection Pools [BOF7732]
  • Modern, Portable JavaScript Stored Procedures with Nashorn [CON4405]
  • Java Connection Pool Performance and Scalability with Wait-Free Programming [CON2158]

For the description and times of each of these sessions and many additional sessions for Middleware visit the Oracle OpenWorld and/or the JavaOne web page.

Monday Jan 05, 2015

Top 10 documents that are linked to SRs as solutions, for JDBC issues, from Sept 2014 thru Dec 2014.

The following are the top 10 documents that are linked to SRs as solutions, for JDBC issues, from Sept. 2014 thru Dec. 2014.

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 customers experiencing 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.
467804.1 How To Determine The Exact JDBC Driver Version (9.x - 11.x) For Standalone Programs Retrieve diagnostic information about your JDBC/JDK environment that is especially useful for Support Analysts .Includes: database version, JDBC driver version, JDK version, PATH, BOOTSTRAP, list of jars in the JRE extensions directory, CLASSPATH and JDBC URL. (Standalone Programs)
467808.1 Standard JDBC diagnostics for Application Servers Retrieve diagnostic information about your JDBC/JDK environment used within a Java Enterprise container that is especially useful for Support Analysts. Includes: database version, JDBC driver version, JDK version, PATH, BOOTSTRAP, JRE Extensions directory, CLASSPATH and JDBC URL and debug flags information. ( Application Server specific)
334471.1 Understanding Transparent Application Failover (TAF) and Fast Connection Failover (FCF)   This note is intended to give explanation on two RAC concepts, Transparent Application Failover (TAF) and Fast Connection Failover (FCF).
1555793.1 JDBC Connections Using SCAN Fail With ORA-12516/ORA-12520 JDBC thin connections using  Single Client Access Name (SCAN)  fail with errors: ORA-12520: TNS:listener could not find available handler for requested type of server  ORA-12516: TNS : listener could not find instance with matching protocol stack
1050942.1 How to Trace the Network Packets Exchanged Between JDBC and the RDBMS in Release 11.2 This capability allows you to trace the network packets that the driver exchanges with the server.
1384829.1 This JDBC code sample demonstrates how LOB resources can be released without having to close the JDBC connection. This code sample implements the recommendation found in Note 802897.1 How to Release the Temp LOB Space and Avoid Hitting ORA-1652.
301999.1 The JDBC application reports one of the following errors when trying to execute stored procedures:java.sql.SQLException:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "xxxxx.xxxxxx" has been invalidated
ORA-04065: not executed, altered or dropped package body "xxxxx.xxxxxx"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
793415.1 How to Perform the Equivalent of SQL*Net Client Tracing with Oracle JDBC Thin Driver  The Oracle JDBC thin driver uses a java based implementation of  the SQLNET protocol (JavaNet layer).


Monday Dec 09, 2013

Top 10 solution documents for JDBC

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

Tuesday Jul 23, 2013

JDBC User Survey - Your Take on Oracle JDBC Drivers

The Oracle JDBC development team would like to hear your experience and expectation; please take a few minutes and tell them what works, and what does not work for you.

JDBC User Survey - Your Take on Oracle JDBC Drivers

The survey is aimed at anyone using JDBC, whether for THIN, OCI or another type of development.[Read More]
About


This is the official blog of the Java Development Proactive Services Team. Here we will provide information on our activities, publications, product related information and more. We look forward to your feedback to improve what we do!

Search

Archives
« May 2016
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today