Java persistence with enum types - Mailing list pgsql-jdbc

From Susannah Relf
Subject Java persistence with enum types
Date
Msg-id 548aeab30905230702x1e7d0620nb3686c49bf889a68@mail.gmail.com
Whole thread Raw
Responses Re: Java persistence with enum types  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-jdbc
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;

This works for reading from the database, but writing to it, I get the error message:
Caused by: org.postgresql.util.PSQLException: ERROR: column "typeofname" is of type typeofnames but expression is of type character varying

Anyone got any suggestions?

Thanks



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Does 8.3/8.4 support lazy fetched + updateable +scrollable ResultSets?
Next
From: Craig Ringer
Date:
Subject: Re: Java persistence with enum types