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

Re: JDBC bug?

From: "Colin Freas" <cef6(at)georgetown(dot)edu>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC bug?
Date: 2001-11-26 20:41:28
Message-ID: IIEPJDIJEEBPKJGDFFBEAEDMCAAA.cef6@georgetown.edu (view raw or flat)
Thread:
Lists: pgsql-jdbc
> via quoted mixed case identifiers.  I haven't seen any evidence that
> basic SQL operations (select, insert, update, delete) have a bug in them.

I'd peg a where clause as a basic SQL operation, and be it bug, feature,
annoyance, whatever, it wasn't functioning because of the case of a column
name.

This worked:
1.  rs = stmt.executeQuery("select * from response");

But I wanted to do this, which didn't work:
2.  rs = stmt.executeQuery("select * from response where questionID=16");

This is how I got it to work:
3.  rs = stmt.executeQuery("SELECT \"response\".\"questionID\",
\"response\".\"respondentID\", \"response\".\"answer\", \"response\".\"ID\"
FROM \"response\" WHERE "\response\".\"questionID\"=16");

Sorry, does anyone think the third is better than the second?


In response to

Responses

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-11-26 20:42:27
Subject: Re: JDBC bug?
Previous:From: Barry LindDate: 2001-11-26 20:34:43
Subject: Re: JDBC bug?

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