Help:updateRow() with CIDR types - Mailing list pgsql-jdbc

From Moray Taylor
Subject Help:updateRow() with CIDR types
Date
Msg-id BB48E3E8-94B2-11D8-A8BE-0003935AA5C0@the400.homeunix.com
Whole thread Raw
Responses Re: Help:updateRow() with CIDR types  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Hi,

I'm having some trouble updating CIDR types using jdbc, I use
updateObject() to change it, which goes OK, but when I do an
updateRow(), I get this error

java.sql.SQLException: ERROR: invalid cidr value: "1.1.1.1/4"
    at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRow(AbstractJdbc2Resul
tSet.java:1117)

in other circumstances I get an SQLException with no getMessage()
value, I can't quite put my finger on why the error sometimes changes.

I can change them command-line style no problem.

I am using version 7.5 build 301, the earlier 7.4 driver was worse, it
just returned null for all the values.

Any ideas?

Thanks very much for any help.

Moray


pgsql-jdbc by date:

Previous
From: Glenn Holmer
Date:
Subject: JDBC rowsets
Next
From: Oliver Jowett
Date:
Subject: Re: Help:updateRow() with CIDR types