Failiing to run plugin (2.0.0-M02) with neo4j 2.2.2

[rkimaoui]

Hi,

I am trying to use neo4j plugin (neo4j:2.0.0-M02) for grails with the help of this sample. i would like to run it, in a second time, with hibernate. I am using rest interface to neo4j.

My BuildConfig.groovy is bellow:

grails.servlet.version = "3.0" // Change depending on target container compliance (2.5 or 3.0)
grails.project.class.dir = "target/classes"
grails.project.test.class.dir = "target/test-classes"
grails.project.test.reports.dir = "target/test-reports"
grails.project.work.dir = "target/work"
grails.project.target.level = 1.6
grails.project.source.level = 1.6
//grails.project.war.file = "target/${appName}-${appVersion}.war"

grails.project.fork = [
    // configure settings for compilation JVM, note that if you alter the Groovy version forked compilation is required
    //  compile: [maxMemory: 256, minMemory: 64, debug: false, maxPerm: 256, daemon:true],

    // configure settings for the test-app JVM, uses the daemon by default
    test: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, daemon:true],
    // configure settings for the run-app JVM

    // TODO: workaround, for Neo4j plugin forked mode is currently not working. Reason: Neo4jSpringConfigurer is using
    //    "as Classs" which causes ClassLoader issues
    run: false, //[maxMemory: 768, minMemory: 64, debug: true, maxPerm: 256, forkReserve:false],
    // configure settings for the run-war JVM
    war: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, forkReserve:false],
    // configure settings for the Console UI JVM
    console: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256]
]

grails.project.dependency.resolver = "maven" // or ivy
grails.project.dependency.resolution = {
    // inherit Grails' default dependencies
    inherits("global") {
        excludes 'xml-apis', 'netty', 'stax-api', 'slf4j-jdk14','log4j-over-slf4j', 'logback-classic'
        // specify dependency exclusions here; for example, uncomment this to disable ehcache:
        // excludes 'ehcache'
    }
    log "warn" // log level of Ivy resolver, either 'error', 'warn', 'info', 'debug' or 'verbose'
    checksums true // Whether to verify checksums on resolve
    legacyResolve false // whether to do a secondary resolve on plugin installation, not advised and here for backwards compatibility

    repositories {
        inherits true // Whether to inherit repository definitions from plugins

        grailsPlugins()
        grailsHome()
        mavenLocal()
        grailsCentral()
        mavenCentral()
        // uncomment these (or add new ones) to enable remote dependency resolution from public Maven repositories
        //mavenRepo "http://repository.codehaus.org"
        //mavenRepo "http://download.java.net/maven/2/"
        //mavenRepo "http://repository.jboss.com/maven2/"
        mavenRepo 'http://m2.neo4j.org/content/repositories/releases/'
        //mavenRepo 'http://repo1.maven.org/maven2/org/neo4j/parent/1.9.M05/'
    }

    neo4jVerison="2.0.3"
    dependencies {

        compile("org.neo4j:neo4j-community:$neo4jVerison")
        // add graphviz capabilities
        compile(group:"org.neo4j", name:"neo4j-graphviz", version: neo4jVerison)
        runtime (group:"org.neo4j", name:"neo4j-shell", version: neo4jVerison)

        // uncomment following line if type=rest is used in DataSource.groovy
        runtime "org.neo4j:neo4j-rest-graphdb:1.9"
        //test "org.grails:grails-datastore-test-support:1.0.2-grails-2.4"

    }

    plugins {
        // plugins for the build system only
        build ":tomcat:7.0.55"

        // plugins for the compile step
        compile ":scaffolding:2.1.2"
        compile ':cache:1.1.8'
        compile ":asset-pipeline:1.9.9"
       //runtime ":resources:1.2.1"

     compile ":neo4j:2.0.0-M02"


        // plugins needed at runtime but not for compilation
    //runtime ":hibernate4:4.3.6.1" // or runtime ":hibernate:3.6.10.18"
        runtime ":database-migration:1.4.0"
        runtime ":jquery:1.11.1"

        // Uncomment these to enable additional asset-pipeline capabilities
        //compile ":sass-asset-pipeline:1.9.0"
        //compile ":less-asset-pipeline:1.10.0"
        //compile ":coffee-asset-pipeline:1.8.0"
        //compile ":handlebars-asset-pipeline:1.3.0.3"
    }
}

I'm getting this error:

2015-06-02 02:17:06,092 [localhost-startStop-1] INFO  engine.JdbcCypherEngine  - running cypher CREATE INDEX ON :Attendee(__id__)
Error |
2015-06-02 02:17:06,103 [localhost-startStop-1] ERROR context.GrailsContextLoaderListener  - Error initializing the application: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'neo4jTransactionManager': Cannot resolve reference to bean 'neo4jDatastore' while setting bean property 'datastore'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'neo4jDatastore': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
Message: Error creating bean with name 'transactionManagerPostProcessor': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'neo4jTransactionManager': Cannot resolve reference to bean 'neo4jDatastore' while setting bean property 'datastore'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'neo4jDatastore': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
    Line | Method
->>  262 | run       in java.util.concurrent.FutureTask
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run . . . in java.util.concurrent.ThreadPoolExecutor$Worker
^    745 | run       in java.lang.Thread
Caused by BeanCreationException: Error creating bean with name 'neo4jTransactionManager': Cannot resolve reference to bean 'neo4jDatastore' while setting bean property 'datastore'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'neo4jDatastore': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
->>  262 | run       in java.util.concurrent.FutureTask
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run . . . in java.util.concurrent.ThreadPoolExecutor$Worker
^    745 | run       in java.lang.Thread
Caused by BeanCreationException: Error creating bean with name 'neo4jDatastore': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
->>  262 | run       in java.util.concurrent.FutureTask
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run . . . in java.util.concurrent.ThreadPoolExecutor$Worker
^    745 | run       in java.lang.Thread
Caused by RuntimeException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
->>   80 | execute   in org.grails.datastore.gorm.neo4j.engine.JdbcCypherEngine
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|     67 | afterPropertiesSet in org.grails.datastore.gorm.neo4j.Neo4jDatastore
|     50 | getObject in org.grails.datastore.gorm.neo4j.bean.factory.Neo4jDatastoreFactoryBean
|    262 | run       in java.util.concurrent.FutureTask
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
^    745 | run . . . in java.lang.Thread
Caused by JdbcSQLException: Syntax error in SQL statement "CREATE INDEX ON :[*]ATTENDEE(__ID__) "; expected "identifier"; SQL statement:
CREATE INDEX ON :Attendee(__id__) [42001-176]
->>  344 | getJdbcSQLException in org.h2.message.DbException
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
|    204 | getSyntaxError in     ''
|   3024 | readIdentifierWithSchema in org.h2.command.Parser
|   3055 | readIdentifierWithSchema in     ''
|   4161 | parseCreate in     ''
|    351 | parsePrepared in     ''
|    306 | parse . . in     ''
|    278 | parse     in     ''
|    243 | prepareCommand in     ''
|    442 | prepareLocal in org.h2.engine.Session
|    384 | prepareCommand in     ''
|   1188 | prepareCommand in org.h2.jdbc.JdbcConnection
|     75 | executeQuery in org.h2.jdbc.JdbcStatement
|     77 | execute   in org.grails.datastore.gorm.neo4j.engine.JdbcCypherEngine
|     80 | setupIndexing in org.grails.datastore.gorm.neo4j.Neo4jDatastore
|     67 | afterPropertiesSet in     ''
|     50 | getObject in org.grails.datastore.gorm.neo4j.bean.factory.Neo4jDatastoreFactoryBean
|    262 | run       in java.util.concurrent.FutureTask
|   1145 | runWorker in java.util.concurrent.ThreadPoolExecutor
|    615 | run       in java.util.concurrent.ThreadPoolExecutor$Worker
^    745 | run . . . in java.lang.Thread

Thanks in advance for your help, Réda