[CONNECTORS-506] External HSQLDB fails with exceptions on Ubuntu and Mac OS, but runs fine on Windows

• 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
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 15/Aug/12 02:07
• Updated: 15/Aug/12 05:58
• Resolved: 15/Aug/12 05:58

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