Hi,
we are using Oracle 8.1.7 with thin drivers. We found that for sql types VARBINARY, LONGVARBINARY and BLOB PlatformOracleImpl doesn't want to handle byte arrays with length more than 2000 bytes. We've heard about all the problems with Oracle thin drivers and handling large data sets.
Here I want to describe solution that works for us.
We have persistent class with the following attribute:
----------
/**
* @ojb.field jdbc-type="LONGVARBINARY"
*/private byte[] contents; ---------- JDBC type LONGVARBINARY maps to Oracle LONG RAW column type.
To experiment a little we have changed PlatformOracleImpl to ignore LONGVARBINARY type completely in the first if-statement of method setObjectForStatement. After compiling this change we've got it working. Byte arrays of any size are now saved to declared column with no problem.
May be this little change could be included in CVS? What do developers think?
Andrew Shevel
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
