• Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC ans Stored Procedures

 
Shashi Iyy
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!