Datatombraider's Blog


Nasty JDBC-OCI bug

Filed under: Oracle — datatombraider @ 20:32

There’s a nasty bug in Oracle’s jdbc oci (thick) driver.

if the sum(length(column_name)) of a table is greater or equal 800, then prepareStatement(sql, generatedColumns) hangs indefinitely and a lot of data is being transferred between server and client. I’ve provided Oracle with a test case which shows the problem exists in 10.2, 11.1 and 11.2.

Analyzing the traffic between server and client shows that the client continually requests a describe of the table. Oracle is currently working on it and has found a fix which should be available soon. For details see Bug 10185052.

The patch addressing the issue is available for some platforms/versions now.


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at