File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes blob data, Oracle JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Mongo DB Applied Patterns this week in the MongoDB forum
or a resume review from Five Year Itch in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "blob data, Oracle JDBC" Watch "blob data, Oracle JDBC" New topic
Author

blob data, Oracle JDBC

Sean Sullivan
Ranch Hand

Joined: Sep 09, 2001
Posts: 427
Sun provides a document that explains how to use
binary large objects (blobs) in JDBC
http://java.sun.com/j2se/1.4.1/docs/guide/jdbc/blob.html
If you plan to use Oracle's JDBC driver, you will discover
that Oracle provides a proprietary API for working with
the Oracle BLOB column type.
Oracle provides a document that explains some of the details
"JDBC Developer's Guide and Reference Release 2 (9.2)"
In chapter 8, the document explains how to work with
BLOB data and Oracle's oracle.sql.BLOB class
While working with Oracle's JDBC driver, I followed
the Oracle instructions for BLOB's but I could
not get it to work.
Ultimately, I realized that Oracle's instructions are
incomplete.
I also had to do the following:
--> setAutocommit(false) on the JDBC connection
--> add " FOR UPDATE" to the end of my SELECT statement
--> call commit() on the JDBC connection
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: blob data, Oracle JDBC
 
Similar Threads
Image insertion
help with recordset
VARBINARY
Connection Through JDBC
Urgent Help... SimpleDateFormat working differently in windows and unix.