Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Send JasperReport to the Email ID which takes values from ResultSet

Sahar HassanMar 28 2012 — edited Apr 5 2012
My objective is to send jasper report to different email ids which takes values from database.
I have wrote the following code. However, it does not throw any error or exception and doesn't meet my objective.
Jdev 11.1.1.5.0 ADF BC.

public void dbConnect() throws Exception{
String dbUrl = "jdbc:oracle:thin:@localhost:1521:testdb";
String dbClass = "oracle.jdbc.driver.OracleDriver";
String query = "Select * FROM testJob";
Class.forName(dbClass);
Connection conn = DriverManager.getConnection(dbUrl,"sahar","sahar");
Statement statement = conn.createStatement();
ResultSet resultSet = statement.executeQuery(query);
String seqNo = null;
Map reportParameters = new HashMap();

Context env = (Context)new InitialContext().lookup("java:comp/env");
String reportPath = (String)env.lookup("reportPath");
String jrxmlFileName = reportPath+"testJob.jrxml";
String jasperFileName = reportPath+"testJob.jasper";
String pdfFileName = reportPath+"testJob.pdf";

while(resultSet.next()){

String branchId = resultSet.getString(1);
reportParameters.put("branchId", branchId);
JasperReport jasperReport = JasperCompileManager.compileReport(jrxmlFileName);
JasperPrint print = JasperFillManager.fillReport(jasperReport, reportParameters, conn);
JasperExportManager.exportReportToPdfFile(print,pdfFileName);
String subject = "Test with Attachment";
Properties props = new Properties();
props.put("mail.smtp.host", "10.0.0.237");
Session session = Session.getInstance(props, null);
MimeMessage message = new MimeMessage(session);
String toAddresses = resultSet.getString(4);
message.setFrom(new InternetAddress("saharhitc@hdfcsupport.co.in"));
message.addRecipients(Message.RecipientType.TO, toAddresses);
message.setSentDate(new Date());
message.setSubject(subject);
MimeBodyPart messageBodyPart = new MimeBodyPart();
messageBodyPart.setText("Hi");
Multipart multipart = new MimeMultipart();
multipart.addBodyPart(messageBodyPart);
messageBodyPart = new MimeBodyPart();
DataSource source = new FileDataSource(pdfFileName);
messageBodyPart.setDataHandler(new DataHandler(source));
messageBodyPart.setFileName(pdfFileName);
multipart.addBodyPart(messageBodyPart);
message.setContent(multipart);


}
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2012
Added on Mar 28 2012
0 comments
691 views