Re: Java persistence with enum types

Hi,

Thanks for trying to help Craig, but I had tried the @enumerated annotation
already with the same error message. The @enumerated annotation doesn't
return an enum type to Postgres, but instead returns the ordinal value (by
default) or a string value of the enum. This means I get either the error
message:

Caused by: org.postgresql.util.PSQLException: ERROR: column "typeofname" is
of type typeofnames but expression is of type character varying
(if I use enumtype STRING)

Or

Caused by: org.postgresql.util.PSQLException: ERROR: column "typeofname" is
of type typeofnames but expression is of integer



Craig Ringer wrote:
>
> Susannah Relf wrote:
>> Hi, I have an enum type in my postgres 8.3 database:
>>
>> CREATE TYPE typeOfNames AS ENUM ('Latin', 'Common', 'Local');
>>
>> I am trying to access the database through the Java Persistence API using
>> Netbeans:
>>     @Lob
>>     @Column(name = "typeofname")
>>     private String typeofname;
>
> One minute with Google:
>
> @Enumerated
> http://java.sun.com/javaee/5/docs/api/javax/persistence/Enumerated.html
>
> http://forums.java.net/jive/thread.jspa?messageID=240608
> http://www.oracle.com/technology/products/ias/toplink/jpa/resources/toplink-jpa-annotations.html#Enumerated
> ... etc ...
>
> --
> Craig Ringer
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>

--
View this message in context: http://www.nabble.com/Java-persistence-with-enum-types-tp23684815p23705886.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.