You can get some sample code from Technet (technet.oracle.com).
Just go to Technologies -> Java -> SQLJ & JDBC -> Sample Code -> JDBC 2.0 Samples ->
LOB Features and get the source.
Hope this helps,

        Esteban Chiner Sanz


Shiv Kumar wrote:

> Hi all
>
> This is slightly offtopic. But I believe that people in this list are the best
> ones to answer this question, and hence this posting.
>
> Has anyone had success with writing JDBC code to insert, select and update BLOB
> column in Oracle 8i database? I am using Oracle Thin JDBC 2.0 driver. For
> insert, I tried PreparedStatement.setBytes(), setBinaryStream() etc. But it does
> not work for large data (> 100K). I dont want to use any Oracle specific classes
> in my code, and hence I am keeping myself away from setBlob() method.
>
> If you have a code fragement to demonstrate this functionality (i.e insert,
> select, update BLOB column) within the constraints (i.e, Oracle Thin JDBC,
> Oracle 8i, No oracle specific classes to be used etc), that would be of great
> help to me.
>
> TIA.
> --
> shiv
> [EMAIL PROTECTED]
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST".  For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to