Sylvie, that's unfortunately correct. Oracle's OCI JDBC driver is a type 2 JDBC driver, iow a driver that (partially) relies on native code (written in C/C++ most of the time) to achieve its functionality. In general, type 2 drivers are less desirable, but I guess in your case you do not really have a choice. Unless Oracle has come up with a new release of their type 4 driver.
Werner On Tue, 9 Dec 2003 17:19:54 -0800, Desai, Mehul P wrote: >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 > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
