resin-2.0 on Red Hat 9 AD server 3.0
hibernate 2.1.2
SQLserver 2k

When resin start everything is ok but after one hundred hours(maybe more) I get a Exception...

java.sql.SQLException: can't create statement from closed connection.
at com.caucho.sql.UserConnectionAdapter.prepareStatement(UserConnectionAdapter.java:389)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:249)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:223)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:950)
at net.sf.hibernate.loader.Loader.list(Loader.java:941)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1512)
......
......

I think its connection pool's error(I use Resin's database pool) ??
Who can tell me why?appreciate..
I have read some FAQ and searched for forums ... - -

Sorry for my pool English

MY database pool configuration in resin.conf

<resource-ref>
<res-ref-name>jdbc/ladder</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<init-param driver-name="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<init-param url="jdbc:microsoft:sqlserver://xxx.xxx.xx.x;DatabaseName=dbname;SelectMethod=cursor"/>
<init-param user="sa"/>
<init-param password="pass"/>
<init-param max-connections="500"/>
<init-param max-idle-time="30"/>
</resource-ref>

Your application does not release your connection resource .
Please check your log to find the errors.