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

[Pramod Shivale]

Pramod Shivale [http://community.jboss.org/people/pshivale] created the discussion

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

To view the discussion, visit: http://community.jboss.org/message/599373#599373

--------------------------------------------------------------
Hi,

I am using JBoss 4.2.3 and Oracle 10g.
We have some oracle procs that set some global variables.
It seems that the global variables set on the database connection are not reset before returning the connection to the pool.
Hence next time when some other user gets that conenction, the global variables are still set on that connection and its causing an issue.
Any ideas?
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/599373#599373]

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/20110411/ccff6a3d/attachment.html