Problem with BLOB and Oracle 10g

kristi2006 Jul 19, 2006 11:07 AM

With jboss 4.0.4 RC1 default config we could not save Datatype BLOB bigger than 2000 bytes to a Oracle10g via EJB 3. We do not get any errors nor any java exceptions from jboss.
We tried a reconfigured jboss config using set JAVA_OPTS= -Dhibernate.jdbc.use_streams_for_binary=true in start script for jboss. Now it is possible to save blobs bigger than 2000 Bytes to database in case of holding not more than a special number of objects in jboss (We estimate about 500 objects).

1. Re: Problem with BLOB and Oracle 10g

uromahn Jul 31, 2006 10:39 AM (in response to kristi2006)

What JDBC driver are you using? There are several known bugs in some older Oracle JDBC driver with blobs. I suggest to download the latest Oracle JDBC driver.

In addition, make sure you have the correct settings for Hibernate, especially for BLOB data types.
Actions
2. Re: Problem with BLOB and Oracle 10g

oglueck Nov 30, 2006 10:43 AM (in response to kristi2006)

There was a bug in the first 10g Oracle JDBC driver. Fixed in the latest version!
Actions

Go to original post