hinunbi

# 데이터베이스 서버 접속 정보
datasource.driver = com.mysql.jdbc.Driver
datasource.url = jdbc:mysql://192.168.1.50/mailer?zeroDateTimeBehavior=convertToNull
datasource.username = mailer
datasource.password = mailer

# 메일 서버 접속 정보
smtp.host.address = 192.168.1.65
smtp.user.name = mailer
smtp.user.password = mailer

hinunbi

<?xml version="1.0" encoding="euckr" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

	<properties resource="mailer.properties" />

	<environments default="default">
		<environment id="default">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">

hinunbi

<?xml version="1.0" encoding="euckr"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="mailer">

	<select id="selectEmail" resultType="hashmap" parameterType="map">
		SELECT
			MailID,

hinunbi

package camel.example.mailer;

import com.brm.pattern.configurer.Configurer;
import org.apache.camel.CamelContext;
import org.apache.camel.component.mail.MailComponent;
import org.apache.camel.component.mybatis.MyBatisComponent;
import org.apache.camel.component.properties.PropertiesComponent;

public class MailerConfigurer implements Configurer<CamelContext> {

hinunbi

package camel.example.mailer;

import java.util.HashMap;

import org.apache.camel.CamelContext;
import org.apache.camel.Exchange;
import org.apache.camel.Message;
import org.apache.camel.Processor;
import org.apache.camel.builder.RouteBuilder;

hinunbi

package camel.example.mailer;

import java.util.Map;

import org.apache.camel.Exchange;
import org.apache.camel.Message;
import org.apache.camel.Processor;

public class ToMailTranslator implements Processor {
	private final String MAIL_ID = "MailID";

hinunbi

package camel.example.mailer;

import java.util.HashMap;

import org.apache.camel.Exchange;
import org.apache.camel.Message;
import org.apache.camel.Processor;

public class ToMapTranslator implements Processor {

hinunbi

package camel.example.mailer;

import java.util.HashMap;

import org.apache.camel.ProducerTemplate;
import org.apache.camel.builder.RouteBuilder;
import org.apache.camel.impl.DefaultCamelContext;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

hinunbi

2013-07-05 10:16:46,032 [INFO ] [main] [Mailer] (Mailer.java:39) - Mailer start...
2013-07-05 10:16:46,032 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:1432) - Apache Camel 2.11.0 (CamelContext: camel-1) is starting
2013-07-05 10:16:46,110 [INFO ] [main] [ManagementStrategyFactory] (ManagementStrategyFactory.java:43) - JMX enabled.
2013-07-05 10:16:46,312 [INFO ] [main] [DefaultTypeConverter] (DefaultTypeConverter.java:45) - Loaded 176 type converters
2013-07-05 10:16:46,843 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:2098) - Route: route1 started and consuming from: Endpoint[direct://start]
2013-07-05 10:16:46,843 [INFO ] [main] [DefaultManagementLifecycleStrategy$TimerListenerManagerStartupListener] (DefaultManagementLifecycleStrategy.java:872) - Load performance statistics enabled.
2013-07-05 10:16:46,858 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:1467) - Total 1 routes, of which 1 is started.
2013-07-05 10:16:46,858 [INFO ] [main] [DefaultCamelConte

hinunbi

2013-07-05 10:12:19,842 [INFO ] [main] [Mailer] (Mailer.java:39) - Mailer start...
2013-07-05 10:12:19,852 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:1432) - Apache Camel 2.11.0 (CamelContext: camel-1) is starting
2013-07-05 10:12:19,932 [INFO ] [main] [ManagementStrategyFactory] (ManagementStrategyFactory.java:43) - JMX enabled.
2013-07-05 10:12:20,112 [INFO ] [main] [DefaultTypeConverter] (DefaultTypeConverter.java:45) - Loaded 176 type converters
2013-07-05 10:12:20,572 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:2098) - Route: route1 started and consuming from: Endpoint[direct://start]
2013-07-05 10:12:20,572 [INFO ] [main] [DefaultManagementLifecycleStrategy$TimerListenerManagerStartupListener] (DefaultManagementLifecycleStrategy.java:872) - Load performance statistics enabled.
2013-07-05 10:12:20,582 [INFO ] [main] [DefaultCamelContext] (DefaultCamelContext.java:1467) - Total 1 routes, of which 1 is started.
2013-07-05 10:12:20,582 [INFO ] [main] [DefaultCamelConte