001    /**
002     * Licensed to the Apache Software Foundation (ASF) under one or more
003     * contributor license agreements.  See the NOTICE file distributed with
004     * this work for additional information regarding copyright ownership.
005     * The ASF licenses this file to You under the Apache License, Version 2.0
006     * (the "License"); you may not use this file except in compliance with
007     * the License.  You may obtain a copy of the License at
008     *
009     *      http://www.apache.org/licenses/LICENSE-2.0
010     *
011     * Unless required by applicable law or agreed to in writing, software
012     * distributed under the License is distributed on an "AS IS" BASIS,
013     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
014     * See the License for the specific language governing permissions and
015     * limitations under the License.
016     */
017    package org.apache.camel.component.sql;
018    
019    import java.util.Map;
020    
021    import javax.sql.DataSource;
022    
023    import org.apache.camel.Component;
024    import org.apache.camel.Consumer;
025    import org.apache.camel.Processor;
026    import org.apache.camel.Producer;
027    import org.apache.camel.impl.DefaultEndpoint;
028    import org.apache.camel.util.IntrospectionSupport;
029    import org.springframework.jdbc.core.JdbcTemplate;
030    
031    /**
032     * SQL Endpoint. Endpoint URI should contain valid SQL statement, but instead of
033     * question marks (that are parameter placeholders), sharp signs should be used.
034     * This is because in camel question mark has other meaning.
035     */
036    public class SqlEndpoint extends DefaultEndpoint {
037        private JdbcTemplate jdbcTemplate;
038        private String query;
039    
040        public SqlEndpoint(String uri, String query, Component component, DataSource dataSource, Map parameters) throws Exception {
041            super(uri, component);
042            this.jdbcTemplate = new JdbcTemplate(dataSource);
043            IntrospectionSupport.setProperties(jdbcTemplate, parameters, "template.");
044            this.query = query;
045        }
046    
047        public SqlEndpoint(String endpointUri, JdbcTemplate jdbcTemplate, String query) {
048            super(endpointUri);
049            this.jdbcTemplate = jdbcTemplate;
050            this.query = query;
051        }
052        
053        public Consumer createConsumer(Processor processor) throws Exception {
054            throw new UnsupportedOperationException("Not implemented");
055        }
056    
057        public Producer createProducer() throws Exception {
058            return new SqlProducer(this, query, jdbcTemplate);
059        }
060    
061        public boolean isSingleton() {
062            return false;
063        }
064    
065    }