Skip to content

Tag: h2

Single quotes cause trouble while filtering in Slick

I have statements such as below and they fail with exceptions such as this I have tried to escape the single quote but wasn’t successful. When I tried to insert a record such as this: The exception I’ve gotten is: Please note that I am using H2 in Mysql mode to run my tests. Answer That error suggests to me

H2 Db, ID NextVal

I have a sequence as: CREATE SEQUENCE OWNER_SEQ START WITH 1; I need to trigger this sequence for OWNER table’s ID column CREATE TABLE METADATA.OWNER ( OWNER_ID NUMBER NEXTVAL(…