Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE column TABLE banks (
- sk tinyint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
- code varchar(10) DEFAULT NULL,
- name varchar(100) DEFAULT NULL,
- notes text,
- version smallint DEFAULT NULL,
- PRIMARY KEY (sk)
- );
- @Entity
- @Table(name = "banks")
- class BankHib {
- @Id
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- var sk: Int = _
- var code: String = _
- var name: String = _
- var notes: String = _
- var version: Int = _
- }
- session.beginTransaction
- val b = new BankHib
- b.code = "B3"
- b.name = "xxxxx"
- b.version = 1
- b.notes = "aaa"
- session.save(b)
- session.getTransaction.commit
- @Entity
- @Table(name = "banks")
- class BankHib {
- @Id
- @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "bank_generator")
- @SequenceGenerator(name="bank_generator", sequenceName="bankSeq", allocationSize=1)
- var sk: Int = _
- var code: String = _
- var name: String = _
- var version: Int = _
- }
- CREATE SEQUENCE bankSeq start with 1 increment by 1 minvalue 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement