Neo4j specific conversions

Neo4j does not support all types used in the relational world. For some of them we offer conversions that are also available in frameworks such as Spring Data Neo4j (SDN). Those conversions are available in this driver as well, so you could use both SDN and this driver interchangeably.

Data types for fixed-point arithmetic

Neo4j does not support BigInteger and BigDecimal. The only way to store them is as String, and to read them back into the corresponding type. This is in line with SDN and OGM.

Any parameter of those types passed to PreparedStatement or CallableStatement will be stored as String, but can be read back through corresponding methods on the result sets.

SQL Date, Time and Timestamps

java.sql.Date: Maps to Cypher DATE
java.sql.Time: Maps to Cypher LOCAL TIME
java.sql.Timestamp: Maps to Cypher LOCAL DATETIME

For information on Cypher^® date types, see Temporal types.

For more precise a mapping, use a Neo4j Value instance with the appropriate type and its methods setObject and getObject.