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

From Andreas Joseph Krogh
Subject Re: [HACKERS] JPA + enum == Exception
Date
Msg-id OrigoEmail.925.90efc08f02ee47a3.13fae200537@prod2
Whole thread Raw
In response to Re: [HACKERS] JPA + enum == Exception  (Tom Dunstan <pgsql@tomd.cc>)
Responses Re: [HACKERS] JPA + enum == Exception  (Tom Dunstan <pgsql@tomd.cc>)
List pgsql-jdbc
<div>På fredag 05. juli 2013 kl. 09:51:03, skrev Tom Dunstan <<a href="mailto:pgsql@tomd.cc"
target="_blank">pgsql@tomd.cc</a>>:</div><blockquotestyle="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt0pt 0.8ex; padding-left: 1ex;"><div dir="ltr">On 9 February 2013 02:56, Kris Jurka <span dir="ltr"><<a
href="mailto:books@ejurka.com"target="_blank">books@ejurka.com</a>></span> wrote: <div class="gmail_extra"><div
class="gmail_quote"><blockquoteclass="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div
class="im"><spanstyle="color:rgb(34,34,34)">The other workaround is to use the url parameter stringtype=unspecified
to</span></div>have setString always bind to unknown instead of varchar, which then<br /> shouldn't require any code
changes.</blockquote><div> </div><divstyle="">I just tried this with a new project using hibernate and postgres with an
enumtype . Unfortunately, the hibernate (3.6) enum type calls setObject(pos, value, Types.VARCHAR) rather than calling
setString(pos,value), and that doesn't respect the stringtype property.</div><div style=""> </div><div style="">What's
thefeeling here - should setObject(Types.VARCHAR) respect stringtype=unspecified? I don't know whether there are
semanticdifferences between setString() and setObject(Types.VARCHAR) to know if that's naughty or not. It seems like
theonly way for me to use this version of hibernate with pgsql enums is to either change the driver or implement a
customuser type and configure it everywhere. :(</div><div style=""> </div><div style="">Happy to whip up a patch if
there'sconsensus to change the driver.</div><div style=""> </div><div style="">Cheers</div><div style=""> </div><div
style="">Tom</div></div></div></div></blockquote><div> </div><div>I'vebeen using Hibernate for years with mapping Enums
tovarchar-columns which works fine. Remember to map them with</div><div> </div><div>@Column(name =
"column_name")</div><div>@Enumerated(EnumType.STRING)</div><div>privateMyEnum enum =
<stuff></div><div> </div><divclass="origo-email-signature">--<br /> Andreas Joseph Krogh
<andreak@officenet.no>     mob: +47 909 56 963<br /> Senior Software Developer / CTO - OfficeNet AS -
http://www.officenet.no<br/> Public key: http://home.officenet.no/~andreak/public_key.asc</div><div> </div> 

pgsql-jdbc by date:

Previous
From: Tom Dunstan
Date:
Subject: Re: [HACKERS] JPA + enum == Exception
Next
From: Tom Dunstan
Date:
Subject: Re: [HACKERS] JPA + enum == Exception