I think I ran into a real issue now. In
org.jooq.impl.AbstractStoreQuery.prepare(ExecuteContext) for HSQLDB and
other is the following code
for (Field<?> field : returning) {
names.add(field.getName());
}
It seems that field.getName() should follow the renderKeywordStyle
parameter. I hacked up the code to do .toUpperCase() and it resolved my
issue. The issue being that HSQLDB can't find the "id" column on insert.
It wasn't really obvious to me on how to get to RenderContext.keyword()
from that point in the code.
Darren
On Wednesday, November 13, 2013 1:41:33 PM UTC-7, Darren S wrote:
>
> Wow, found a setting just for this!
> setRenderNameStyle(RenderNameStyle.UPPER) Sorry I didn't see that before.
> This is about the 10th time I've ran into an issue and found out there was
> a some API or setting to address it. Can't tell you how much I enjoy using
> jOOQ.
>
> Darren
>
>
> On Wednesday, November 13, 2013 1:37:07 PM UTC-7, Darren S wrote:
>>
>> 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.
