On 07/22/2014 07:10 PM, Martin Gudmundsson wrote: > Hi all! > I saw that Rails 4 comes with hstore support out of the box. > > Does anyone know if there’s any integrated support like that in hibernate or > any other JPA implementation? > I know your able to write your own custom datatypes, but I’m looking for > integrated standardized support in the base library.
I haven't seen any JPA providers with built-in support for hstore. Unfortunately there's also no type extension SPI for JPA, so the is no standard way to provide extension types that don't depend directly on a particular JPA provider's guts. Frankly I think the concept of JPA for fully provider-independent portable dev is a waste of time for anything except toy apps or very small databases - anything real generally needs per-query fetch control and other things JPA just doesn't provide for. I suggest picking a provider and sticking to it. If you're developing a new app, rather than targeting hstore, consider starting work with PostgreSQL 9.4 (currently in beta-2) and using the jsonb type. That way you can use the numerous good quality json tools in Java to map json to/from Java objects or manipulate json trees, while saving them to the DB and loading them from the DB as native json fields. If you use hstore, you'll have to write the equivalent yourself or crib from someone else. So why not start on the right foot and go straight for jsonb? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
