[
https://issues.apache.org/jira/browse/CONNECTORS-330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13171588#comment-13171588
]
Karl Wright commented on CONNECTORS-330:
----------------------------------------
It looks like we have to initialize the connection on every fetch from the pool.
r1215508 (trunk)
r1215510 (release branch)
> 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
