Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic