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 Thomas Mahler <th...@web.de> on 2003/09/23 21:03:40 UTC

[Fwd: Help needed : java.sql.SQLException: Closed Statement]


-------- Original Message --------
Subject: Help needed : java.sql.SQLException: Closed Statement
Date: Tue, 23 Sep 2003 14:39:51 +0800
From: Mendu Venkata <me...@aretae.com>
To: <th...@web.de>

Hello Thomas,


We face some problems with OJB in Production environment.
We deploy our application in  iPlanet App server 6.5.
Some times, there is exception is thrown by OJB.

====================================================================
java.sql.SQLException: Closed Statement
         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
         at 
oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390)
         at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:576)
         at 
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
         at 
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.java:248)
         at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown 
Source)
         at 
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknown 
Source)
         at 
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown 
Source)

====================================================================


This kind of error never happened when we run iPlanet Web Server.

How can I troubleshoot this. Thanks in advance.


Mendu



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


RE: [Fwd: Help needed : java.sql.SQLException: Closed Statement]

Posted by Réda Benzair <re...@smartjog.com>.
Hi...

I had the same problem but my problem was oracle it is necessary to
change the number of statement on Oracle can be it is necessary to see
the conf of DBs


-----Original Message-----
From: thma32@web.de [mailto:thma32@web.de] 
Sent: mardi 23 septembre 2003 21:04
To: OJB Users List
Subject: [Fwd: Help needed : java.sql.SQLException: Closed Statement]



-------- Original Message --------
Subject: Help needed : java.sql.SQLException: Closed Statement
Date: Tue, 23 Sep 2003 14:39:51 +0800
From: Mendu Venkata <me...@aretae.com>
To: <th...@web.de>

Hello Thomas,


We face some problems with OJB in Production environment.
We deploy our application in  iPlanet App server 6.5.
Some times, there is exception is thrown by OJB.

====================================================================
java.sql.SQLException: Closed Statement
         at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
         at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
         at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
         at 
oracle.jdbc.driver.OracleStatement.ensureOpen(OracleStatement.java:6390)
         at 
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS
tatement.java:576)
         at 
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt
atement.java:527)
         at 
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.jav
a:248)
         at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown 
Source)
         at 
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Un
known 
Source)
         at 
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu
ery(Unknown 
Source)

====================================================================


This kind of error never happened when we run iPlanet Web Server.

How can I troubleshoot this. Thanks in advance.


Mendu



---------------------------------------------------------------------
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