Ah, no I wasn’t. Thanks for this solution ;)
-Hal
> On Oct 28, 2015, at 12:13 AM, rishabhtulsian <rishabh.tuls...@gmail.com>
> wrote:
>
> Hal, were you able to resolve this? I am trying to achieve the same.
>
> From what I have read the Postgresql driver support it and for it to work
> with a Prepared Statement you need to create a PGobject and set its type to
> "uuid" and value to the uuid string. And a setObject on prepared statement
> would work. So the 'toDataStoreValue' method should look like this
> if (object instanceof UUID) {
> PGobject pg = new PGobject();
> pg.setType("uuid");
> try {
> pg.setValue(object.toString());
> } catch (SQLException e) {
> logger.error("Failed to convert value: " + object, e);
> }
> return pg;
> }
> return null;
>
> But, OpenJPA translates the column type from Types.OTHER to Types.BLOB after
> calling UuidValueHandler.map
> Thats because DBDictionary.getJDBCType defaults to returning Types.BLOB as a
> result the setBlobObject is called on PreparedStatement.
>
> My solution was to provide a custom DBDictionary which returns Types.OTHER
> for JavaTypes.PC and in UuidValueHandler.map set the java type on the column
> to JavaTypes.PC and it worked.
>
>
>
> --
> View this message in context:
> http://openjpa.208410.n2.nabble.com/OpenJPA-PostgreSQL-UUID-column-tp7587837p7588657.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
