[
https://issues.apache.org/jira/browse/CONNECTORS-506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright resolved CONNECTORS-506.
------------------------------------
Resolution: Fixed
> 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
