Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.72 KB | None | 0 0
  1. Session session = factory.openSession();
  2.  
  3. UserDetail user = new UserDetail();
  4. user.setName("Mark");
  5. user.setPassword("1234567");
  6. user.setUserType(1L);
  7.  
  8. session.beginTransaction();
  9. try {
  10. session.persist(user);
  11. session.getTransaction().commit();
  12. } catch (Exception e) {
  13. session.getTransaction().rollback();
  14. } finally {
  15. session.close();
  16. }
  17.  
  18. @Entity
  19. @Table(name = "USER_DETAIL")
  20. public class UserDetail
  21. {
  22. @Id
  23. @Column(name = "ID", nullable = false)
  24. @SequenceGenerator(name = "gen", sequenceName = "GEN_USER_DETAIL_ID")
  25. @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "gen")
  26. private Long id;
  27.  
  28. @Column(name = "TYPE_ID")
  29. @NotNull
  30. private Long userType;
  31.  
  32. @Column(name = "NAME")
  33. @NotNull
  34. @Size(min = UserDetailConstraint.MIN_USER_NAME, max = UserDetailConstraint.MAX_USER_NAME)
  35. private String name;
  36.  
  37. @Column(name = "HASHED_PASSWORD")
  38. @NotNull
  39. @Size(min = UserDetailConstraint.MIN_PASSWORD, max = UserDetailConstraint.MAX_PASSWORD)
  40. private String password;
  41.  
  42. public Long getId() { return id; }
  43. public void setId(Long id) { this.id = id; }
  44.  
  45. public Long getUserType() { return userType; }
  46. public void setUserType(Long userType) { this.userType = userType; }
  47.  
  48. public String getName() { return name; }
  49. public void setName(String name) { this.name = name; }
  50.  
  51.  
  52. public String getPassword() { return password; }
  53. public void setPassword(String password) { this.password = password; }
  54. }
  55.  
  56. select next_val as id_val from GEN_USER_DETAIL_ID with lock
  57.  
  58. WARN: HHH10001002: Using Hibernate built-in connection pool (not for
  59.  
  60. production use!)
  61. апр 26, 2017 5:19:06 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  62. INFO: HHH10001005: using driver [org.firebirdsql.jdbc.FBDriver] at URL [jdbc:firebirdsql://localhost:3050/warehouse]
  63. апр 26, 2017 5:19:06 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  64. INFO: HHH10001001: Connection properties: {user=SYSDBA, password=****}
  65. апр 26, 2017 5:19:06 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  66. INFO: HHH10001003: Autocommit mode: false
  67. апр 26, 2017 5:19:06 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  68. INFO: HHH000115: Hibernate connection pool size: 5 (min=1)
  69. апр 26, 2017 5:19:06 PM org.hibernate.dialect.Dialect <init>
  70. INFO: HHH000400: Using dialect: org.hibernate.dialect.FirebirdDialect
  71. апр 26, 2017 5:19:06 PM org.hibernate.id.enhanced.SequenceStyleGenerator configure
  72. INFO: HHH000107: Forcing table use for sequence-style generator due to pooled optimizer selection where db does not support pooled sequences
  73. апр 26, 2017 5:19:07 PM org.hibernate.validator.internal.util.Version <clinit>
  74. INFO: HV000001: Hibernate Validator 4.3.2.Final
  75. Hibernate: select next_val as id_val from GEN_USER_DETAIL_ID with lock
  76. апр 26, 2017 5:19:07 PM org.hibernate.id.enhanced.TableStructure$1$1 execute
  77. ERROR: could not read a hi value
  78. org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
  79. SQL error code = -204
  80. Table unknown
  81. GEN_USER_DETAIL_ID
  82. At line 1, column 51
  83.  
  84. @SequenceGenerator(name = "gen",
  85. sequenceName = "GEN_USER_DETAIL_ID",
  86. allocationSize = 1)
  87.  
  88. @Id
  89. @Column(name = "ID", nullable = false)
  90. @GeneratedValue(strategy = GenerationType.IDENTITY)
  91. private Long id;
  92.  
  93. @Id
  94. @Column(name = "ID")
  95. @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "gen")
  96. @GenericGenerator(name = "gen", strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator",
  97. parameters = {@org.hibernate.annotations.Parameter(name = "sequence_name", value = "GEN_USER_DETAIL_ID")
  98. })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement