Menu
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
211
However, HSQLDB highly outperforms H2 in DDL operations as well as when starting/shutting down the instance, even for a small database (due to H2's compiling stored functions afresh with javac at every database startup!). This depends on the way you store stored functions.
HSQLDB (HyperSQL DataBase) is the leading SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes.
HSQLDB (Hyper SQL Database) is a relational database management system written in Java.
Yes, you can do it with a trigger. See this question
Link a sequence with to an identity in hsqldb
104
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
