storing BLOB type in oracle db

[nikil shar]

hi all,
have seen a few examples already but most of them update/insert just the BLOB, i needed to update BLOB as well as another column.

//establish valid connection to db

byte[] bill = null;

bill = //read file into byte array;

String preGenerated = "t";

String sql = "UPDATE BILL set (PDF, ISPREGENERATED) = (select ? , " + preGenerated+ " from dual ) WHERE \"CUSTOMER_IDENTIFIER\" = '" + CustomerNo.trim() + "'";
PreparedStatement ps = null;

ps = this.conn.prepareStatement(sql);

ps.setBinaryStream(1, new ByteArrayInputStream(bill), bill.length);

the sql doesnt work and am sure its the BLOB which is causing the problem.

Does anyone know the correct sql for this ??


thanks.

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on Servlets. For more information, please read this.

This post has been moved to a more appropriate forum.

[nikil shar]

thanks for moving this to the correct forum.

could this have anything to do with the version of oracle driver i am using ?? my version is 9.2

[Charles 'King]

nikil shar wrote:thanks for moving this to the correct forum.

could this have anything to do with the version of oracle driver i am using ?? my version is 9.2

Can you update your db with the above sql? Test your sql outside of your coding environment and report back...

[nikil shar]

thanks for the reply Charles. how do i test inserting a BLOB in direct sql ?? sorry my sql is not very good.

[Jeanne Boyarsky]

nikil shar wrote:thanks for the reply Charles. how do i test inserting a BLOB in direct sql ?? sorry my sql is not very good.

You would need to read the BLOB from someplace. For example, you could have it in a file.