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

    Details

    • Fix Priority:
      3

      Description

      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}

          :1521:xe

        • 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)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                7 years, 33 weeks, 1 day ago

                Packages

                Version Package
                --Sprint 11/12
                6.2.0 CE M2