File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
    Bookmark Topic Watch Topic
  • New Topic

Decryption technique is not working in the JSP page

 
rajkumar jayavel
Greenhorn
Posts: 13
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Marshal
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Sheriff
Pie
Posts: 20372
44
Chrome Eclipse IDE Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic