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
