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

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Exception storing ipaddress with JBoss after upgrade to 8.0-312.jdbc3
Date: 2005-09-27 07:06:35
Message-ID: 1127804795.4050.40.camel@Panoramix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message GyLes 2005-09-27 08:19:47 JDBC 3 version 8.0 Error from cast conversion
Previous Message blugering 2005-09-26 13:22:43 unsubscribe