1 Reply Latest reply on Oct 13, 2001 10:52 AM by Larry

    Entity beans & closed connection

    Eduard Newbie

      Hi,
      I am using JBoss 2.4.1 + Oracle 8i + JDK1.3.1-b24.
      While working with entity beans (BMP) I am getting the
      closed connection from the pool. The number of connections in closed state grows while load of the server increases.

      I would appretiate if somebody can give me a hint how
      to solve problem.

      Thanks in advance.

        • 1. Re: Entity beans & closed connection
          Larry Newbie

          This sounds like the same problem I had recently and it turned out to be my mistake. I am using the same configuration as yours. I thought the connections were closed, but using Oracle DBA-studio I saw that they were not closed. I found that I had a few entity beans which were not opening and closing their connections in each method. Intead, each new instance of an entity bean was creating its own connection in the setEntityContext method and they were staying open until garbage collection ran.

          I just mention this in case you made the same mistake. Good luck.