| 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: | Whole Thread | Raw Message | 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 ? |