Hi All,
I am using the following code :
public HashMap getSkillsList(
String msId) throws Exception
{
Connection conn = null;
CallableStatement cs = null;
ResultSet rs = null;
HashMap skillsListMap = null;
String skill = null;
int i = 1;
try
{
skillsListMap = new HashMap();
conn = SkillsDBConnection.getConnection();
cs = conn.prepareCall("{call P_SKILL_ID (?,?)}",ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
cs.registerOutParameter(1,OracleTypes.CURSOR);
cs.setString(2,msId);
cs.execute();
rs = (ResultSet)cs.getObject(1);
//rs.next();
while (rs.next())
{
if ((null != rs.getString(1)) && (null != rs.getString(2)))
{
System.out.println("Skill Name : " + rs.getString(1));
System.out.println("Skill Id : " + rs.getString(2));
skill = rs.getString(1);
skill = skill + "~" + rs.getString(2);
System.out.println("Skill : " + skill);
skillsListMap.put("" + i, skill);
++i;
}
}
} catch(Exception e) {
e.printStackTrace();
} finally {
rs.close();
cs.close();
conn.close();
}
return skillsListMap;
}
I am unable to make the ResultSet scrollable.Can anyone help me in resolving the issue of making the resultset scrollable?A example would be much better.Thanks in advance.