Hi Michael, Why don't you submit a sample code for it, and we will see if some one else can implement it in OJB before you become available to work on it.
Rajeev ----- Original Message ----- From: "Michael Mogley" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Monday, June 23, 2003 9:06 PM Subject: RE: oracle BLOB > 4K > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]