Bulk mailing with Bulk attachment

Hi i think - sending bulk mails with bulk attachments problem- is faced by every java programmer in real time projects, I got small solution from my friend, i thought this will be help full for some one who needs the solution for this problem.

please copy and paste the following java code in your mail handler action class,

Note: 1) Multiple Emails are taking with comma[,] seperated.
2) If attachments are more then also we can send mails -- Need to get attachment paths with comma[,] separated.
3) To work with the following code please import javax.mail.*, javax.mail.internet.*, javax.activation.DataHandler, javax.activation.FileDataSource packages.


Properties props = System.getProperties();
props.put("mail.host", host);
props.put("mail.transport.protocol", "smtp");
javax.mail.Session session = Session.getDefaultInstance(props, null);
session.setDebug(sessionDebug);


MimeMessage message = new MimeMessage(session);
message.setFrom(new InternetAddress(fromMailId));
InternetAddress[] address = {new InternetAddress(spiltEmail[i].trim())};
message.setRecipients(Message.RecipientType.TO, address);
message.setSubject(acknowledgementSubject);

message.setText(acknowledgementContent);
message.setSentDate(new Date());
Multipart multiPart = new MimeMultipart();

MimeBodyPart con = new MimeBodyPart();
con.setText(acknowledgementContent);
multiPart.addBodyPart(con);

// Take the below code for multiple attachments also
// Need to copy the same code and change the path to new attachment path

MimeBodyPart bodyPart = new MimeBodyPart();
FileDataSource fds = new FileDataSource(path);
bodyPart.setDataHandler(new DataHandler(fds));
bodyPart.setFileName(fds.getName());
//mbp.setText(acknowledgementContent);

multiPart.addBodyPart(bodyPart);
message.setContent(multiPart);

Transport.send(message); //to send the mail successfully

Maintaining database connection in Context.xml

Meta-inf folder -> context.xml

in this write the following code
--&lt-- ?xml version="1.0" encoding="UTF-8"? --&gt--
--&lt-- Context antiJARLocking="true" path="/search" --&gt--
--&lt-- !-- Default set of monitored resources -- --&gt--
--&lt-- WatchedResource --&gt-- WEB-INF/web.xml --&lt-- /WatchedResource --&gt--
--&lt-- !-- Uncomment this to disable session persistence across Tomcat restarts -- --&gt--
--&lt-- !--
--&lt-- Manager pathname="" / --&gt--
-- --&gt--
--&lt-- Resource auth="Container"
driverClassName="com.mysql.jdbc.Driver"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
logAbandoned="true" maxActive="30"
maxIdle="10"
maxWait="1000"
name="jdbc/POS"
removeAbandoned="true"
removeAbandonedTimeout="60"
type="javax.sql.DataSource"
url="jdbc:mysql://localhost:3306/POC?autoReconnect=true"
username="root"
password="kmipl"/ --&gt--
--&lt-- /Context --&gt--

Note : replace all --&lt-- with '<' --&gt-- with '>'


______________________________________________________________


to get the connection from context.xml file just use the following method

public Connection dbConnectionCheck()
{
try
{
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/POS");
connection = ds.getConnection();
}
catch(Exception e1)
{
System.out.println(e1);
}
return connection;

}

_______________________________________________________

by this we can change the database with out redeploying or rebuilding the war file.