Hi all,
Basically i was makaing out one application. I had got the connection successfully, but when i iterate the resultset am getting no values as well as its size too is 0. Below am posting out the excerpts of my code and the output i'am getting. Can anyone please advice why its so? Though when am running the same query in DB itself its fetching me results??
and am getting the values as below too, which confirms that connection is successful.
Inside DAO 1-------------------------- weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@b
Inside DAO 2-------------------------- weblogic.jdbc.wrapper.Statement_oracle_jdbc_driver_T4CStatement@c
Inside DAO 3-------------------------- weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl@d
But when the below code executes just after the above one-:
do{
if(!rs.next()){
System.out.println("rs is not having anymore values !!!");
break;}
//some logic for query
}
} while(true);
Am coming out of the loop and getting result as-:
rs is not having anymore values !!!
[ May 07, 2008: Message edited by: pranav bhatt ]