1 Reply Latest reply on Feb 14, 2013 5:28 AM by 629026

    Oracle java pool

      Hi everyone,

      I have on tomcat application witch uses conn. pool for executing procedure in packages. The problem is when I recompile package I must restart tomcat, because java returns error that package is in invalid state (caching error msg). I belive that this happens because of conn. pool.
      Is there a option in connection pooling so that java will now when package is recompiled.

      thanks in advance.
        • 1. Re: Oracle java pool

          In an oracle session (when tomcat establishes connection with oracle) if an existing procedure is compiled which is being used by java currently, for the next run u will be getting the error (session persistence), and in the same session if u try to re-execute (i mean if u call [CALLABLE STMT] the procedure again) the error will not come.
          This is not the issue with connection pool, its default behavior of oracle. So, the CALLABLE STMT can be re-executed when exception occurs, that would resolve the issue.