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

queries against CIDR fail against 8.0.3?

From: Russell Francis <rfrancis(at)ev(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: queries against CIDR fail against 8.0.3?
Date: 2005-09-29 12:52:31
Message-ID: 433BE38F.3080605@ev.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
Greetings,

I have a web application which is running against PG 7.3.9 and seems to
work without a problem.  Recently, I have been trying to run it against
8.0.3.  In both cases, I am using the jdbc3-8.0-312 driver.

The application fails when running against 8.0.3 at this query.

PreparedStatement s = dbConn.prepareStatement(
"SELECT * FROM institution WHERE ( institution.network >>=  ? ) LIMIT 1" );
s.setObject( 1, (String)request.getRemoteAddr() );
if( s.execute() )
{
	...
}

DEBUG http-8180-Processor25 net.fitne.vlrc.actions.IndexAction - ERROR:
operator does not exist: cidr >>= character varying
net.ev.dao.DAOException: ERROR: operator does not exist: cidr >>=
character varying
         at net.ev.dao.DatabaseDAO.executeStatement(DatabaseDAO.java:656)
         at net.ev.dao.DatabaseDAO.find(DatabaseDAO.java:1199)

Does anyone have any ideas on how to address this issue?  Or at least an
explanation as to why it works in 7.3.9 but not 8.0.3?

Thanks in advance,
Russ

Attachment: rfrancis.vcf
Description: text/x-vcard (262 bytes)

Responses

pgsql-jdbc by date

Next:From: Alfredo RicoDate: 2005-09-29 13:52:53
Subject: Re: How to retieve binary data (bytea) without problem ?
Previous:From: Russell FrancisDate: 2005-09-29 12:20:27
Subject: Re: How to retieve binary data (bytea) without problem ?

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