Hi,
Here is a patch to enable initial support for hstore in the jdbc driver.
With the patch using ResultSet.getObject() on a hstore column and it returns a HashMap<String, String>
Similarly a Statement.setObject(Map<Object,Object> will send the data to backend using hstore format.
The patch supports both text and binary transfer modes. However the current patch does not automatically enable the
fasterbinary transfer more, but instead
user has to currently add binaryTransferEnable=<hstore-oid> to connection parameters.
I'm still pondering how to enable the binary transfers automatically without the overhead of fetching the hstore oid on
eachconnection startup.
- can it be cached to some static cache based on connection url+login information?
- if not then a way to lazy evaluate it needs to be implemented
-Mikko