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
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 |