Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group