I believe you will also have to install the oracle client (free) on your machine in order for your oci drivers to work.
Mehul. -----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: [castor-dev] Re: [castor-dev]Pb while Storing BLOB to Oracle Database This one time, at band camp, SYLVIE PALLUEL said: SP>The test you mention is ok, but there were only 10 bytes to store. SP> SP>My pdf file has - at least - 6000 bytes and this seems to be the problem SP>with Oracle , using Castor Jdo. SP>The error which comes back from Oracle driver is "No more data in the SP>socket". SP> SP>I have to store my data on multiple Blob objects of no more than 4000 SP>bytes each. And then It seems to be ok. SP> SP>If you have more information about this, you are welcome. Sylvie, This is a bug in the Oracle JDBC drivers. I've gotten around this in the past by using the OCI drivers (JDBC type 2) which are included in the classes12.zip|classes12.jar. I'm not sure about the newer ojdbc.jar but I assume it is included there too. To make use of the Oracle OCI driver just change the JDBC URL in your database descriptor. Below are two examples: Oracle thin JDBC: jdbc:oracle:thin:@dbsrv3:1521:brnzorc Oracle OCI JDBC: jdbc:oracle:oci:@dbsrv3:1521:brnzorc Use of the Oracle OCI JDBC driver should allow you to store LOBs larger than 4k. Also, be aware that the LOB buffer size can be changed if necessary via the lobBufferSize property in the castor.properties file. Below is the entry for this: # # The buffer size in bytes for fetching LOBs (this is dependent upon # the JDBC driver implementation) - value below is 5k # org.exolab.castor.jdo.lobBufferSize=5120 Bruce -- perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' The Castor Project http://www.castor.org/ Apache Geronimo http://incubator.apache.org/projects/geronimo.html ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
