Hi jlutherthomas
FME still cannot Write to Neo4j
I download the driver from here
https://neo4j.com/blog/neo4j-jdbc-driver-3-0-3-and-3-1-0-released/
since the link you give me looks like using newer version of FME, that has more "option" to key in
https://blog.safe.com/2017/12/jdbc-swiss-army-knife-database-formats/
i had to format the jdbc Connection string like below :
jdbc:neo4j:bolt://localhost:7687/?user=neo4j,password=,debug=true,noSsl,flatten=[-1,100,1000]
as mentioned in https://github.com/neo4j-contrib/neo4j-jdbc
3-1-2018-10-51-47-am.jpg
3-1-2018-10-57-38-am.jpg
I wonder why, even using the neo4j Driver it still using SQL "CREATE TABLE command"
Writer Log :
Trying to find a JAVA plugin for writer named `JDBC'
FME Configuration: No destination coordinate system set
Using Java Writer Interface Version 2.0 (Oct 31, 2000) with module JDBC to write data to dataset `jdbc:neo4j:bolt:<solidus><solidus>localhost:7687<solidus>?user=neo4j<comma>password=<comma>debug=true<comma>noSsl<comma>flatten=<openbracket>-1<comma>100<comma>1000<closebracket>'
Writer `JDBC_1' of type `JDBC' using group definition keyword `JDBC_1_DEF'
JDBC Writer: Preloading JDBC Driver Class 'org.neo4j.jdbc.bolt.BoltDriver'
JDBC Writer: Creating connection using connection string 'jdbc:neo4j:bolt://localhost:7687/?user=neo4j,password=psswrd,debug=true,noSsl,flatten==-1,100,1000]' and properties '{user=neo4j, password=************}'
JDBC Writer: Connected to 'Neo4j' version '3.3.1' using driver 'Neo4j JDBC Driver' version '3.1.0' built against JDBC version '4.0'
JDBC Writer: Connection class 'org.neo4j.jdbc.bolt.BoltConnection' is being loaded from '/D:/Program Files/FME/plugins/neo4j-jdbc-driver-3.1.0.jar'
JDBC Writer: Committing feature 0
JDBC Writer: Creating table using SQL: CREATE TABLE "VGC_POLE" ("G3E_FNO" integer, "G3E_FID" bigint, "ACCTG_STATUS" varchar(40), "CENTRAL_OFFICE" varchar(50), "CO_DATE" varchar(4), "EXCH_CODE" varchar(40), "FEATURE_STATE" varchar(10), "INSTALL_DATE" double precision, "INST_CENT" smallint, "JOB_ID" varchar(30), "JOB_STATE" varchar(50), "MIN_MATERIAL" varchar(15), "OWNERSHIP" varchar(255), "PPWO" varchar(50), "EXCHANGE" varchar(25), "WORK_ORDER" varchar(30), "YEAR_PLACED" varchar(4), "FEATURE_TYPE" varchar(50), "GRID_NO" double precision, "LOCATION" varchar(50), "HEIGHT" numeric(38,10), "MATERIAL" varchar(20), "DP_NO" varchar(13), "POLE_NO" varchar(4), "NODE1_ID" varchar(40), "NODE2_ID" varchar(40))
JDBC Writer: Failed to create table 'VGC_POLE'. Error: org.neo4j.driver.v1.exceptions.ClientException: Invalid input '"': expected whitespace, comment, '=', node labels, MapLiteral, a parameter, a relationship pattern, ',', LOAD CSV, FROM, INTO, START, MATCH, UNWIND, MERGE, CREATE GRAPH >>, CREATE >> GRAPH, CREATE GRAPH, CREATE, SET, DELETE GRAPHS, DELETE, REMOVE, FOREACH, WITH, CALL, PERSIST, RELOCATE, RETURN, SNAPSHOT, UNION, ';' or end of input (line 1, column 14 (offset: 13))
"CREATE TABLE "VGC_POLE" ("G3E_FNO" integer, "G3E_FID" bigint, "ACCTG_STATUS" varchar(40), "CENTRAL_OFFICE" varchar(50), "CO_DATE" varchar(4), "EXCH_CODE" varchar(40), "FEATURE_STATE" varchar(10), "INSTALL_DATE" double precision, "INST_CENT" smallint, "JOB_ID" varchar(30), "JOB_STATE" varchar(50), "MIN_MATERIAL" varchar(15), "OWNERSHIP" varchar(255), "PPWO" varchar(50), "EXCHANGE" varchar(25), "WORK_ORDER" varchar(30), "YEAR_PLACED" varchar(4), "FEATURE_TYPE" varchar(50), "GRID_NO" double precision, "LOCATION" varchar(50), "HEIGHT" numeric(38,10), "MATERIAL" varchar(20), "DP_NO" varchar(13), "POLE_NO" varchar(4), "NODE1_ID" varchar(40), "NODE2_ID" varchar(40))"
^
JDBC Writer: Table 'VGC_POLE' does not exist
COM.safe.fme.TableDoesntExistException
at COM.safe.fme.JdbcWriter.checkTable(JdbcWriter.java:1767)
COM.safe.fme.TableDoesntExistException
at COM.safe.fme.JdbcWriter.prepareForWriting(JdbcWriter.java:490)
at COM.safe.fme.JdbcWriter.write(JdbcWriter.java:280)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Feature output statistics for `JDBC' writer using keyword `JDBC_1':
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Features Written
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
VGC_POLE 1
==============================================================================
Total Features Written 1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
COM.safe.fme.TableDoesntExistException
COM.safe.fme.TableDoesntExistException
FME Session Duration: 7.9 seconds. (CPU: 4.7s user, 0.5s system)
END - ProcessID: 3244, peak process memory usage: 972188 kB, current process memory usage: 935644 kB
COM.safe.fme.TableDoesntExistException
Program Terminating
Translation FAILED.
