Karl Wright created CONNECTORS-506:
--------------------------------------
Summary: External HSQLDB fails with exceptions on Ubuntu and Mac
OS, but runs fine on Windows
Key: CONNECTORS-506
URL: https://issues.apache.org/jira/browse/CONNECTORS-506
Project: ManifoldCF
Issue Type: Bug
Components: Framework core
Affects Versions: ManifoldCF 0.6, ManifoldCF 0.7
Reporter: Karl Wright
Assignee: Karl Wright
Priority: Critical
Fix For: ManifoldCF 0.7
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:
{code}
[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
{code}
... and these on the client:
{code}
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
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
