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

Joost,

The new driver uses server side prepared statements and is much more
particular about the types being sent.

You can force v2 protocol, or create a PGInet type extending PGObject

Regards,

Dave
On 27-Sep-05, at 3:06 AM, Joost Kraaijeveld wrote:

> 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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>