Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. CREATE column TABLE banks (
  2. sk tinyint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
  3. code varchar(10) DEFAULT NULL,
  4. name varchar(100) DEFAULT NULL,
  5. notes text,
  6. version smallint DEFAULT NULL,
  7. PRIMARY KEY (sk)
  8. );
  9.  
  10. @Entity
  11. @Table(name = "banks")
  12. class BankHib {
  13.  
  14. @Id
  15. @GeneratedValue(strategy = GenerationType.IDENTITY)
  16. var sk: Int = _
  17.  
  18. var code: String = _
  19. var name: String = _
  20. var notes: String = _
  21. var version: Int = _
  22. }
  23.  
  24. session.beginTransaction
  25. val b = new BankHib
  26. b.code = "B3"
  27. b.name = "xxxxx"
  28. b.version = 1
  29. b.notes = "aaa"
  30. session.save(b)
  31. session.getTransaction.commit
  32.  
  33. @Entity
  34. @Table(name = "banks")
  35. class BankHib {
  36.  
  37. @Id
  38. @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "bank_generator")
  39. @SequenceGenerator(name="bank_generator", sequenceName="bankSeq", allocationSize=1)
  40. var sk: Int = _
  41.  
  42. var code: String = _
  43. var name: String = _
  44. var version: Int = _
  45. }
  46.  
  47. CREATE SEQUENCE bankSeq start with 1 increment by 1 minvalue 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement