[ https://issues.apache.org/jira/browse/CONNECTORS-320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170128#comment-13170128 ]
Karl Wright commented on CONNECTORS-320: ---------------------------------------- r1214707 (trunk) r1214708 (release branch) > 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