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
