DBCreate on HSQLDB instance operating in external mode fails second time
------------------------------------------------------------------------
Key: CONNECTORS-320
URL: https://issues.apache.org/jira/browse/CONNECTORS-320
Project: ManifoldCF
Issue Type: Bug
Components: Framework core
Affects Versions: ManifoldCF 0.4
Reporter: Karl Wright
Assignee: Karl Wright
Priority: Blocker
Fix For: ManifoldCF 0.4
When ManifoldCF is configured to run HSQLDB, if you try to create the database
twice you get an exception. This is used during upgrades. PostgreSQL works
fine here. The exception is:
C:\wip\mcf\CONNECTORS-313\dist\multiprocess-example>initialize.bat
Configuration file successfully read
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: E
xception doing query: object name already exists: DBNAME
at org.apache.manifoldcf.core.database.Database.executeViaThread(Databas
e.java:672)
at org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Dat
abase.java:716)
at org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.creat
e(Database.java:1363)
at org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndEx
ecute(CacheManager.java:144)
at org.apache.manifoldcf.core.database.Database.executeQuery(Database.ja
va:179)
at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.createUserAndDa
tabase(DBInterfaceHSQLDB.java:621)
at org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(Man
ifoldCF.java:683)
at org.apache.manifoldcf.crawler.RegisterConnectors.createDatabaseAndSch
ema(RegisterConnectors.java:71)
at org.apache.manifoldcf.crawler.RegisterAll.doExecute(RegisterAll.java:
33)
at org.apache.manifoldcf.crawler.TransactionalCrawlerInitializationComma
nd.execute(TransactionalCrawlerInitializationCommand.java:43)
at org.apache.manifoldcf.crawler.RegisterAll.main(RegisterAll.java:55)
Caused by: java.sql.SQLException: object name already exists: DBNAME
at org.hsqldb.jdbc.Util.sqlException(Util.java:255)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1838)
at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636)
at org.apache.manifoldcf.core.database.Database.execute(Database.java:77
7)
at org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(D
atabase.java:632)
--
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
