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: (view raw, whole thread or download thread mbox)
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: ""
>     at  
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.updateRow(AbstractJdbc2Resul 

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..


In response to


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-2017 The PostgreSQL Global Development Group