JBoss Community

Re: Oracle global variables are not getting reset for the connections in jboss connection pool

created by Wolf-Dieter Fink in Datasource Configuration - View the full discussion

What you mean by 'global variable'?

 

If you 'close' a connection from application side it is only marked that it can be returned to the pool.

If you left open ResultSets or Statements it will be also end in a DB-cursor leak (except you set the tracking in the DS file :) )

 

So you have to reset your variables yourself, or you might add a SQL comand that 'check' the connection getting from pool.

See http://community.jboss.org/wiki/configdatasources for this.

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community