There's a standard JDBC method called PreparedStatement.setBinaryStream which doesn't work on Blob objects even though it should. Oracle tried to argue that it wasn't in the spec but Sun said it was so they had to admit "it will be more 'complete' if PreparedStatement.setBinaryStream() was allowed to write to a BLOB directly". Then they tried to tell me to use their proprietary API - yuck! Here's the comment thats going to be in the readme for the 8.1.6 version of the driver " There is a limitation regarding the use of stream input for LOB types. Stream input for LOB types can only be used for 8.1.6 JDBC OCI driver connecting to an 8.1.6 Oracle server. The use of stream input for LOB types in all other configurations may result in data corruption. PreparedStatement stream input APIs include: setBinaryStream(), setAsciiStream(), setUnicodeStream(), setCharacterStream() and setObject(). " I think other than that it's probably spec complaint. I would say if you are going to use BLOBs, avoid the Oracle drivers. Thats where we had all our problems. If not, you're probably OK. Also, if you want support in case of problems, go for a payware driver. Also, don't even think about using LONG RAW, there's a concurrency bug in the Oracle drivers which Oracle have refused to fix...! Geoff -----Original Message----- From: Heinz Wehner <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, 8 December 1999 5:20 Subject: AW: 'Thin driver is best for Applet while OCI is best for Servlet' - NOT! >Geoff, > >since we are currently in the process of deciding which JDBC driver should >be used for accessing an Oracle8i database, I'd like to ask you for some >more details regarding the non-conformance of Oracle's drivers. Can you >please elaborate? We'd like to check if these problems are really that >serious for us as they must have been for you. > >Regards, > >Heinz Wehner >(Karlsruhe, Germany) > > >> -----Urspr�ngliche Nachricht----- >> >> Actually, both of Oracle's drivers _suck_. I'd suggest using a quality >> payware third party driver like Merant or Weblogic if you want a stable >> driver! >> >> We've had to do all sorts of evil workarounds to get the Oracle driver to >> work. And then when you try and report bugs you have to contend with >Oracle >> claiming their driver is JDBC compliant when even Sun agree it's not... >> They bring new meaning to the word "support".. :-) >> >> Cheers >> >> Geoff > >___________________________________________________________________________ >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
