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