Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.33 KB | None | 0 0
  1. @Entity
  2. @Table(name = "features")
  3. @Inheritance(strategy = InheritanceType.JOINED)
  4. @DiscriminatorColumn(name = "subtype_id", discriminatorType = DiscriminatorType.INTEGER)
  5. public class Feature {
  6.  
  7. @Id
  8. @Column(name="id")
  9. @GeneratedValue(generator="sqlite")
  10. @TableGenerator(name="sqlite", table="sqlite_sequence",
  11. pkColumnName="name", valueColumnName="seq",
  12. pkColumnValue="features")
  13. @Getter
  14. @Setter
  15. private long id;
  16.  
  17. @ManyToOne
  18. @JoinColumn(name = "subtype_id")
  19. @Getter
  20. @Setter
  21. private FeatureSubtype featureSubtype;
  22.  
  23. @ManyToOne
  24. @JoinColumn(name = "parent_id")
  25. @Getter
  26. @Setter
  27. private Feature parent;
  28.  
  29. @Column(name = "nam")
  30. @Getter
  31. @Setter
  32. private String name;
  33.  
  34. @Column(name = "coordinates")
  35. @Getter
  36. @Setter
  37. private String coordinates;
  38.  
  39. }
  40.  
  41. @Entity
  42. @Table(name = "dissemination_areas")
  43. @DiscriminatorValue("4")
  44. public class DisseminationArea extends Feature {
  45.  
  46. @Column(name = "area_code")
  47. @Getter
  48. @Setter
  49. private String areaCode;
  50.  
  51. }
  52.  
  53. @Test
  54. public void insertRow() {
  55.  
  56. deleteAll();
  57.  
  58. DisseminationArea disseminationArea = new DisseminationArea();
  59. disseminationArea.setCoordinates("AAA");
  60. disseminationArea.setAreaCode("BBB");
  61.  
  62. disseminationAreaRepo.save(disseminationArea);
  63. }
  64.  
  65. org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Error while committing the transaction
  66.  
  67. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:526)
  68. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
  69. at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
  70. at
  71. ...
  72. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
  73. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
  74. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
  75. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
  76. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
  77. at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  78. at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
  79. at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
  80. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
  81. at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
  82. at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
  83. at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:51)
  84. at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:237)
  85. at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
  86. Caused by: javax.persistence.RollbackException: Error while committing the transaction
  87. at org.hibernate.internal.ExceptionConverterImpl.convertCommitException(ExceptionConverterImpl.java:75)
  88. at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:71)
  89. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
  90. ... 43 more
  91. Caused by: java.lang.ArrayIndexOutOfBoundsException: 4
  92. at org.sqlite.core.CorePreparedStatement.batch(CorePreparedStatement.java:121)
  93. at org.sqlite.jdbc3.JDBC3PreparedStatement.setLong(JDBC3PreparedStatement.java:331)
  94. at org.apache.commons.dbcp2.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:127)
  95. at org.apache.commons.dbcp2.DelegatingPreparedStatement.setLong(DelegatingPreparedStatement.java:127)
  96. at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$1.doBind(BigIntTypeDescriptor.java:46)
  97. at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:74)
  98. at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277)
  99. at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:272)
  100. at org.hibernate.persister.entity.AbstractEntityPersister.dehydrateId(AbstractEntityPersister.java:2699)
  101. at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2667)
  102. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2946)
  103. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3449)
  104. at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
  105. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:586)
  106. at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:460)
  107. at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
  108. at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
  109. at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1420)
  110. at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:476)
  111. at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3179)
  112. at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2393)
  113. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:467)
  114. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:146)
  115. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
  116. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:220)
  117. at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
  118. ... 44 more
  119.  
  120. insert into features (coordinates, subtype_id, nam, parent_id, id) values (?, 4, ?, ?, ?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement