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.Kraaijeveld@Askesis.nl
> web: www.askesis.nl
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>