[CONNECTORS-320] DBCreate on HSQLDB instance operating in external mode fails second time

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: ManifoldCF 0.4
• Fix Version/s: ManifoldCF 0.4
• Component/s: Framework core
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 15/Dec/11 09:23
• Updated: 15/Dec/11 11:31
• Resolved: 15/Dec/11 11:31

Description

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)