HSQLDB external database tests fail ----------------------------------- Key: CONNECTORS-330 URL: https://issues.apache.org/jira/browse/CONNECTORS-330 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
Here's the exception we get: [junit] Database exception: Exception doing query: user lacks privilege or o bject not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname VARCH AR(255) NOT NULL PRIMARY KEY)] [junit] org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: user lacks privilege or object not found: PUBL IC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) NOT NULL PRIM ARY KEY)] [junit] at org.apache.manifoldcf.core.database.Database.executeViaThread (Database.java:672) [junit] at org.apache.manifoldcf.core.database.Database.executeUncachedQ uery(Database.java:716) [junit] at org.apache.manifoldcf.core.database.Database$QueryCacheExecut or.create(Database.java:1363) [junit] at org.apache.manifoldcf.core.cachemanager.CacheManager.findObje ctsAndExecute(CacheManager.java:144) [junit] at org.apache.manifoldcf.core.database.Database.executeQuery(Dat abase.java:179) [junit] at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.perform Modification(DBInterfaceHSQLDB.java:746) [junit] at org.apache.manifoldcf.core.database.DBInterfaceHSQLDB.perform Create(DBInterfaceHSQLDB.java:361) [junit] at org.apache.manifoldcf.core.database.BaseTable.performCreate(B aseTable.java:111) [junit] at org.apache.manifoldcf.agents.agentmanager.AgentManager.instal l(AgentManager.java:72) [junit] at org.apache.manifoldcf.agents.system.ManifoldCF.installTables( ManifoldCF.java:73) [junit] at org.apache.manifoldcf.agents.tests.BaseHSQLDBext.localSetUp(B aseHSQLDBext.java:65) [junit] at org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.localSetUp( BaseHSQLDBext.java:60) [junit] at org.apache.manifoldcf.crawler.tests.BaseHSQLDBext.setUp(BaseH SQLDBext.java:48) [junit] Caused by: java.sql.SQLException: user lacks privilege or object not found: PUBLIC in statement [CREATE CACHED TABLE agents(classname VARCHAR(255) N OT NULL PRIMARY KEY)] [junit] at org.hsqldb.jdbc.Util.sqlException(Util.java:255) [junit] at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java: 1838) [junit] at org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636) [junit] at org.apache.manifoldcf.core.database.Database.execute(Database .java:777) [junit] at org.apache.manifoldcf.core.database.Database$ExecuteQueryThre ad.run(Database.java:632) [junit] [junit] -- 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