Help:updateRow() with CIDR types

From: Moray Taylor <mugen(at)the400(dot)homeunix(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Help:updateRow() with CIDR types
Date: 2004-04-22 23:13:57
Message-ID: BB48E3E8-94B2-11D8-A8BE-0003935AA5C0@the400.homeunix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-04-23 00:29:48 Re: Help:updateRow() with CIDR types
Previous Message Glenn Holmer 2004-04-22 13:10:42 JDBC rowsets