Hmm, thinking about it. Similar to introducing support for UUID types by mapping Fields to java.util.UUID, the expected Java type associated with Postgres' INET type would be java.net.InetAddress.
Any thoughts? 2013/1/4 Lukas Eder <[email protected]> > Hello, > > >> ERROR: column "created_ip" is of type inet but expression is of type > character varying > >> >> Hint: You will need to rewrite or cast the expression. >> >> Is there a way to solve this issues? >> > > The easiest workaround is to write this: > > factory.insertInto(REGISTRATION) > .set(REGISTRATION.EMAIL, "[email protected]") > .set(REGISTRATION.PASSWORD_HASH, "2304820984309238409237428739") > .set(REGISTRATION.CREATED_IP, field("?::inet", String.class, "::1")) > .execute(); > > By using plain SQL, you can cast bind values to custom data types > > Should type INET be supported by jooq natively? >> > > It probably should, I have created #2092 for this: > https://github.com/jOOQ/jOOQ/issues/2092 > > So far, I'm not quite sure how to handle these dialect-specific data > types, that are not really compatible with any of java.sql.Types' types. > Specifically, Postgres and the Postgres JDBC driver have their ways of > dealing with these non-standard situations. > > Any implementation hint for #2092 is very welcome > > Cheers > Lukas >
