Hi Alan, This is a known issue with Oracle's JDBC Driver. Oracle's handling of BLOB does simply not work the way OJB expects the driver to do.
Sometime ago Michael Mogly contributed a patch that provides proper Oracle BLOB handling. Unfortunately this patch involves changes to a lot of classes, so that I did not manage to integrate it into the main codebase yet. cheers, Thomas > -----Urspr�ngliche Nachricht----- > Von: Olmanson, Alan [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 13. Januar 2003 21:17 > An: OJB Users List (E-mail) > Betreff: Oracle and BLOB > 4K > > > Hello, > > We are having some problems with OJB 0.9.8, Oracle 9i and > BLOB fields which > are greater than 4K, when we insert a new object. The > statement execution > hangs for a long time and when it comes back we get this error: > > java.sql.SQLException: Io exception: End of TNS data channel > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222) > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335) > at > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleState > ment.java:1860 > ) > at > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem > ent.java:1771) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement.java > :2361) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl > ePreparedState > ment.java:422) > at > org.apache.ojb.broker.accesslayer.JdbcAccess.executeInsert(Jdb > cAccess.java:1 > 95) > > > In the database the field is a BLOB and in the repository it > is marked as a > BLOB, in our object the attribute in a byte[]. > > Is this known issue? Is there a way to get this to work? > > Alan > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
