/** * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.apache.camel.processor.idempotent.jdbc; import java.util.List; import javax.sql.DataSource; import org.apache.camel.EndpointInject; import org.apache.camel.component.mock.MockEndpoint; import org.apache.camel.test.spring.CamelSpringTestSupport; import org.junit.Before; import org.junit.Test; import org.springframework.context.support.AbstractApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; public class CustomizedJdbcMessageIdRepositoryTest extends CamelSpringTestSupport { protected static final String SELECT_ALL_STRING = "SELECT messageId FROM CUSTOMIZED_MESSAGE_REPOSITORY WHERE processorName = ?"; protected static final String PROCESSOR_NAME = "myProcessorName"; protected JdbcTemplate jdbcTemplate; protected DataSource dataSource; @EndpointInject(uri = "mock:result") protected MockEndpoint resultEndpoint; @EndpointInject(uri = "mock:error") protected MockEndpoint errorEndpoint; @Override @Before public void setUp() throws Exception { super.setUp(); dataSource = context.getRegistry().lookupByNameAndType("dataSource", DataSource.class); jdbcTemplate = new JdbcTemplate(dataSource); jdbcTemplate.afterPropertiesSet(); } @Test public void testDuplicateMessagesAreFilteredOut() throws Exception { resultEndpoint.expectedBodiesReceived("one", "two", "three"); errorEndpoint.expectedMessageCount(0); template.sendBodyAndHeader("direct:start", "one", "messageId", "1"); template.sendBodyAndHeader("direct:start", "two", "messageId", "2"); template.sendBodyAndHeader("direct:start", "one", "messageId", "1"); template.sendBodyAndHeader("direct:start", "two", "messageId", "2"); template.sendBodyAndHeader("direct:start", "one", "messageId", "1"); template.sendBodyAndHeader("direct:start", "three", "messageId", "3"); assertMockEndpointsSatisfied(); // all 3 messages should be in jdbc repo List<String> receivedMessageIds = jdbcTemplate.queryForList(SELECT_ALL_STRING, String.class, PROCESSOR_NAME); assertEquals(3, receivedMessageIds.size()); assertTrue(receivedMessageIds.contains("1")); assertTrue(receivedMessageIds.contains("2")); assertTrue(receivedMessageIds.contains("3")); } @Override protected AbstractApplicationContext createApplicationContext() { return new ClassPathXmlApplicationContext("org/apache/camel/processor/idempotent/jdbc/customized-spring.xml"); } }