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/
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 |