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
Check out what you're missing if you're not on
Yahoo! Messenger
