Lock on GetConnection
Hi all,
i've a thread that open a jdbc thin connection on oracle db in every instance of it.
for explain something like this:
public void run()
{
........
Connection conn=null;
try{ ....
................< log lines 1>
conn=DriverManager .getConnection();
conn.setAutocommit(false);
................< log lines 2>
.................................
......< insert statement > .......
.................................
} catch (Exception e)
{
}
finally{
.......
if (conn!=null)
conn.close();
......
}
}
)
A new instance of thread starts every 2 minutes.
After some hours, all thread seems to be locking on DriverManager.getConnection() and i don't know why.
I think that there is a lock because no exception is throws and i can see the <log line 1> but not the <log line 2>.
Have you some idea about this problem?
My Database is Oracle 7.3
The Jdbc library is classes111.jar
JVM is 1.4.1_07
Thanks alot
