Has there been any update/fix for this issue of with storing BLOBs > 4K in Oracle(8.1.7), thin driver? I am having this problem now.-Conall> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
