Re: Java persistence with enum types
От | The Jasper |
---|---|
Тема | Re: Java persistence with enum types |
Дата | |
Msg-id | 321ed0a30905260817s5f92344kc7ecb76af623f3b3@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Java persistence with enum types (Susannah <cyclingrelf@googlemail.com>) |
Список | pgsql-jdbc |
On Mon, May 25, 2009 at 2:01 PM, Susannah <cyclingrelf@googlemail.com> wrote: > > 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 I think you have the same problem I did a while back. A colleague of mine figured it out. There is a partial answer here: http://stackoverflow.com/questions/851758/java-enums-jpa-and-postgres-enums-how-do-i-make-them-work-together Don't have time to dig up and clean up the actual code we use now but I can if you'd like (and you're not in a hurry). mvg, Jasper -- http://xkcd.com/583/
В списке pgsql-jdbc по дате отправления: