Java Database Connectivity (JDBC)

Hello Geeks
I am calling this method and i am also getting results but in back(log) i am getting java.sql.SQLException: Operation not allowed after ResultSet closed error.


DatabaseManager.createConnection() is in the same package.

public static Registration getChild(int id,String side) {
Registration objReg=null;
PreparedStatement ps = null;
ResultSet rs = null;
String query="select * from registration where parent=? and binaryside=?";
try {
ps = DatabaseManager.createConnection().prepareStatement(query); // create a statement
ps.setInt(1, id); // set input parameter 1
ps.setString(2, side); // set input parameter 2
if(ps.executeQuery()!=null)
rs = ps.executeQuery();

if(!rs.next()) {
log.warn("Child do not exist for Parent Id: " + id + " Side: " + side);
}
else {
objReg = new Registration();
objReg.setID(rs.getInt(1));
objReg.setFirstName(rs.getString(2));
objReg.setMiddleName(rs.getString(3));
objReg.setLastName(rs.getString(4));
/*objReg.setAddress1(rs.getString(5));
objReg.setAddress2(rs.getString(6));
objReg.setCityID(rs.getInt(7));
objReg.setPin(rs.getString(8));
objReg.setContact(rs.getString(9));
objReg.setGender(rs.getString(10));
objReg.setBirthDate(rs.getDate(11));
objReg.setPanCard(rs.getString(12));
objReg.setBankAccount(rs.getString(13));
objReg.setAmount(rs.getLong(14));
objReg.setInvestmentDate(rs.getDate(15));
objReg.setBusinessPlanId(rs.getInt(16));*/
objReg.setParentID(rs.getInt(17));
objReg.setBinarySide(rs.getString(18));
objReg.setUserCode(Login.getRegistrationCode(rs.getInt(1)));
objReg.setName(rs.getString(2) + " " + rs.getString(3).substring(0,1) + " " + rs.getString(4));
objReg.setIsActive(Login.checkIsActive(rs.getInt(1)));

}

}
catch(Exception e) {
log.error("Error in getChild: " + e);
}
finally {
if (rs != null) {
try {
rs.close();
}
catch (SQLException se) {
log.error("Error in closing resultset: " + se);
}
}
if (ps != null) {
try
{
ps.close();
}
catch (SQLException s) {
log.error("Error in closing statement: " + s);
}
}

}
return objReg;
}