Hello Jake, I'm moving this discussion over to the jOOQ-user group...
jOOQ currently doesn't support Postgres' HSTORE data type. There is a pending feature request for this on the roadmap: https://sourceforge.net/apps/trac/jooq/ticket/994 Unfortunately, I have no experience with that data type. From the documentation, it looks as though an integration is quite complex. The most important question for jOOQ supporting it, is how does the Postgres JDBC driver support and transport that type? Is there a common Java representation for that type, that jOOQ could use to bind for <T>? Cheers Lukas 2012/1/23 Jacob Gilley <[email protected]>: > Hello, > > We're currently using JOOQ on a project and I am very excited to have > it in our technology stack. I was wondering if you could provide some > information on using JOOQ with the Postgres HSTORE data type? All of > the HSTORE manipulation functions are generated in JOOQ just fine. But > when selecting records of this type, JOOQ simply returns a > java.lang.Object. Any advice on how to get this working? Thanks in > advance and thanks again for this wonderful API. > > Regards, > Jake
