This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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