Mark,
I was hoping not to use Oracle APIs. rathter just JDBC APIs (No Oracle
Specific import).
> >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
The book only give example of how to read BLOB, or read BLOB and then call
setBLOB() after got the BLOB
, no example is given in the book for how to Store an BLOB.
Joe sam showed an examnple on Sun's website using PrepareStatement with
setBinaryStream() method and it works on DB2.
My collegue and myself tried, it does not seems to work on Oracle (as oracle
has a special way of doing it).
> -----Original Message-----
> From: Mark Galbreath [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 16, 2003 3:51 PM
> To: [EMAIL PROTECTED]
> Subject: Re: How to create a BLOB field with JDBC using thin driver
>
>
> 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".
>
===========================================================================
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".
