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
