PoolingDataSource: java.sql.SQLException: Connection is closed
От | Michael musset |
---|---|
Тема | PoolingDataSource: java.sql.SQLException: Connection is closed |
Дата | |
Msg-id | AANLkTimB8AogvKzD04zPNuwFq6QPTGuG+waeBWp0Tt+Z@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: PoolingDataSource: java.sql.SQLException: Connection is closed
|
Список | pgsql-jdbc |
Hi,
On my Ubuntu 10.04 Server, I have Tomcat6 running + Postgresql 9.
I use the javax.sql.DataSource like that on my context.xml file :
<Context>
<Resource name="jdbc/**********"
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/DB?autoReconnect=true"
/>
</Context>
do you have an idea why I got this error ? :
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:317)
When i'm trying to do get a Preparestatement or sometimes on the execute() command.
My idea is there is too much connection not closed correctly, but i'm sure that i closed every connection that I open.
And in my context configuration I use :
removeAbandoned="true"
removeAbandonedTimeout="1120"
and jdbc:postgresql://localhost/DB?autoReconnect=true
Thanks in advance for the help.
--
Michael Musset,
Tel: 06 26 06 29 89
On my Ubuntu 10.04 Server, I have Tomcat6 running + Postgresql 9.
I use the javax.sql.DataSource like that on my context.xml file :
<Context>
<Resource name="jdbc/**********"
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/DB?autoReconnect=true"
/>
</Context>
do you have an idea why I got this error ? :
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:185)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:317)
When i'm trying to do get a Preparestatement or sometimes on the execute() command.
My idea is there is too much connection not closed correctly, but i'm sure that i closed every connection that I open.
And in my context configuration I use :
removeAbandoned="true"
removeAbandonedTimeout="1120"
and jdbc:postgresql://localhost/DB?autoReconnect=true
Thanks in advance for the help.
--
Michael Musset,
Tel: 06 26 06 29 89
В списке pgsql-jdbc по дате отправления: