Hi there Mark, You can download lots of different driver files from technet.oracle.com... but before you do - one word for you: beware! the BLOB support that Oracle has is bug-ridden to say the least. We've been trying to get it working reliably for ages. Our experience has been (using the thin driver at least) that If you use the Oracle 7 types (LONG and LONG RAW), there are concurrency bugs which cause the driver to drop the connection, and Oracle are not fixing them :-( If you use the Oracle 8 types (BLOB and CLOB), BLOBs larger than 4k are problematic. Using oracle.sql.BLOB and getChunk() may work for you if you use the latest JDBC driver (8.1.6), but oracle.jdbc2.Blob/java.sql.Blob don't work for blobs greater than 4k. Perhaps you could share the info you have of Type 2 vs Type 4 - does using the OCI driver fix the BLOB problem? If anyone has been able to get Oracle working with BLOBs, your input would be appreciated.... (One thing we haven't tried yet is third party drivers - eg Weblogic) Good Luck! Geoff -----Original Message----- From: Mark Foley <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, 8 September 1999 12:48 Subject: Oracle JDBC DLL missing >Hi All, > >wee are trying to access BLOB fields in our Oracle tables, but this doesn't >seem possible using the type 4 JDBC driver. It seems we need to use a type >2 JDBC driver, but we are missing the OCI80JDBC.DLL required. Does anybody >know where we can get this file? > >Thanks, > >Mark Foley >EDS (Australia) >e-mail: [EMAIL PROTECTED] > >___________________________________________________________________________ >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
