JBoss Community

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

created by Pramod Shivale in Datasource Configuration - View the full discussion

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

Start a new discussion in Datasource Configuration at Community