I've ran into an issue with HSQLDB and curious if there is any solution you know of. According to the HSQLDB docs "all parts of SQL statements are converted to upper case before processing, *except identifiers in double quotes and strings in single quotes". *So what is happening is select * from book works but select * from "book" does not work as the table name is actually BOOK and HSQLDB seems to check case. Since jooq always quotes fields this basically means jooq doesn't work with HSQLDB at all for me. Any thoughts?
I'm thinking that nobody has probably hit this issue because they have mostly likely generated the records from HSQLDB and the meta data has uppercase table names. What I've done is generated the records from mysql and then tried to use them against hsqldb. I would like to stick with that approach as mysql is my production DB, but hsqldb is what I use for testing and small setups. I'm going to try H2 and see if it works better. *Darren* -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
