Re: [HACKERS] JPA + enum == Exception

<div>På fredag 05. juli 2013 kl. 11:47:22, skrev Tom Dunstan &lt;<a href="mailto:pgsql(at)tomd(dot)cc" target="_blank">pgsql(at)tomd(dot)cc</a>&gt;:</div>

<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">Hi Andreas
<div class="gmail_extra"> 
<div class="gmail_quote">On 5 July 2013 18:51, Andreas Joseph Krogh <span dir="ltr">&lt;<a href="mailto:andreak(at)officenet(dot)no" target="_blank">andreak(at)officenet(dot)no</a>&gt;</span> wrote:

<blockquote class="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>I've been using Hibernate for years with mapping Enums to varchar-columns which works fine. Remember to map them with</div>

<div> </div>
</blockquote>

<div> </div>

<div style="">I'm not trying to map them to varchar columns - I'm trying to map them to columns with postgresql enum types as created by CREATE TYPE, see e.g. <a href="http://www.postgresql.org/docs/9.2/static/datatype-enum.html" target="_blank">http://www.postgresql.org/docs/9.2/static/datatype-enum.html</a>. The built-in enum types are designed for that purpose, and perform better and more safely than using varchars.</div>

<div style=""> </div>

<div style="">Mapping java enums to a typesafe and efficient version in the db was the main reason I did the work to add native enums to postgresql in the first place - I haven't had a chance to use it recently, and I'm a bit disappointed that it doesn't work out of the box. So I want to fix up whatever parts of the stack are in the way of making that work.</div>
</div>
</div>
</div>
</blockquote>

<div> </div>

<div>I'm sorry, I missread your post.</div>

<div> </div>

<div class="origo-email-signature">--<br>
Andreas Joseph Krogh &lt;andreak(at)officenet(dot)no&gt;      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>