the piece of code and error stack are
while(res.next())
{
PreparedStatement pstmt = con.prepareStatement("select count(*) from TB_USER where USER_ID = ?");
pstmt.setInt(1,res.getInt(1));
ResultSet count = pstmt.executeQuery();
pstmt3.setInt(1,res.getInt(1));
ResultSet date = pstmt3.executeQuery();
if(count.getInt(1)==0) //
java:65
{
Errors
-----------
java.sql.SQLException: ResultSet.next was not called
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:517)
at com.Murthy.First.updateOracleTables(First.java:65)
at com.Murthy.First.main(First.java:127) }