Hi,
as suggested in the error message that is shown, you should use the Oracle9i platform and not the Oracle platform. The old Oracle platform does not support
BLOBs with length>2000, this was a limitation of the thin driver for Oracle 8.
The platform Oracle9i does not have the above limitation and also includes extra enhancements, fixes and optimisations that apply to the Oracle 9i driver. I do
not know how and if everything works correctly also with Oracle 10g, but I am confident that it will. ;)
We are using Oracle 9i with the Oracle9i OJB platform and have no problem
uploading BLOBs > 5 MB.
bye
danilo
Hiller, Frank RD-AS2 wrote:
Hi,
I'm using OJB 1.0.3, Tomcat 5.0.28 and Oracle 10g Rel2.
When I try to save images I get
"org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the update (for a ...): Oracle thin driver cannot update BLOB values with length>2000. (Consider using Oracle9i as OJB platform.)"
The database field is BLOB, the JDBC type in field-descriptor is BLOB the data
type in Java class is byte[] as recommended by Bobby.
Is this an OJB or an Oracle related problem?
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
