How to generate primary key from sequence in HSQLDB

Question

Currently I am using HSQLDB 2.0.0 for my project.

I have a table with primary key and a sequence.

I would like to generate the primary key value from the sequence whenever a insert happens.

Is that possible by a trigger? If so could you let me know how this can be accomplished?

Regards,

Satya

possible duplicate of [Link a sequence with to an identity in hsqldb](http://stackoverflow.com/questions/2954045/link-a-sequence-with-to-an-identity-in-hsqldb) — Lukas Eder, Nov 14 '14 at 09:31

score 3 · Accepted Answer · edited May 23 '17 at 10:29

3

Yes, you can do it with a trigger. See this question

edited May 23 '17 at 10:29

Community

answered Jan 17 '11 at 00:33

fredt

1 Answers1