Hi guys,
First time poster and recent user of JOOQ (loving it so far!)
For testing purposes, I'm creating a database in HSQLDB 2.2.8 with,
for example:
CREATE TABLE market (
id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1
INCREMENT BY 1) PRIMARY KEY,
version TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
name VARCHAR(2),
lang VARCHAR(10),
country VARCHAR(2)
);
INSERT INTO market (name, lang, country) VALUES ('es', 'es', 'ES');
This works OK and with direct JDBC I have had no problems so far. But
when my factory extends from a JOOQ HSQLDBFactory I get the following
query in the debug messages:
select "market"."id", "market"."version", "market"."name",
"market"."lang", "market"."country" from "market" where "market"."id"
= 1
And this breaks the whole thing for HSQLDB:
org.jooq.exception.DataAccessException: AbstractQuery.execute;
SQL [select "market"."id", "market"."version", "market"."name",
"market"."lang", "market"."country" from "market" where "market"."id"
= cast(? as bigint)];
user lacks privilege or object not found: market
Now, when I switch and extend my factory from SQLiteFactory everything
works so far:
select market.id, market.version, market.name, market.lang,
market.country from market where market.id = 1
Seems clear that the problem is with the double quotes, so my question
is, can I turn those off?
BTW, I've tested this in HSQLDB 2.2.4 & 2.2.8 with the same results.
Thanks for the help, and thanks for JOOQ.
