春季启动 Neo4j @NodeEntity 中的 Integer 属性引发错误。

huangapple
go评论109阅读模式
英文:

Spring boot neo4j @NodeEntity with Integer property throwing error

问题

当我将字段rowStatusId的数据类型设置为Integer/int时，我可以使用.save()方法将节点保存到Neo4j数据库，但是在使用findByName(String name)检索记录时，系统会抛出以下错误（错误发生在service中的"LineItemStatus status = lineItemStatusRepository.findByName("New");"处）。当我将数据类型更改为Long时，我不会收到任何错误。

我们不能使用Integer吗？还是我需要包含其他任何依赖项？请帮助我。

错误信息：

Caused by: org.neo4j.ogm.exception.core.MappingException: Error mapping GraphModel

Caused by: org.springframework.core.convert.ConverterNotFoundException: 无法找到可从类型[java.lang.Long]转换为类型[int]的转换器

以下是我的代码：

  1. import org.neo4j.ogm.annotation.GeneratedValue;
  2. import org.neo4j.ogm.annotation.Id;
  3. import org.neo4j.ogm.annotation.NodeEntity;
  5. @NodeEntity
  6. public class LineItemStatus {
  7.     @Id
  8.     @GeneratedValue
  9.     private Long id;
  10.     private String name;
  11.     private String description;
  12.     private int rowStatusId;
  14.     public LineItemStatus(String name, String description, int rowStatusId) {
  15.         this.name = name;
  16.         this.description = description;
  17.         this.rowStatusId = rowStatusId;
  18.     }
  20.     public Long getId() {
  21.         return id;
  22.     }
  24.     public void setId(Long id) {
  25.         this.id = id;
  26.     }
  28.     public String getName() {
  29.         return name;
  30.     }
  32.     public void setName(String name) {
  33.         this.name = name;
  34.     }
  36.     public String getDescription() {
  37.         return description;
  38.     }
  40.     public void setDescription(String description) {
  41.         this.description = description;
  42.     }
  44.     public int getRowStatusId() {
  45.         return rowStatusId;
  46.     }
  48.     public void setRowStatusId(int rowStatusId) {
  49.         this.rowStatusId = rowStatusId;
  50.     }
  51. }

Repository：

  1. import com.ns.tbe.model.nodes.LineItemStatus;
  2. import org.springframework.data.neo4j.repository.Neo4jRepository;
  3. import org.springframework.stereotype.Repository;
  5. @Repository
  6. public interface LineItemStatusRepository extends Neo4jRepository<LineItemStatus, Long> {
  7.     LineItemStatus findByName(String name);
  8. }

Service：

  1. import org.springframework.beans.factory.annotation.Autowired;
  2. import org.springframework.stereotype.Service;
  4. @Service
  5. public class LineItemStatusService {
  6.     @Autowired
  7.     LineItemStatusRepository lineItemStatusRepository;
  9.     public void saveLineItemStatus() {
  10.         lineItemStatusRepository.save(new LineItemStatus("New", "new", 1));
  11.         lineItemStatusRepository.save(new LineItemStatus("Modified", "modified", 1));
  12.         lineItemStatusRepository.save(new LineItemStatus("Deleted", "deleted", 1));
  14.         LineItemStatus status = lineItemStatusRepository.findByName("New");
  15.     }
  16. }

build.gradle文件：

  1. plugins {
  2.     id 'org.springframework.boot' version '2.3.0.RELEASE'
  3.     id 'io.spring.dependency-management' version '1.0.9.RELEASE'
  4.     id 'java'
  5. }
  7. group = 'com.ns'
  8. version = '0.0.1-SNAPSHOT'
  9. sourceCompatibility = '11'
  11. repositories {
  12.     mavenCentral()
  13. }
  15. dependencies {
  17.     implementation 'org.springframework.boot:spring-boot-starter-data-neo4j'
  18.     compile group: 'org.neo4j', name: 'neo4j-ogm-bolt-driver', version: '3.2.11'
  19.     compile group: 'org.apache.commons', name: 'commons-lang3', version: '3.10'
  20.     implementation 'org.springframework.boot:spring-boot-starter'
  21.     testImplementation('org.springframework.boot:spring-boot-starter-test') {
  22.         exclude group: 'org.junit.vintage', module: 'junit-vintage-engine'
  23.     }
  24. }
  26. test {
  27.     useJUnitPlatform()
  28. }

应用程序属性（application.properties）：

  1. spring.data.neo4j.uri=bolt://localhost:7687
  2. spring.data.neo4j.username=neo4j
  3. spring.data.neo4j.password=secret
英文:

When I use data type as Integer/int for field rowStatusId, I am able to save node to neo4j database using .save() method but while retrieving the record using findByName(String name), system throwing error as below (error occurred at "LineItemStatus status = lineItemStatusRepository.findByName("New");" in service ). I am not receiving any error when I change the data type to Long.

Can't we use Integer? or do I need to include any other dependencies? Please help me.

  1. Caused by: org.neo4j.ogm.exception.core.MappingException: Error mapping GraphModel
  3. Caused by: org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.lang.Long] to type [int]

