Exception in running query

From: Bellur Ashwin <bell_ashwin(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Exception in running query
Date: 2007-04-10 17:14:11
Message-ID: 758357.44713.qm@web50604.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I issued one query to postgres using JDBC, it returned an exception saying the specified column does not exist. My java code handles this exception and subsequently when i try to run some other queries i am getting the following exception:

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1
at java.util.ArrayList.RangeCheck(ArrayList.java:546)
at java.util.ArrayList.get(ArrayList.java:321)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1223)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)

my java code is

Statement stmt1=conn.createStatement();
try{

ResultSet rs1=stmt1.executeQuery("select * from emp where e1<=100");
/* col e1 does not exist in table emp but table */ /* emp exist */

}catch(Exception e)
{
e.printStackTrace();
}

Statement stmt2=conn.createStatement();
try{

ResultSet rs2=stmt2.executeQuery("select * from emp"); //Here i am getting exception

}catch(Exception e)
{
e.printStackTrace();
}

Can i know where the problem is?

With Regards,
Bellur Ashwin

Send a FREE SMS to your friend's mobile from Yahoo! Messenger. Get it now at http://in.messenger.yahoo.com/

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-04-10 17:57:27 Re: Exception in running query
Previous Message Kris Jurka 2007-04-09 16:14:11 Re: Prepared statement parameter and timestamp