Hi. I paste this from oracle jdbc reference : Read the second paragraph. I hope it helps Important: The JDBC 2.0 specification states that PreparedStatement methods setBinaryStream() and setObject() can be used to input a stream value as a BLOB, and that the PreparedStatement methods setAsciiStream(), setUnicodeStream(), setCharacterStream(), and setObject() can be used to input a stream value as a CLOB. This bypasses the LOB locator, going directly to the LOB data itself. In the implementation of the Oracle JDBC drivers, this functionality is supported only for a configuration using an 8.1.6 database and 8.1.6 JDBC OCI driver. Do not use this functionality for any other configuration, as data corruption may result. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Aaron Mulder Sent: Tuesday, November 07, 2000 5:27 PM To: jBoss Subject: Re: [jBoss-User] weblogic, oci, jDriver,ORA-24327 (needexplicitattach...) On Tue, 7 Nov 2000, Krishna Kumar wrote: > Aaron, > I hv had problems with BLOB columns in Oracle 815 on solaris with the type 4 > drivers, u seem to mention oracle 816, oracle 817 so maybe this one doesn't > occur on those versions.. I'd try the newest (8.1.7, last I checked) JDBC drivers, even if you stick with the older DB. They're generally backward-compatible, and it may be that those features were only enabled in a recent driver release. > But the thin drivers are certainly faster??? I don't know that the thin drivers are faster - after all, they do everything in Java instead of the OCI native code. But I've never *noticed* a speed difference, and the thin drivers are *way* easier to manage (no need to worry about dynamic libraries, TNSNAMES.ORA, etc.). Let's just say there are a lot of optimizations I'd perform elsewhere before I switched from thin to OCI... Aaron > regards > krishna -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Problems?: [EMAIL PROTECTED]
