3 Replies Latest reply on Apr 12, 2011 10:38 AM by wdfink

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

    pshivale

      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?