Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-506

External HSQLDB fails with exceptions on Ubuntu and Mac OS, but runs fine on Windows

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: ManifoldCF 0.6, ManifoldCF 1.0
    • Fix Version/s: ManifoldCF 1.0
    • Component/s: Framework core
    • Labels:
      None

      Description

      When you run the multi-process example on Windows, there are no errors starting the database and running initialize.bat. But when you run the same thing on Ubuntu, you get these on the server:

      [Server@732a54f9]: To close normally, connect and execute SHUTDOWN SQL
      [Server@732a54f9]: From command line, use [Ctrl]+[C] to abort abruptly
      [Server@732a54f9]: [Thread[HSQLDB Connection @210a6ae2,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist
      [Server@732a54f9]: [Thread[HSQLDB Connection @4bbd7848,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist
      [Server@732a54f9]: [Thread[HSQLDB Connection @351e1e67,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist
      [Server@732a54f9]: [Thread[HSQLDB Connection @46b8c8e6,5,HSQLDB Connections @732a54f9]]: database alias=xdb does not exist
      

      ... and these on the client:

      org.apache.manifoldcf.core.interfaces.ManifoldCFException: Error getting connection: General error: database alias does not exist
      	at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:100)
      	at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:722)
      	at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1394)
      	at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144)
      	at org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:186)
      	at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.createUserAndDatabase(DBInterfaceHSQLDB.java:591)
      	at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:699)
      	at org.apache.manifoldcf.crawler.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:123)
      	at org.apache.manifoldcf.crawler.InitializeAndRegister.doExecute(InitializeAndRegister.java:37)
      	at org.apache.manifoldcf.crawler.InitializeAndRegister.main(InitializeAndRegister.java:60)
      Caused by: java.sql.SQLException: General error: database alias does not exist
      	at org.hsqldb.jdbc.Util.sqlException(Util.java:418)
      	at org.hsqldb.jdbc.Util.sqlException(Util.java:113)
      	at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3604)
      	at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:312)
      	at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:260)
      	at java.sql.DriverManager.getConnection(DriverManager.java:620)
      	at java.sql.DriverManager.getConnection(DriverManager.java:200)
      	at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:94)
      	at org.apache.manifoldcf.core.database.ConnectionFactory.getConnectionWithRetries(ConnectionFactory.java:125)
      	at org.apache.manifoldcf.core.database.ConnectionFactory.getConnection(ConnectionFactory.java:96)
      	... 9 more
      Caused by: org.hsqldb.HsqlException: General error: database alias does not exist
      	at org.hsqldb.error.Error.error(Error.java:285)
      	at org.hsqldb.ClientConnection.<init>(ClientConnection.java:147)
      	at org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3588)
      	... 16 more
      

        Attachments

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              kwright@metacarta.com Karl Wright
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: