Wolf-Dieter Fink [http://community.jboss.org/people/wdfink] created the discussion "Re: Oracle global variables are not getting reset for the connections in jboss connection pool" To view the discussion, visit: http://community.jboss.org/message/599421#599421 -------------------------------------------------------------- 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/docs/DOC-9328 http://community.jboss.org/wiki/configdatasources for this. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/599421#599421] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Wolf-Dieter Fink [http://community.jboss.org/people/wdfink] created the discussion "Re: Oracle global variables are not getting reset for the connections in jboss connection pool" To view the discussion, visit: http://community.jboss.org/message/599565#599565 -------------------------------------------------------------- So as I understand correct you want to reset this variable for the next use? Does the *<valid-connection-checker-class-name>* Element (see link above)  of the datasource help if you implement a class to reset the connection? -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/599565#599565] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]