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