I've configured a DataSource under JBoss 4.0.1 to connect to an Oracle database.

I'm in the process of migrating a stand-alone thick application. So far I can 
successfully create the initial context, get the data source, open a connection 
and fetch data from the database.

Unfortunately, the connections are not released to Oracle despite calls to 
Connection.close(). I can call the close method immediately after opening the 
connection and subsequent calls to the DB fail. However, after the application 
exits Oracle still shows an open connection held by JBoss. After running the 
application several times JBoss can no longer obtain a connection. I assume it 
has reached some maximum open connection limit. When I reboot the JBoss 
application server the connections are released.

Would someone please explain why this occurs or kindly point me the relevant 
documentation to correct this behavior?

Thanks!

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3867490#3867490

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3867490


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to