Apache Cayenne: Handling Postgresql enum types

Question

I have a database type called "foo", defined like:

CREATE TYPE foo AS ENUM('foo','bar','baz');

And when I generate classes for my tables via the Apache Cayenne Modeler, I get an error saying that that field is undefined. Come to find out, there is no type generated for this field.

How do I implement postgresql enumeration types on the java side so Cayenne handles them properly?

score 1 · Answer 1 · answered Sep 13 '13 at 18:05

While Cayenne should've done a better job guessing a type for the enum, you can easily fix that yourself. In the CayenneModeler change the column type of DbEntity to VARCHAR. On the ObjEntity side you can map it as a String, or you can create a Java enum to match your DB enum, and map to that.

Apache Cayenne: Handling Postgresql enum types

1 Answers1