data source access

[psv]

Hi,

I am using jboss-4.0 as app server and Mysql as the database. My application sar file is running well for certain amount of time, ie., 12+ hours. But after that i am getting the following exception

[WrappedConnection] Closing a statement you left open, please do your own housekeeping

followed by socket exception in the later iterations. I am positive that i closed all the connections after the usage.

Any help is highly appreciated.

Thanks
psv

[aloubyansky]

It's unlikely the problem is in JBossCMP. Describe how you are using JDBC.

[psv]

I am using JBoss Data source. and after using the connection, i am closing it, as there are no methods defined to return the connection to the Data source.