Environment :- win 2000 server,SP2
oracle :- 8.1.7
A JDBC Connection is used to execute a SQL query in a daemon thread. The connection is not closed for ever...
Its used to execute the SQL for every 10Sec or so.
The trasaction is commited, other resources like recordset, Stmts are released.
The process crearted in oracle sessions are not being released in windows 2000 environment.
It reaches maximum(specified in init/ora) in a short while nad no more db operations could be made.
The same code works fine with oracle 8.1.7 running over winNT 4.0 /Unix.
oracle :- 8.1.7
A JDBC Connection is used to execute a SQL query in a daemon thread. The connection is not closed for ever...
Its used to execute the SQL for every 10Sec or so.
The trasaction is commited, other resources like recordset, Stmts are released.
The process crearted in oracle sessions are not being released in windows 2000 environment.
It reaches maximum(specified in init/ora) in a short while nad no more db operations could be made.
The same code works fine with oracle 8.1.7 running over winNT 4.0 /Unix.