Below is my code

  1. import org.neo4j.ogm.annotation.GeneratedValue;
  2. import org.neo4j.ogm.annotation.Id;
  3. import org.neo4j.ogm.annotation.NodeEntity;
  5. @NodeEntity
  6. public class LineItemStatus {
  7.     @Id
  8.     @GeneratedValue
  9.     private Long id;
  10.     private String name;
  11.     private String description;
  12.     private int rowStatusId;
  14.     public LineItemStatus(String name, String description, int rowStatusId) {
  15.         this.name = name;
  16.         this.description = description;
  17.         this.rowStatusId = rowStatusId;
  18.     }
  20.     public Long getId() {
  21.         return id;
  22.     }
  24.     public void setId(Long id) {
  25.         this.id = id;
  26.     }
  28.     public String getName() {
  29.         return name;
  30.     }
  32.     public void setName(String name) {
  33.         this.name = name;
  34.     }
  36.     public String getDescription() {
  37.         return description;
  38.     }
  40.     public void setDescription(String description) {
  41.         this.description = description;
  42.     }
  44.     public int getRowStatusId() {
  45.         return rowStatusId;
  46.     }
  48.     public void setRowStatusId(int rowStatusId) {
  49.         this.rowStatusId = rowStatusId;
  50.     }
  51. }

reopsioty:

  1. import com.ns.tbe.model.nodes.LineItemStatus;
  2. import org.springframework.data.neo4j.repository.Neo4jRepository;
  3. import org.springframework.stereotype.Repository;
  5. @Repository
  6. public interface LineItemStatusRepository extends Neo4jRepository&lt;LineItemStatus, Long&gt; {
  7.     LineItemStatus findByName(String name);
  8. }

Service:

  1. import org.springframework.beans.factory.annotation.Autowired;
  2. import org.springframework.stereotype.Service;
  4. @Service
  5. public class LineItemStatusService {
  6.     @Autowired
  7.     LineItemStatusRepository lineItemStatusRepository;
  9.     public void saveLineItemStatus() {
  10.         lineItemStatusRepository.save(new LineItemStatus(&quot;New&quot;, &quot;new&quot;, 1));
  11.         lineItemStatusRepository.save(new LineItemStatus(&quot;Modified&quot;, &quot;modified&quot;, 1));
  12.         lineItemStatusRepository.save(new LineItemStatus(&quot;Deleted&quot;, &quot;deleted&quot;, 1));
  14.         LineItemStatus status = lineItemStatusRepository.findByName(&quot;New&quot;);
  15.     }
  16. }

build.gradle file:

  1. plugins {
  2. 	id &#39;org.springframework.boot&#39; version &#39;2.3.0.RELEASE&#39;
  3. 	id &#39;io.spring.dependency-management&#39; version &#39;1.0.9.RELEASE&#39;
  4. 	id &#39;java&#39;
  5. }
  7. group = &#39;com.ns&#39;
  8. version = &#39;0.0.1-SNAPSHOT&#39;
  9. sourceCompatibility = &#39;11&#39;
  11. repositories {
  12. 	mavenCentral()
  13. }
  15. dependencies {
  17. 	implementation &#39;org.springframework.boot:spring-boot-starter-data-neo4j&#39;
  18.     compile group: &#39;org.neo4j&#39;, name: &#39;neo4j-ogm-bolt-driver&#39;, version: &#39;3.2.11&#39;
  19. 	compile group: &#39;org.apache.commons&#39;, name: &#39;commons-lang3&#39;, version: &#39;3.10&#39;
  20. 	implementation &#39;org.springframework.boot:spring-boot-starter&#39;
  21. 	testImplementation(&#39;org.springframework.boot:spring-boot-starter-test&#39;) {
  22. 		exclude group: &#39;org.junit.vintage&#39;, module: &#39;junit-vintage-engine&#39;
  23. 	}
  24. }
  26. test {
  27. 	useJUnitPlatform()
  28. }

Application Properties:

  1. spring.data.neo4j.uri=bolt://localhost:7687
  2. spring.data.neo4j.username=neo4j
  3. spring.data.neo4j.password=secret

答案1

得分: 1

驱动程序倾向于将整数存储为长整型。这里有一个详细的解释，说明了正在发生的情况：https://michael-simons.github.io/neo4j-sdn-ogm-tips/understand_the_type_system.html。

为了简化事情，您可能希望将 rowStatusId 更改为 long 类型。

英文:

Drivers tend to store integers as longs. Here is a nicely detailed explanation of what is going on: https://michael-simons.github.io/neo4j-sdn-ogm-tips/understand_the_type_system.html.

To simplify things, you may want to change rowStatusId to be of type long.

huangapple
  • 本文由 发表于 2020年8月25日 22:03:45
  • 转载请务必保留本文链接：https://go.coder-hub.com/63580609.html
  • java
  • neo4j
  • spring-boot
  • spring-data-neo4j
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定