Hi Conall, I have been hoping to rework my fix for this to fit better with Ojb's existing design and framework. However, I am currently committed to projects at work and am not likely to have much time for Ojb until August. If someone wants to step in before then with a patch that takes care of read/insert/update (as opposed to just read, as has been already submitted), I would be more than happy to share the expertise I have with Oracle's drivers to facilitate this.
Michael > -----Original Message----- > From: Conall O'Raghallaigh [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 3:57 PM > To: OJB Users List > Subject: oracle BLOB > 4K > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
