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:
              8 years, 16 weeks, 4 days ago

                Packages

                Version Package
                --Sprint 11/12
                6.2.0 CE M2