Pooja Dornadhula

I my application the password captured during login is encryped with a random genarated number in jsp and sent to server. Will the password entered in the login jsp form filed before encryption is availbale for any hacker in clear text in System memory or browser memory or RAM?

If so please help me how to avoid that.

Thank you

Currently i have three applications running in my server. All the three pllications are having 3 different logins.

Now i need to have single login instead of thre.. So i am including a another parameter in the login as product along with UserId and Pwd.

Based on the product type i need to send data to that particular applications. Since all the applicatons are having different different contexts. I am not able to send the data using Request or Seesion objects .. For sesurity reasons i can't send as get method parameters using send Redirect.

I heard that Java Connector Api's will solve this issue. Please help me in this regard. Please help me in solving this .

Hi all,

I planning to prepare for SCBCD. Please advice me whether i need to go for 1.3 0r 5.0. I have no knowledge on EJB's also.

Thank you
Pooja D

I am using the below code to read the Excel file. But i am not able to come out of the for loop of result set. Please help me in this issue.

------------------------------CODE----------------------------------------

public Object populateData(File file){
Connection conn = null;
PreparedStatement dataQueryPS = null;
ResultSet dataQueryRS = null;
try{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
conn = DriverManager.getConnection("jdbc dbc river={Microsoft Excel Driver (*.xls)};DBQ=" + file);
String dataQuery = "Select REFNO,DDNO,URL,DATE from [Sheet1$] where REFNO <> null";
dataQueryPS = conn.prepareStatement(dataQuery);
dataQueryRS = dataQueryPS.executeQuery();
for(int i = 0 ;dataQueryRS.next();i++){
System.out.println("i :::: "+i +" "+dataQueryRS.getString(1));
}
return null;
}
catch(Exception e){
e.printStackTrace();
return null;
}finally{
try{
System.out.println(" Iam in final try");

dataQueryRS.close();
dataQueryPS.close();
conn.close();
}catch(Exception t){

}
}
}

------------------------------CODE----------------------------------------

Regards
Pooja D

Lot of time is consuming in the below line of the code

Sheet s = workbook.getSheet("Sheet1");

I am trying to read an excel file from java class. But it is taking more than 20 mins to read the file. Please help me in this issue. I am placing my code below

-------------------------------CODE------------------------------

WorkbookSettings ws = new WorkbookSettings();
ws.setLocale(new Locale("en", "EN"));
Workbook workbook = Workbook.getWorkbook(file, ws);
Sheet s = workbook.getSheet(0);
System.out.println("Initial read Excel Return 3333333");
int rows = s.getRows();
for (int i = 0; i < rows; i++) {
System.out.println("000");
Cell c = (Cell) s.getCell(0, i);
if(c != null && c.getContents() != null && !(c.getContents().trim().equals(""))){
XLDataBean bean = new XLDataBean();
bean.setRefNo(c.getContents());
c = (Cell) s.getCell(1, i);
bean.setTrackingNo(c.getContents());
c = (Cell) s.getCell(2, i);
bean.setUrl(c.getContents());
c = (Cell) s.getCell(3, i);
bean.setDisDate(c.getContents());
list.add(bean);
}else{
break;
}
}
-------------------------------------CODE----------------------------------

Regards
Pooja D

That question i stated above is from uCertify PrepEngine demo version Simulator.

I want to know whether these kind of questions will appear in the SCWCD 1.4 Exam.