0 Replies Latest reply on May 13, 2008 2:32 AM by Jik Tom

    Connection from Pool Connection deosn't close

    Jik Tom Newbie

      Hi,

      My application uses JBOSS connection pooling, using oracle.jdbc.driver.OracleDriver, ( ojdbc14.jar). I use callable statements and close the connection after use. But it looks connection doesn't get closed immediately but it will be available in the pool. When i execute same callable statement for a different record , I get some invalid data, that has come as a part of my previous call. It looks Oracle doesn't close the callable statement context unless the corresponding connection get closed fully from JAVA. In the case of pooling, active connection from pool might be connected to an active context in Oracle and any subsequent calls brings invalid data. When I use JDBC, things work fine. Is there anyway to resolve this. Pls help

      Jik