Like others, I'm trying to figure out how to use my database provider's custom data types with JBOSS 2.4 and CMP.
Specifically, I am using PostgreSQL 7.1, and am trying to use the PostgreSQL data types "point" and "circle".
The PostgreSQL JDBC driver has custom getters and setters for these column types; in addition, get/setObject should work for those types.
Where I'm at with JBoss is, with my CMP bean using the PostgreSQL "PGpoint" data type, I am able to do queries (e.g. find and utilize entity beans), but, I can't create any. When I try to do so, I get this exception in the JBoss console:
Could not create entity:java.sql.SQLException: ERROR: Attribute 'location' is of type 'point' but expression is of type 'int4'
You will need to rewrite or cast the expression
Any help would be appreciated!
Also, by the way, my jaws "jdbc-type" setting is "OTHER", which is consistent with how the JDBC driver for postgresql works (e.g. when you call ResultSetMetaData.getColumnType, the value is 1111 which is "OTHER").