-
1. Oracle global variables are not getting reset for the connections in jboss connection pool
wdfink Apr 12, 2011 2:43 AM (in response to pshivale)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.
-
2. Oracle global variables are not getting reset for the connections in jboss connection pool
pshivale Apr 12, 2011 9:15 AM (in response to wdfink)I am using Container Managed EJBs, so there should not be any problem with closing resultsets or statements.
And by global variables, i mean oracle global variables that are acccessible across different procedures in the same oracle session.
Those variables are reset only when you manually reset them or open a new oracle connection.
-
3. Oracle global variables are not getting reset for the connections in jboss connection pool
wdfink Apr 12, 2011 10:38 AM (in response to pshivale)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?