1 Reply Latest reply: Jul 25, 2013 9:14 AM by Srini Chavali-Oracle RSS

    When upgraded commons-dbcp from 1.0 version to 1.4.4 version getting ::SQLException:::Closed Connection: next

    10d7ebf4-1dc2-4960-b238-addbfee48f6b

      Hi Friends,

       

      Due to connection close bug with COMMONS-DBCP-1.0.jar we had to change it to commons-dbcp-1.4.jar

       

      But with this jar we are getting following exception:

       

      FaiMextGattern:::retrieveMatchableTextPattern:::SQLException:::Closed Connection: next

      FaiMextGattern:::retrieveMatchableTextPattern:::SQLException:::Closed Connection: next

      Closed Connection: next

      Closed Connection: next

      MextGattern:::run:::Exception:::String index out of range: -1

      MextGattern:::run:::Exception:::String index out of range: -1

       

      There are around 1.1 millions records in database that we are populating when we are starting the server(takes 3.5 hrs for complte start) but while we start the server in the exception logs after 1 hour we face above exception...

      Does it because some properties that were not set there in BasicDataSource class in version 1.0 jar and setting in 1.4 jar because when I see constructor of BasicDataSource class from commons-dbcp-1.4.jar, there are lot of properties that are customized which were not handled in the BasicDataSource class of version 1.0 jar


      what do you think guys, following are the properties that are handled in BasicDataSource of 1.4.4 jar

       

      public BasicDataSource()

          {

              defaultAutoCommit = true;

              defaultReadOnly = null;

              defaultTransactionIsolation = -1;

              defaultCatalog = null;

              driverClassName = null;

              driverClassLoader = null;

              maxActive = 8;

              maxIdle = 8;

              minIdle = 0;

              initialSize = 0;

              maxWait = -1L;

              poolPreparedStatements = false;

              maxOpenPreparedStatements = -1;

              testOnBorrow = true;

              testOnReturn = false;

              timeBetweenEvictionRunsMillis = -1L;

              numTestsPerEvictionRun = 3;

              minEvictableIdleTimeMillis = 0x1b7740L;

              testWhileIdle = false;

              password = null;

              url = null;

              username = null;

              validationQuery = null;

              validationQueryTimeout = -1;

              accessToUnderlyingConnectionAllowed = false;

              restartNeeded = false;

              connectionPool = null;

              connectionProperties = new Properties();

              dataSource = null;

              logWriter = new PrintWriter(System.out);

          }