[jboss-user] [Datasource Configuration] - Re: Oracle global variables are not getting reset for the connections in jboss connection pool

[Wolf-Dieter Fink]

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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110412/a28b103e/attachment.html