jboss 3.0.2, oracle 9 large numbers of inactive connections

[salkin]

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-

[iury]

me too;

are you resolved? if yes How

[anfo]

From what I have read you cannot count on the finally block like you would a destructor in a C++ object, the garbage collector in java will call finally when it feels like it. I believe it is also a depricated call, so it is pretty much worhtless to you if this is new development. *note: I am a java noob, just read this recently for whatever its worth.