Exception storing ipaddress with JBoss after upgrade to 8.0-312.jdbc3

Hi,

I am trying to store an ipaddress in a PostgreSQL column of a INET type.
This used to work with pg74.216.jdbc3 but after an upgrade to
postgresql-8.0-312.jdbc3  I get an exception:

ERROR: column "ipaddress" is of type inet but expression is of type
character varying.

The PostgreSQL log shows:

LOG:  statement: INSERT INTO accesspoint (objectId, ipAddress,
locationName, macAddress, manufacturer, serialNumber, supplier,
typeName, address) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
2005-09-27 08:57:48 [12459] ERROR:  column "ipaddress" is of type inet
but expression is of type character varying
HINT:  You will need to rewrite or cast the expression.

De CMP field is defined as @jboss.jdbc-type VARCHAR and @jboss.sql-type
INET

Is this a known problem? If so, is there a known sollution (and are you
willing to share that sollution ;-))?

The suggestion about the rewrite/cast hint is not possible because this
is a CMP bean and JBoss takes care of writing that .


--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl