error

[jesmi]

public void sendMail(String smtpServer,String to,String from,String subject,String body ) throws Exception{


try{
SendMail.send(smtpServer,to,from,subject,body);

log.info("Mail delivered to: " +to);
System.out.print("Mail Delivered !!!"+to);


try{
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
List result=null;
Map resultMap = null;
con = Utilities.getDbConnection();
result = new ArrayList();


stmt = con.prepareStatement("INSERT INTO call_history " +
"(pis_cd,email,remarks) " +
" values(?,?,?)");

stmt.setString(1,pisCd);
stmt.setString(2,email);
stmt.setString(3,remarks);

stmt.executeUpdate();

con.commit();
log.info("Added a new message: " + pisCd +" by "+ pisCd);
//System.out.println("Added a new bank: " + bankDesc +" by "+ us.getName());
}

//error starts from here
catch (SQLException errSql){
con.rollback();
log.error("err: "+ errSql);
throw errSql;

}}
catch (Exception err){
if (con != null) con.rollback();
log.error("err: "+ err);
throw err;

}finally {

try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();

} catch (Exception err){
log.debug("cant send mail due to: "+err );
throw new Exception(" Please check smtp, admin email address. "+err);
}
}

}

error in stmt,con,rs

plz help me

[r035198x]

public void sendMail(String smtpServer,String to,String from,String subject,String body ) throws Exception{


try{
SendMail.send(smtpServer,to,from,subject,body);

log.info("Mail delivered to: " +to);
System.out.print("Mail Delivered !!!"+to);


try{
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
List result=null;
Map resultMap = null;
con = Utilities.getDbConnection();
result = new ArrayList();


stmt = con.prepareStatement("INSERT INTO call_history " +
"(pis_cd,email,remarks) " +
" values(?,?,?)");

stmt.setString(1,pisCd);
stmt.setString(2,email);
stmt.setString(3,remarks);

stmt.executeUpdate();

con.commit();
log.info("Added a new message: " + pisCd +" by "+ pisCd);
//System.out.println("Added a new bank: " + bankDesc +" by "+ us.getName());
}

//error starts from here
catch (SQLException errSql){
con.rollback();
log.error("err: "+ errSql);
throw errSql;

}}
catch (Exception err){
if (con != null) con.rollback();
log.error("err: "+ err);
throw err;

}finally {

try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();

} catch (Exception err){
log.debug("cant send mail due to: "+err );
throw new Exception(" Please check smtp, admin email address. "+err);
}
}

}

error in stmt,con,rs

plz help me

1.) Please use code tags when posting code
2.) What errors are you getting?

[hirak1984]

It seems that u have errors regarding database connection and not in mailing program1
can u explain the exact errors u got?

public void sendMail(String smtpServer,String to,String from,String subject,String body ) throws Exception{


try{
SendMail.send(smtpServer,to,from,subject,body);

log.info("Mail delivered to: " +to);
System.out.print("Mail Delivered !!!"+to);


try{
Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
List result=null;
Map resultMap = null;
con = Utilities.getDbConnection();
result = new ArrayList();


stmt = con.prepareStatement("INSERT INTO call_history " +
"(pis_cd,email,remarks) " +
" values(?,?,?)");

stmt.setString(1,pisCd);
stmt.setString(2,email);
stmt.setString(3,remarks);

stmt.executeUpdate();

con.commit();
log.info("Added a new message: " + pisCd +" by "+ pisCd);
//System.out.println("Added a new bank: " + bankDesc +" by "+ us.getName());
}

//error starts from here
catch (SQLException errSql){
con.rollback();
log.error("err: "+ errSql);
throw errSql;

}}
catch (Exception err){
if (con != null) con.rollback();
log.error("err: "+ err);
throw err;

}finally {

try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (con != null) con.close();

} catch (Exception err){
log.debug("cant send mail due to: "+err );
throw new Exception(" Please check smtp, admin email address. "+err);
}
}

}

error in stmt,con,rs

plz help me