A bug in ORACLE JDBC close Connection?

From: Sun (sun_2003_at_email.it)
Date: 01/30/04


Date: Fri, 30 Jan 2004 16:40:59 GMT

Hi to all friends!

I have a big problem. My application is running on Tomcat 4.0.5 and
uses an ORACLE db:

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn=DriverManager.getConnection
("jdbc:oracle:thin:@xxx.xxx.xxx.xxx:xxxx:xxx","******","*****");

I am sure that every connection that I open is also closed
but last night, after a great work,
ORACLE didn't accept any connection because the maximum number
of connection was reached.
My application is the only that at the moment uses ORACLE.

Is it possible that there is a bug in the JDBC driver,
included in ORACLE installation, that does not really close
connections to the db?

I use the Oracle8i Enterprise Edition Release 8.1.7.4.0

Many thanks to all
Riccardo



Relevant Pages

  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to ODBC DB at startup
    ... Creating an Oracle connection in an independent object ... Dim cnConn As ADODB.Connection ... Dim strDB As String ...
    (comp.databases.ms-access)
  • RE: SOS! ORA-03114: not connected to ORACLE && MSs Bug??
    ... not connected to ORACLE && MS's Bug?? ... > but sometimes returning the following exception "ORA-03114: ... > when loosing the connection with the Oracle database server the connections ... > even after the connection with the database server has been restore. ...
    (microsoft.public.dotnet.languages.csharp)