Custom Data Types with CMP -- How??

[bryanfe]

Hi,

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!

Thank you,

Bryan

[bryanfe]

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").

Bryan