2 Replies Latest reply on Mar 11, 2003 4:33 PM by Tad Hitchcock

    jboss 3.0.2, oracle 9 large numbers of inactive connections

    Steve Salkin Newbie

      Hi-

      When we hit the database hard, for example when processing a submitted batch file of 15000 records, we run out of cursors. We have set 100,000 cursors in oracle, use a DataSource, and close all connections in the finally() block. Looking in oracle we see around 4 open active connections but lots (thousands) of inactive connections. It appears that the pool isn't releasing unused connections to oracle in a timely way, but instead allocates new ones. Is this a known issue? We're going to work-around this for now by using explicit connections - slow, but correct and slow is better than fast and broken.

      Any tips appreciated.

      S-