Decryption technique is not working in the JSP page

[rajkumar jayavel]

DataSource ds = null;
Connection con = null;
InitialContext ic;
PreparedStatement pr = null;
ResultSet rs = null;
String user = "";
String pass = "";
String sQuery = "SELECT PASSWORD,USERNAME FROM PDBUSER (NOLOCK) WHERE userindex='1'";
out.println("BFORE initiating the connection");
try {
ic = new InitialContext();
System.out.println("sql Query:"+sQuery);
out.println("sql Query:"+sQuery);
ds = (DataSource) ic.lookup("java:/daiichi_prd");
con = ds.getConnection();
pr = con.prepareStatement(sQuery);
rs = pr.executeQuery();
JTSSecurity objJTSSecurity = null;
while (rs.next()) {
System.out.println("initiating the connection");
out.println("initiating the connection");
byte passwordbyte[] = rs.getBytes(1);
out.println("passwordbyte:"+passwordbyte);
String passwordstr = new String(passwordbyte);
out.println("passwordstr"+passwordstr);
byte aabyte0[] = passwordstr.getBytes("ISO8859_1");
objJTSSecurity = new JTSSecurity();
byte value1[] = objJTSSecurity.decode(aabyte0);
pass = new String(value1);
user = rs.getString(2);

}
rs.close();
pr.close();
con.close();
System.out.println("Test Print ln pwd:" + pass);
System.out.println("Test Print ln user" + user);
out.println("Test Print ln pwd:" + pass);
out.println("Test Print ln user" + user);
} catch (Exception e) {
out.println("Exception in connect cabinet..-->" + e.getMessage());
}


Following code could decrypt the password working fine in the stand alone java program,
whenver i added in the JSP tag its not working for me.
Please help me

[Jaikiran Pai]

I've moved this to the JDBC forum since Ranch Office isn't the place to discuss this. Although you say it's got to do with JSP, looking at the code, I don't think the problem lies in anything related to JSP. JDBC looks like an appropriate forum for this, right now. By the way, you'll have to add more details on what you mean by "not working".

[Rob Spoor]

Please UseOneThreadPerQuestion. Since you have some more information in your other thread and the problem seems to only occur in JSP pages, I'll close this thread.