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

Re: Help:updateRow() with CIDR types

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Moray Taylor <mugen(at)the400(dot)homeunix(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Help:updateRow() with CIDR types
Date: 2004-04-23 00:29:48
Message-ID: 4088637C.6080802@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Moray Taylor wrote:
> 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)

What object type and SQL typecode are you passing to updateObject()? Can 
we see that bit of code?

Turn on log_statement on the backend; what is the entire query that errors?

 From memory the driver doesn't really have support for CIDR types other 
than as raw strings, but that might have changed..

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-04-23 06:58:57
Subject: Re: JDBC rowsets
Previous:From: Moray TaylorDate: 2004-04-22 23:13:57
Subject: Help:updateRow() with CIDR types

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