Field name is case sensitive for getValue method but shouldn't that be case insensitive?

[Venkat Sadasivam]

It would be nice if the following method support field name being case insensitive. In any database column name is case insensitive hence similar behaviour in jooq would make easy for developers.

org.jooq.Record.getValue(String)

[Lukas Eder]

Hi Venkat,

You're right, in many cases, case-insensitivity through jOOQ API would be very desireable. A similar idea has been discussed previously on the jOOQ User Group. Discussions have then led to issue #2656:

https://github.com/jOOQ/jOOQ/issues/2656

I'm thinking that there should be a Setting to indicate that case-insensitive Field access should be enabled. Possibly, the RenderNameStyle setting could be reused for this case:

http://www.jooq.org/javadoc/latest/org/jooq/conf/RenderNameStyle.html

The four options would then imply:

- QUOTED: Everything is case-sensitive

- AS_IS: Everything is case-insensitive

- LOWER: Everything is case-insensitive and reported names are lower-cased

- UPPER: Everything is case-insensitive and reported names are upper-cased

Does that make sense? Did I forget something?

Looking forward to hearing from you,

Lukas

2014-03-26 15:38 GMT+01:00 Venkat Sadasivam <venka...@gmail.com>:

It would be nice if the following method support field name being case insensitive. In any database column name is case insensitive hence similar behaviour in jooq would make easy for developers.

org.jooq.Record.getValue(String)

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Venkat Sadasivam]

Hi Lukas:

Using RenderNameStyle seems to be a good idea.  We are currently using AS_IS so it will fix our issue.

Thanks.

Venkat

--
You received this message because you are subscribed to a topic in the Google Groups "jOOQ User Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jooq-user/P7wJ-JPTeNs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jooq-user+...@googlegroups.com.

[Lukas Eder]

Good,

I will update this thread once this is implemented. I'm positive it can make it into jOOQ 3.4

Best Regards,

Lukas