Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc oracle and blob

 
pascal monfils
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everybody,

I'm facing a problem with JDBC and Oracle when trying to insert a file into a blob in the database.

Here's how i tried.

I create a row in the database using the empty_blob() function to initialize the blob column.
I then execute a select for update on that record ... this way Ilock the record and can in the same time have access to a blob object from the resultset.

I have in memory a byte[] array containing my docuement.
I use the setBytes() function on the blob to pass the bytes[] to the blob object.

At that moment, a SQLException is thrown : UNSUPPORTED FEATURE
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out the example I posted in this thread.

Hope that helps.

Jules
 
pascal monfils
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks a lot !

greatly helpfull ... it works now ...
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic