Hi Markus, I'm sorry, but Derby migration has never been supported. It's never supposed to be used in production. In fact, it will no longer be supported in any manner on MCF 2.0.
Thanks, Karl On Thu, Oct 23, 2014 at 8:43 AM, Markus Schuch <[email protected]> wrote: > 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 >
