Re: JDBC : this statement has been closed : postgresql 9
| От | Michael musset |
|---|---|
| Тема | Re: JDBC : this statement has been closed : postgresql 9 |
| Дата | |
| Msg-id | AANLkTin6b=kCvnfGwAQE0rT-jPQKgG5+vme-VKJQ6MNO@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: JDBC : this statement has been closed : postgresql 9 (Radosław Smogura <rsmogura@softperience.eu>) |
| Список | pgsql-jdbc |
Hi,
No, I'm not using Hibernate,
And i'm already using pooling because of :
<Context>
<Resource name="jdbc/Pool"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="20000"
removeAbandoned="true"
removeAbandonedTimeout="1120"
username="*******"
password="*******"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost/DBNexess?autoReconnect=true"
/>
</Context>
my error just happen once again ........
org.postgresql.util.PSQLException: This statement has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2508)
at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:595)
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:36)
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
why is it happenning ? what does it mean ?
--
Michael Musset,
Tel: 06 26 06 29 89
No, I'm not using Hibernate,
And i'm already using pooling because of :
<Context>
<Resource name="jdbc/Pool"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="20000"
removeAbandoned="true"
removeAbandonedTimeout="1120"
username="*******"
password="*******"
logAbandoned="true"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost/DBNexess?autoReconnect=true"
/>
</Context>
my error just happen once again ........
org.postgresql.util.PSQLException: This statement has been closed.
at org.postgresql.jdbc2.AbstractJdbc2Statement.checkClosed(AbstractJdbc2Statement.java:2508)
at org.postgresql.jdbc2.AbstractJdbc2Statement.getMaxRows(AbstractJdbc2Statement.java:595)
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:36)
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
why is it happenning ? what does it mean ?
On Wed, Nov 10, 2010 at 11:36 AM, Radosław Smogura <rsmogura@softperience.eu> wrote:
On Wed, 10 Nov 2010 11:20:14 +0100, Michael musset <mickamusset@gmail.com>
wrote:> Hi,[...]
>
> I'm having a troube in my application :> which JDBC i'm using ? this one :Are you using Hibernate in above? I have similar bug with Hibernate and
>
> http://ejurka.com/pgsql/jars/xml/
>
> from Kris Jurka ( thx to him )
>
>
> I don't understand why a preparestatement have been close ?
>
>
>
> thx for your help,
XA, try to use PooligDataSource.
--
----------
Radosław Smogura
http://www.softperience.eu
--
Michael Musset,
Tel: 06 26 06 29 89
В списке pgsql-jdbc по дате отправления: