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
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:
I'm getting this error:
Thanks in advance for your help, Réda