Timeout Problem with Two-Way SSL when Retreiving BLOBs Using getBlob().getBytes()

(Doc ID 734328.1)

Last updated on OCTOBER 27, 2008

Applies to:

Advanced Networking Option - Version:
This problem can occur on any platform.


With 2-way SSL enabled  for communication between the client library (Oracle Thin JDBC driver) and Oracle server, after upgrading your environment to Oracle you start to experience non-deterministic errors while retrieving blob bodies from the database. A typical access pattern is to perform a query that brings back one or more blob columns as well as a number of other fields. You then access the contents via getBlob().getBytes(). At this point you intermittently get a disconnect message.

On the client, you see:

java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1782)
at oracle.sql.BLOB.length(BLOB.java:155)

Server side trace file has the following errors:

[30-JUL-2008 00:03:22:955] nsprecv: reading from transport...
[30-JUL-2008 00:03:22:955] ntzread: entry
[30-JUL-2008 00:03:22:955] ntznzosread: entry
[30-JUL-2008 00:03:22:955] nttrd: entry
[30-JUL-2008 00:03:22:955] ntt2err: entry
[30-JUL-2008 00:03:22:955] ntt2err: exit
[30-JUL-2008 00:03:22:955] nttrd: socket 11 had bytes read=0
[30-JUL-2008 00:03:22:955] nttrd: exit
[30-JUL-2008 00:03:22:955] ntznzosread: encountered "wouldblock" error
[30-JUL-2008 00:03:22:955] sntpoltsts: exit
[30-JUL-2008 00:03:22:955] ntznzosread: exit
[30-JUL-2008 00:03:22:956] nserror: nsres: id=1, op=68, ns=12535, ns2=12609; nt[0]=0, nt[1]=0,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[30-JUL-2008 00:03:22:956] nsdo: nsctxrnk=0
[30-JUL-2008 00:03:22:956] nioqrc: wanted 1 got 0, type 0
[30-JUL-2008 00:03:22:956] nioqper: error from nioqrc
[30-JUL-2008 00:03:22:956] nioqper: ns main err code: 12535
[30-JUL-2008 00:03:22:956] nioqper: ns (2) err code: 12609
[30-JUL-2008 00:03:22:956] nioqper: nt main err code: 0
[30-JUL-2008 00:03:22:956] nioqper: nt (2) err code: 0
[30-JUL-2008 00:03:22:956] nioqper: nt OS err code: 0


It is suspected but not confirmed that this may have something to do with the support for Out Of band Breaks in the new JDBC Thin drivers as explained in <>


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