• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting a CLOB using the JDBC OCI Driver

 
Alex Ioannou
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there

We're trying to insert a clob into a database table using the JDBC OCI driver and prepared statements.
The client and server versions of the database we are using are 9.2.0.4.0 - the linux version.

The code is resident on weblogic application server version 8.1.2, and it works fine using the thin driver regardless of the version of the database. As soon as we tried to use the oci driver the code began to fail where it tries to build the temporary clob.

The code fails with :-



This is the code we use to populate the prepared statement with the clob :-


Any ideas on what the problem might be? Is there a known bug with the oci driver for version 9.2.0.4.0? We tried to use but that didn't work either.

Thanks
 
Alex Ioannou
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Found the problem.

The ojdbc14.jar that ships with weblogic 8.1.2 is incorrect. That jar contains invalid values for the constants CLOB.DURATION_SESSION and CLOB.DURATION_CALL.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Alex,
Interesting. Thanks for posting the solution!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic