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