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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
rfrancis.vcf | text/x-vcard | 262 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Alfredo Rico | 2005-09-29 13:52:53 | Re: How to retieve binary data (bytea) without problem ? |
Previous Message | Russell Francis | 2005-09-29 12:20:27 | Re: How to retieve binary data (bytea) without problem ? |