Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-28489

Setup Wizard - Configuring from HSQL to Oracle 10 causes java.sql.SQLException


    • Fix Priority:


      In the setup wizard, when you change the database from Hypersonic to Oracle 10, you get 'java.sql.SQLException: Io exception:' in the console. I did not get any errors when following the same steps to change from Hypersonic to Oracle 11. Also, I am able to startup Liferay and login without errors if I defined the portal-ext.properties file to use Oracle 10.

      1. Deploy Liferay with Oracle 10, verify you are able to startup and login with no errors
      2. Sign out and stop the server
      3. Delete the home folder, browser cache, and the portal-ext.properties
      4. Start Liferay and confirm the dialect is HSQL.
      5. Navigate to http://localhost:8080 and click on "Change" in the setup wizard under Database and fill in the following properties:
        • Database Type: Oracle
        • JDBC URL: jdbc:oracle:thin:@ {server ip}


        • JDBC Driver: oracle.jdbc.driver.OracleDriver
        • User Name: {db name}
        • Password: {db password}
      6. Click 'Finish Configuration'
      7. You will get the following exceptions in the console:
      23:57:37,092 WARN  [BasicResourcePool:1841] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1fde673 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
      java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
              at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
              at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
              at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
              at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
              at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
              at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
              at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
              at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
              at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
              at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
              at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
              at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)




            albert.lee Albert Lee
            albert.lee Albert Lee
            Participants of an Issue:
            Recent user:
            Esther Sanz
            0 Vote for this issue
            2 Start watching this issue


              Days since last comment:
              8 years, 16 weeks, 4 days ago


                Version Package
                --Sprint 11/12
                6.2.0 CE M2