manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markus Schuch" <markus_sch...@web.de>
Subject Re: Migration from mcf 1.1 to 1.7
Date Thu, 23 Oct 2014 12:43:26 GMT
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

Mime
View raw message