Hi Dmitri,
2013/7/25 <[email protected]> > Hello, > > I saw the thread (from last year) on Postgres' hstore type, and was > wondering if there may be interest in taking another look? > Interest is never the problem :-) > Support has since been added to the JDBC driver: Statement.getObject() now > returns a Map<String,String> for hstore fields, and .setObject() accepts > the same. See > here<http://www.postgresql.org/message-id/[email protected]>for > details. > Good to know! I guess it would make sense for jOOQ to support a generic Map<?, ?> data type. I guess that 1-2 other databases support similar key value stores. I have registered a feature request to analyse this: https://github.com/jOOQ/jOOQ/issues/2653 > Is there a way for the user to provide a Converter to accomplish this? It > seems I can force the type based on column name, any way that can be done > for all columns of a specific type? > You could try. The Map.class type is not yet bound to any internal converter in jOOQ. You might be able to implement a Converter<Object, Map<String, String>>, which simply does the casting for you. That converter could then be assigned to all relevant columns by name-matching (type matching is on the roadmap https://github.com/jOOQ/jOOQ/issues/2352). Let me know how this goes! Cheers Lukas -- 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.
