Skip to content

Problem when re-indexing routes #133

Closed
raziel057 opened this Issue Nov 11, 2012 · 3 comments

2 participants

@raziel057

I have updated the pluggin with the last nightly build, but when I try to reconvert my project to Symfony Project (to reindex it), I've got the following error:

org.h2.jdbc.JdbcSQLException: NULL not allowed for column ACTION; SQL statement:
-- IF YOU UPDATE THIS FILE, DON'T FORGET TO INCREMENT THE Schema.VERSION!
-- This is a prepared statement for inserting
-- an element declaration record. Table name
-- is substituted in a runtime.

INSERT INTO ROUTES(
NAME,
PATTERN,
CONTROLLER,
BUNDLE,
ACTION,
PATH)

VALUES(?,?,?,?,?,?);
[90006-117]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.getSQLException(Message.java:116)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:279)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:593)
at org.h2.command.dml.Insert.update(Insert.java:98)
at org.h2.command.CommandContainer.update(CommandContainer.java:72)
at org.h2.command.Command.executeUpdate(Command.java:208)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:140)
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1052)
at com.dubture.symfony.index.dao.BaseDao.commitInsertions(BaseDao.java:36)
at com.dubture.symfony.index.SymfonyIndexer.exitRoutes(SymfonyIndexer.java:146)
at com.dubture.symfony.core.builder.AbstractSymfonyVisitor.indexRoutes(AbstractSymfonyVisitor.java:193)
at com.dubture.symfony.core.builder.AbstractSymfonyVisitor.loadXML(AbstractSymfonyVisitor.java:240)
at com.dubture.symfony.core.builder.AbstractSymfonyVisitor.handleResource(AbstractSymfonyVisitor.java:88)
at com.dubture.symfony.core.builder.ResourceVisitor.visit(ResourceVisitor.java:32)
at org.eclipse.core.internal.resources.Resource$2.visit(Resource.java:126)
at org.eclipse.core.internal.resources.Resource$1.visitElement(Resource.java:85)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:82)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.doIteration(ElementTreeIterator.java:86)
at org.eclipse.core.internal.watson.ElementTreeIterator.iterate(ElementTreeIterator.java:127)
at org.eclipse.core.internal.resources.Resource.accept(Resource.java:95)
at org.eclipse.core.internal.resources.Resource.accept(Resource.java:52)
at org.eclipse.core.internal.resources.Resource.accept(Resource.java:124)
at org.eclipse.core.internal.resources.Resource.accept(Resource.java:108)
at com.dubture.symfony.core.builder.SymfonyBuilder.fullBuild(SymfonyBuilder.java:60)
at com.dubture.symfony.core.builder.SymfonyBuilder.build(SymfonyBuilder.java:45)
at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:728)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:199)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:239)
at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:292)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:295)
at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:351)
at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:374)
at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:143)
at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:241)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

@pulse00
Owner
pulse00 commented Feb 4, 2013

Sorry for the late reply. What you could try is to

  1. Close eclipse
  2. Remove all files in <workspaceDir>/.metadata/.plugins/com.dubture.symfony.index
  3. Start eclipse from the commandline with the --clean flag.
@pulse00
Owner
pulse00 commented May 6, 2013

@raziel057 please reopen if this still persists in the latest version (1.0.94).

@pulse00 pulse00 closed this May 6, 2013
@raziel057

Ok thanks. No problem!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.