My Oracle Support Banner

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

Last updated on OCTOBER 10, 2022

Applies to:

Advanced Networking Option - Version and later
Information in this document applies to any platform.
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(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CConnection.length(
at oracle.sql.BLOB.length(

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 <>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.