Creating a datetime native type with spring-data-neo4

[leonard_panichi]

I'm trying to create a neo4j native datetime type (Temporal (Date/Time) values - Neo4j Cypher Manual) with spring data neo4j. I have a rest controller which takes an object as parameter, this object is then directly saved to neo4j.
I skip the rest controller, I'll give later the implementation of the object.
I'm using

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.2.0.RELEASE</version>
	</parent>

and all packages with <groupId>org.neo4j</groupId> use version 3.2.2.

I'm using the following pieces of forum and documentation :

How to use Neo4J native types with SDN and OGM Spring Data Neo4j & Neo4j-OGM

Hi Peter. Thanks for your question. Currently, the Neo4j-OGM documentation points to Version 3.2 which has not been released yet. This is an error on our site. Regarding the parameter binding: This is also a current bug in Neo4j-OGM on our site. Neo4j-OGM uses Jacksons ObjectMapper to convert parameters and that one doesn't know how do deal with JDK 8 types out of the box. I solved this in my demo projects in the following way at the moment: First of all: Fix the ObjectMapper. This will be …

Using dates with OGM and Bolt Spring Data Neo4j & Neo4j-OGM

I'm getting an error when I have date values in OGM @Node properties. I think I'm following the documentation correctly (https://neo4j.com/docs/ogm-manual/3.0/reference/#reference:type-conversion) but maybe not. I've searched these forums and SO but don't see a reference to Bolt not supporting Date. I have nodes in the graph.db name:"countries 1945", version:0.9, published:date({year:2013, month:07, day:1}), validFrom:date({year:1945, month:1, day:1}), validUntil:date({year:1993, mon…

Neo4j Graph Database Platform

Working with Cypher values - Neo4j Driver Manual

This section describes the types and values used by Cypher and how they map to native language types.

Based on this, I wrote an object and a no op converter:
MyObject:

public class MyObject{
    @Convert(NoOpZonedDateTimeConversion.class)
    private ZonedDateTime testDate;
// + getter and setter
}

NoOpZonedDateTimeConversion :

public class NoOpZonedDateTimeConversion implements AttributeConverter<LocalDateTime, LocalDateTime> {
  @Override
  public LocalDateTime toGraphProperty(LocalDateTime value) {
    return value;
  }

  @Override
  public LocalDateTime toEntityAttribute(LocalDateTime value) {
    return value;
  }
}

This registers a string in my database (neo 3.5.5-enterprise).
I tried a few converters with various native java date type, I tried without converter, simple question : is it suppose to work or am I missing something ?

[gerrit_meier]

You have to opt-in to enable the native type support. More details in this great blog post (section Native types support) written by @michael.simons.
The key ingredient is to add (assuming you are using bolt protocol) the native type support dependency

<dependency>
    <groupId>org.neo4j</groupId>
    <artifactId>neo4j-ogm-bolt-native-types</artifactId>
    <version>3.2.2</version>
    <scope>runtime</scope>
</dependency>

and enable it either via ogm.properties,

use-native-types=true

the Configuration definition

Configuration configuration = new Configuration.Builder()
        .uri("bolt://neo4j:password@localhost")
        .useNativeTypes()
        .build()

or if you are using Spring Boot for your application you can do this (starting from Spring Boot 2.2) via the application.properties.

spring.data.neo4j.use-native-types=true

[leonard_panichi]

gerrit.meier:

Native types support

Thanks for the help, so far I did not succeed to register a ZonedDateTime native java object in the database as a neo4j DateTime.
I'm using spring boot and I enabled native types in my application.yml. I also added the maven dependancy neo4j-ogm-bolt-native-types.

My NodeEntity has a ZonedateTime private parameter with accessors.
I'm posting a json with this date : "1996-10-15T00:05:32.000Z" and I end up with 1996-10-15T00:05:32[UTC] in the database. I suspect that it might also be a problem with spring boot deserialization of java date types, I'll have to investigate but that will be for another time I'm afraid.

Thanks for the help 🙂

[leonard_panichi · Accepted solution]

Sorry it took me a while but just to close this thread :
I run now neo4j 4.1 with docker
I have added in my pom

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
      <groupId>org.springframework.data</groupId>
      <artifactId>spring-data-neo4j</artifactId>
      <version>5.3.2.RELEASE</version>
    </dependency>

    <dependency>
      <groupId>org.neo4j</groupId>
      <artifactId>neo4j-ogm-bolt-native-types</artifactId>
      <version>3.2.14</version>
      <scope>runtime</scope>
    </dependency>

In application.yml :

 spring:
    data:
        neo4j:
            use-native-types: "true"

I have a property in a node entity with getters and setters
LocalDateTime date;

And I can now register LocalDateTime directly in my DB which is great necause I have access to all methods and tools of Date and Time in neo4j (better than String imo)

Thanks for the good job.