You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Srikanth Gubba <sg...@lylesdata.com> on 2003/06/23 20:29:17 UTC
OJB not to cache its queries
Hi all,
do u know how to configure ojb not to cache its queries? any help
appreciated.
Thanks in adv,
srikanth
Re: oracle BLOB > 4K
Posted by Conall O'Raghallaigh <co...@medicineman.com>.
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" <mm...@adelphia.net>
To: "'OJB Users List'" <oj...@db.apache.org>
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:conall@medicineman.com]
> 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:alan.olmanson@firepond.com]
> > > 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: oracle BLOB > 4K
Posted by Michael Mogley <mm...@hotmail.com>.
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" <Ra...@customercaresolutions.com>
To: "OJB Users List" <oj...@db.apache.org>
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" <mm...@adelphia.net>
> To: "'OJB Users List'" <oj...@db.apache.org>
> 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:conall@medicineman.com]
> > > 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:alan.olmanson@firepond.com]
> > > > > 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: ojb-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
Re: oracle BLOB > 4K
Posted by Rajeev Kaul <Ra...@customercaresolutions.com>.
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" <mm...@adelphia.net>
To: "'OJB Users List'" <oj...@db.apache.org>
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:conall@medicineman.com]
> > 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:alan.olmanson@firepond.com]
> > > > 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: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
RE: oracle BLOB > 4K
Posted by Michael Mogley <mm...@adelphia.net>.
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:conall@medicineman.com]
> 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:alan.olmanson@firepond.com]
> > > 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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
oracle BLOB > 4K
Posted by Conall O'Raghallaigh <co...@medicineman.com>.
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:alan.olmanson@firepond.com]
> > 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
> >
Re: OJB not to cache its queries
Posted by Christophe Marcourt <cm...@wanadoo.fr>.
you can use the refresh attribute set to true in your repository.xml.
Christophe
----- Original Message -----
From: "Srikanth Gubba" <sg...@lylesdata.com>
To: <oj...@db.apache.org>
Sent: Monday, June 23, 2003 8:29 PM
Subject: OJB not to cache its queries
> Hi all,
>
> do u know how to configure ojb not to cache its queries? any help
> appreciated.
>
> Thanks in adv,
> srikanth
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
---
Ce message Envoi est certifié sans virus connu.
Protégé par l'antivirus AVG Deluxe.
Version: 6.0.488 / Base de données virus: 287 - Date: 05/06/2003