Re: [HACKERS] JPA + enum == Exception - Mailing list pgsql-jdbc

From Tom Dunstan
Subject Re: [HACKERS] JPA + enum == Exception
Date
Msg-id CAPPfruxCkSnOotBWPmio3RTSikCrWnS1Gw8ytJP_s7WMqQEe3g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] JPA + enum == Exception  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: [HACKERS] JPA + enum == Exception  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On 5 July 2013 19:27, Dave Cramer <pg@fastcrypt.com> wrote:
I would think setObject should respect stringtype=unspecified. So I would be willing to accept this as a solution

OK, here's a pull request with a unit test to cover expected behaviour with different combinations of setObject and setString, for inserts and queries.


Interestingly, when I first tried this I tried using point as the type to test rather than an enum (so that I didn't have to create the enum type in the test), but it would fail when trying to select a row out in a query like "select * from thetable where p = ?" saying "operator does not exist: point = unknown". I presume that this due to multiple = operators for the point type at the db level, so the backend can't decide which type to create. I guess there's not much that we can do about that - if things are ambiguous then you need to be more specific, and of course we have a PGpoint java object anyway.

Cheers

Tom

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: [HACKERS] JPA + enum == Exception
Next
From: m_muthukumar@yahoo.com
Date:
Subject: Fw: