queries against CIDR fail against 8.0.3? - Mailing list pgsql-jdbc

From Russell Francis
Subject queries against CIDR fail against 8.0.3?
Date
Msg-id 433BE38F.3080605@ev.net
Whole thread Raw
Responses Re: queries against CIDR fail against 8.0.3?  (Kris Jurka <books@ejurka.com>)
Re: queries against CIDR fail against 8.0.3?  (Oliver Jowett <oliver@opencloud.com>)
List 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

pgsql-jdbc by date:

Previous
From: Russell Francis
Date:
Subject: Re: How to retieve binary data (bytea) without problem ?
Next
From: Alfredo Rico
Date:
Subject: Re: How to retieve binary data (bytea) without problem ?