Datatombraider's Blog

2010/10/18

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.

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Blog at WordPress.com.