Hi Karl,
we encountered an issue when migrating on a derby database. (test environment
running on derby)
Is derby migration supported? (may be not in scope, since derby should be used
for production?)
org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception:
SQLException doing query (42X01): Syntaxfehler: Encountered "ONLY" at line 1,
column 13.
at
org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.finishUp(Database.java:702)
at
org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:728)
at
org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:762)
at
org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1435)
at
org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:146)
at
org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:191)
at
org.apache.manifoldcf.core.database.DBInterfaceDerby.performModification(DBInterfaceDerby.java:836)
at
org.apache.manifoldcf.core.database.DBInterfaceDerby.performAlter(DBInterfaceDerby.java:396)
at
org.apache.manifoldcf.core.database.BaseTable.performAlter(BaseTable.java:118)
at
org.apache.manifoldcf.crawler.repository.RepositoryConnectionManager.install(RepositoryConnectionManager.java:167)
at
org.apache.manifoldcf.crawler.system.ManifoldCF.installSystemTables(ManifoldCF.java:619)
at
org.apache.manifoldcf.crawler.system.CrawlerAgent.install(CrawlerAgent.java:116)
at
org.apache.manifoldcf.agents.agentmanager.AgentManager.registerAgent(AgentManager.java:146)
at
org.apache.manifoldcf.crawler.system.ManifoldCF.registerThisAgent(ManifoldCF.java:136)
at
org.apache.manifoldcf.combinedservice.ServletListener.contextInitialized(ServletListener.java:45)
... 10 more
Caused by: java.sql.SQLSyntaxErrorException: Syntaxfehler: Encountered "ONLY"
at line 1, column 13.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at
org.apache.manifoldcf.core.database.Database.execute(Database.java:854)
at
org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:683)
Caused by: java.sql.SQLException: Syntaxfehler: Encountered "ONLY" at line 1,
column 13.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 10 more
Caused by: ERROR 42X01: Syntaxfehler: Encountered "ONLY" at line 1, column 13.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
... 4 more
The failing statement is
ALTER TABLE ONLY repoconnections DROP authorityname
Seems to me that ONLY is not a keyword in derby.
Regards,
Markus
