Correct you are, but I wrote a class that manipulates BLOBs in an Oracle 9i
database using the Oracle API discussed in the last citation in my previous
email below.  You can get the Oracle classes and documentation at
http://otn.oracle.com/software/index.html.

Mark

-----Original Message-----
From: thorick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 6:42 PM
To: Mark Galbreath; [EMAIL PROTECTED]
Subject: Re: How to create a BLOB field with JDBC using thin driver



FWIW, JDBC2.0 has no provisions for updating Blobs.    I think JDBC3.0
finally addresses this shortcoming.    Don't know how available 3.0
Drivers are yet..


At 06:20 PM 12/16/2003 -0500, Mark Galbreath wrote:
>Have you tried the API?  java.util.sql.Blob should get you there.  More
>usage info can be found in the bible of JDBC: White, et al, "JDBC API
>Tutorial and Reference, 2d Ed." (Sun/Addison-Wesley  1999): 282-288, and
>Bales, "Java Programming with JDBC" (O'Reilly 2002): 246-272.
>
>Mark
>
>-----Original Message-----
>From: Chester Chen
>Sent: Tuesday, December 16, 2003 11:40 AM
>
>    I am trying to use a BLOB to store some binary data and wonder how to
do
>this in JDBC.
>    I have search the java.sun.com site, oracle and google sites and did
not
>find any thing useful.
>
>
>    The JDBC API tutorial reference book only give examples to update BLOB,
>i.e. you read BLOB from database
>and then setBLOB to update it.
>
>    I have found any example to show me how to create an new BLOB record,
has
>any done this before ?
>
>Chester
>
>===========================================================================
>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".

===========================================================================
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