Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-dev@xml.apache.org
Message-ID: <3AA90F7C.A539A4E2@apache.org>
Date: Fri, 09 Mar 2001 12:14:36 -0500
From: Berin Loritsch <bloritsch@apache.org>
MIME-Version: 1.0
To: cocoon-dev@xml.apache.org
Subject: Re: Anybody run into this error with Oracle JDBC?
References: <3AA9092E.D12025FD@apache.org> <3AA90EC0.7060407@ieee.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

"Marcelo F. Ochoa" wrote:
> 
> Berin Loritsch wrote:
> 
> > I get this exception consistently at the same point every time.  Unfortunately, the code was working
> > yesterday.  The difference is something in the JdbcConnectionPool code.  I can't see what is causing
> > this to happen, so I am appealling to all of you out there who may have used the Oracle JDBC driver.
> >
> > WARN    89178   [cocoon  ] (Thread-10): There was an error closing the datasource
> > java.sql.SQLException: Io exception: Connection reset by peer: socket write error
> >
> >       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> >
> >       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
> >
> >       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
> >
> >       at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:437)
> >
> >       at org.apache.avalon.util.datasource.JdbcConnection.setAutoCommit(JdbcConnection.java:73)
> >
> >       at org.apache.avalon.util.datasource.JdbcConnection.close(JdbcConnection.java:97)
> >
> >       at org.apache.cocoon.acting.DatabaseAddAction.act(DatabaseAddAction.java:112)
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> > For additional commands, email: cocoon-dev-help@xml.apache.org
> 
> Which classes1xx.zip are you using?
> Connection pooling with JDBC dirvers for Oracle 8.1.6 has many problem.
> These problem includes "No Thread safe working" and prints user name and
> password of the DataSource into System.out.
> Best regards, Marcelo.
> 
> PD: Uses JDBC drivers of 8.1.7, it works fine.

I am using classes122.zip (renamed to oracle.jar).
I have a feeling that it has to do with a certain size of image that I am uploading
to the DB.

I will try the newer JDBC drivers.  We are connecting to Oracle 8.1.6.

> 
> --
> Marcelo F. Ochoa - mochoa@ieee.org
> Do you Know DB Prism? Look @ http://www.plenix.com/dbprism/
> More info?
> Chapter 21 of the book "Professional XML Databases" (Wrox Press
> http://www.wrox.com/)
> Chapter 8 of the book "Oracle & Open Source" (O'Reilly
> http://www.oreilly.com/)
> -----------------------------------------------
> Lab. de Sistemas - Fac. de Cs. Exactas - UNICEN
> Paraje Arroyo Seco - Campus Universitario
> (7000) Tandil - Bs. AS. - Argentina
> Te: +54-2293-444430 Fax: +54-2293-444431
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email: cocoon-dev-help@xml.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org