1 Reply Latest reply on Sep 3, 2001 5:12 PM by Bryan Field-Elliot

    Custom Data Types with CMP -- How??

    Bryan Field-Elliot Newbie

      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