Does anyone know how to implement databasetype enums in ibatis (NOTE: This is not the same as implementing Java enums!) The problem is that IBatis does not know how to insert duplexMode (typeof: String) into database's suplexMode(typeof: x.duplex_mode)!?
Here is configuration: I have database schema like this: -------------------------------------------- CREATE SCHEMA x; CREATE TYPE x.duplex_mode AS ENUM ( 'Auto', 'Full Duplex', 'Half Duplex' ); CREATE TABLE x.interface ( ipaddr INET NOT NULL UNIQUE, duplexMode x.duplex_mode, id BIGSERIAL, PRIMARY KEY(id) ); My IBatis descriptor like this: --------------------------------------- <sqlMap namespace="Interfaces"> <insert id="insertInterface" parameterClass="InterfaceBean"> insert into x.interface ( ipaddr, duplexMode ) values ( inet(#ipAddr#), #duplexMode# ) </insert> </sqlMap> My bean class like this: ------------------------------- public class InterfaceBean { private int id; private String ipAddr; private String duplexMode; public InterfaceBean() { super(); } <..all getters and setters...> } The problem is that IBatis does not know how to insert duplexMode (typeof: String) into database's suplexMode(typeof: x.duplex_mode)!?