From: helen liu <helengliu@yahoo.com>
To: nickf@ontko.com
To: pgsql-admin@postgresql.org
Subject: Re: query problem
Date: Mon, 13 Jan 2003 20:16:44 -0800 (PST)
Message-ID: <20030114041644.55711.qmail@web14611.mail.yahoo.com> (raw)
In-Reply-To: <NEBBLAAHGLEEPCGOBHDGGEAMGIAA.nickf@ontko.com>
Nick,
Thank you very much for your response. Actually, here is the details:-
I have a Students table with only three columns: firstname, lastname, email. I issued the following select statements:
1) select * from students;
2). select firstname, last name from students;
query 1) worked fine, but query 2) got the following message in client side:
"connect and execute query: The column index is out of range."
and at db server side, I got error message:
"LOG: pq_recvbuf: recv() failed: Connection reset by peer"
I feel that JDBC doesn't like query 2). because both query 1) & 2) works if queried in db directly.
Many thanks for any clarification on this.
Helen
Nick Fankhauser <nickf@ontko.com> wrote:Helen-
There is a separate JDBC list for related questions that I suggest you use
in the future.
A code sample is needed for a really good answer, but I'll make a guess.
This message is probably telling you that you are either trying to set a
value in a where clause that has a higher index than the number you
prepared. (eg: you have two columns constrained and tried to set a third.)
Or, you are trying to read a column from the resultset that has a higher
index than those you defined when preparing the statement. (eg: your query
returns two fields and you're asking for a third.)
Your SQL statement may look fine, but you're either setting or getting
something that it doesn't have.
-Nick
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of helen liu
Sent: Monday, January 13, 2003 11:44 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] query probelm
Hello,
I am new in postgresql. sorry if I may ask simple question. I got error
message when I pass sql statement into database through JDBC. the error msg
is:
"connect and execute query: The column index is out of range."
I check the sql statement string passed into db, it looks fine. I have no
idea what is going wrong. any help is highly appreciated.
Helen
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: helengliu@yahoo.com, nickf@ontko.com
Subject: Re: query problem
In-Reply-To: <20030114041644.55711.qmail@web14611.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox