Re: oracle BLOB > 4K
Rajeev, I would like to do so. However, I do not have time right now even for this. That being said, if you look through the list archives, I believe you will easily find two instances where I uploaded modified Ojb classes that I successfully tested with the codebase as it stood in December '02. Each of these files was supplemented with commentary on the exact nature of the changes. While I am occupied, perhaps you or others could use this as a springboard into a patch? Michael - Original Message - From: "Rajeev Kaul" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 5:26 PM Subject: Re: oracle BLOB > 4K > 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] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: oracle BLOB > 4K
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]
Re: oracle BLOB > 4K
Michael, Thanks for the response. I would offer to take a look, but I too am swamped until August or September. -Conall - 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]
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]