I am using JNDI Datasource (running in weblogic8.1) to connect to database. I have inserted 2 rows in the table. Below is the code. I am able to get the resultset. But, I get
"java.sql.SQLException: Result set is in an invalid state. May be before the first row or after the last row". I can understand this is because of not positioning the pointer at the correct place in resultset. I am trying different possibilities. Please let me know what the problem could be?