CAMEL-11294 Remove camel-example-sql It no longer works as camel-spring-dm has been removed, and we have a camel-example-sql-blueprint instead
Project: http://git-wip-us.apache.org/repos/asf/camel/repo Commit: http://git-wip-us.apache.org/repos/asf/camel/commit/d3a7c8c5 Tree: http://git-wip-us.apache.org/repos/asf/camel/tree/d3a7c8c5 Diff: http://git-wip-us.apache.org/repos/asf/camel/diff/d3a7c8c5 Branch: refs/heads/master Commit: d3a7c8c56e7a9485b48b07ce20c573eec64f43da Parents: c56f12e Author: Tomohisa Igarashi <tm.igara...@gmail.com> Authored: Sun Sep 24 21:51:33 2017 -0400 Committer: Tomohisa Igarashi <tm.igara...@gmail.com> Committed: Sun Sep 24 23:38:15 2017 -0400 ---------------------------------------------------------------------- examples/README.adoc | 2 - examples/camel-example-sql/README.md | 61 ------ examples/camel-example-sql/pom.xml | 97 --------- .../apache/camel/example/sql/DatabaseBean.java | 74 ------- .../org/apache/camel/example/sql/OrderBean.java | 52 ----- .../src/main/resources/META-INF/LICENSE.txt | 203 ------------------- .../src/main/resources/META-INF/NOTICE.txt | 11 - .../resources/META-INF/spring/camel-context.xml | 78 ------- .../src/main/resources/features.xml | 33 --- .../src/main/resources/log4j2.properties | 23 --- .../src/main/resources/sql.properties | 29 --- examples/pom.xml | 1 - 12 files changed, 664 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/README.adoc ---------------------------------------------------------------------- diff --git a/examples/README.adoc b/examples/README.adoc index c92e181..06b57db 100644 --- a/examples/README.adoc +++ b/examples/README.adoc @@ -86,8 +86,6 @@ Number of Examples: 98 (8 deprecated) | link:camel-example-spring-boot-rest-jpa/README.md[Spring Boot REST JPA] (camel-example-spring-boot-rest-jpa) | Database | An example demonstrating how to use Camel REST DSL with JPA to expose a RESTful API that performs CRUD operations on a database -| link:camel-example-sql/README.md[SQL] (camel-example-sql) | Database | An example for showing Camel using SQL component - | link:camel-example-aggregate/README.md[Aggregate] (camel-example-aggregate) | EIP | Demonstrates the persistent support for the Camel aggregator | link:camel-example-cafe/README.md[Cafe] (camel-example-cafe) | EIP | A cafe example showing how to work with Camel http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/README.md ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/README.md b/examples/camel-example-sql/README.md deleted file mode 100644 index e9a1b2b..0000000 --- a/examples/camel-example-sql/README.md +++ /dev/null @@ -1,61 +0,0 @@ -# Camel SQL Example - -### Introduction -This example shows how to exchange data using a shared database table. - -The example has two Camel routes. The first route insert new data into the table, -triggered by a timer to run every 5th second. - -The second route pickup the newly inserted rows from the table, -process the row(s), and mark the row(s) as processed when done; -to avoid picking up the same rows again. - -### Build - -You will need to compile this example first: - - mvn install - -### Run with maven - -To run the example type - - mvn camel:run - -To stop the example hit <kbd>ctrl</kbd>+<kbd>c</kbd> - -This example uses Spring to setup and configure the database, -as well the CamelContext. You can see this in the following file: -In the src/main/resources/META-INF/spring/camel-context.xml - -### Run with Karaf -You will need to install this example first to your local maven repository with: - - mvn install - -Then you can install this example from the shell using this example's `features.xml` -for easy provisioning: - - feature:repo-add camel ${project.version} - feature:install camel - feature:repo-add mvn:org.apache.camel.example/camel-example-sql/${version}/xml/features - feature:install camel-example-sql - -And you can see the application running by tailing the logs - - log:tail - -And you can use <kbd>ctrl</kbd>+<kbd>c</kbd> to stop tailing the log. - -### Forum, Help, etc - -If you hit an problems please let us know on the Camel Forums - <http://camel.apache.org/discussion-forums.html> - - -Please help us make Apache Camel better - we appreciate any feedback you may -have. Enjoy! - - - -The Camel riders! http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/pom.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/pom.xml b/examples/camel-example-sql/pom.xml deleted file mode 100644 index 1b797bd..0000000 --- a/examples/camel-example-sql/pom.xml +++ /dev/null @@ -1,97 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - - 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. - ---> -<project xmlns="http://maven.apache.org/POM/4.0.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; - xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd";> - - <modelVersion>4.0.0</modelVersion> - - <parent> - <groupId>org.apache.camel.example</groupId> - <artifactId>examples</artifactId> - <version>2.20.0-SNAPSHOT</version> - </parent> - - <artifactId>camel-example-sql</artifactId> - <packaging>jar</packaging> - <name>Camel :: Example :: SQL</name> - <description>An example for showing Camel using SQL component</description> - - <properties> - <category>Database</category> - <title>SQL</title> - - <camel.osgi.export.pkg>org.apache.camel.example.sql.*</camel.osgi.export.pkg> - <!-- dynamic import for the Derby JDBC driver --> - <camel.osgi.dynamic>*</camel.osgi.dynamic> - </properties> - - <dependencies> - - <!-- Camel --> - <dependency> - <groupId>org.apache.camel</groupId> - <artifactId>camel-spring</artifactId> - </dependency> - <dependency> - <groupId>org.apache.camel</groupId> - <artifactId>camel-sql</artifactId> - </dependency> - - <!-- jdbc --> - <dependency> - <groupId>org.apache.derby</groupId> - <artifactId>derby</artifactId> - </dependency> - <dependency> - <groupId>org.apache.commons</groupId> - <artifactId>commons-dbcp2</artifactId> - </dependency> - - <!-- logging --> - <dependency> - <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-api</artifactId> - <scope>runtime</scope> - </dependency> - <dependency> - <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-core</artifactId> - <scope>runtime</scope> - </dependency> - <dependency> - <groupId>org.apache.logging.log4j</groupId> - <artifactId>log4j-slf4j-impl</artifactId> - <scope>runtime</scope> - </dependency> - - </dependencies> - - <build> - <plugins> - <!-- Allows the routes to be run via 'mvn camel:run' --> - <plugin> - <groupId>org.apache.camel</groupId> - <artifactId>camel-maven-plugin</artifactId> - <version>${project.version}</version> - </plugin> - </plugins> - </build> - -</project> http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java b/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java deleted file mode 100644 index abab97f..0000000 --- a/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java +++ /dev/null @@ -1,74 +0,0 @@ -/** - * 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.example.sql; - -import javax.sql.DataSource; - -import org.slf4j.Logger; -import org.slf4j.LoggerFactory; -import org.springframework.jdbc.core.JdbcTemplate; - -/** - * Bean that creates the database table - */ -public class DatabaseBean { - - private static final Logger LOG = LoggerFactory.getLogger(DatabaseBean.class); - private DataSource dataSource; - - public DataSource getDataSource() { - return dataSource; - } - - public void setDataSource(DataSource dataSource) { - this.dataSource = dataSource; - } - - public void create() throws Exception { - JdbcTemplate jdbc = new JdbcTemplate(dataSource); - - String sql = "create table orders (\n" - + " id integer primary key,\n" - + " item varchar(10),\n" - + " amount varchar(5),\n" - + " description varchar(30),\n" - + " processed boolean\n" - + ")"; - - LOG.info("Creating table orders ..."); - - try { - jdbc.execute("drop table orders"); - } catch (Throwable e) { - // ignore - } - - jdbc.execute(sql); - - LOG.info("... created table orders"); - } - - public void destroy() throws Exception { - JdbcTemplate jdbc = new JdbcTemplate(dataSource); - - try { - jdbc.execute("drop table orders"); - } catch (Throwable e) { - // ignore - } - } -} http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/OrderBean.java ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/OrderBean.java b/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/OrderBean.java deleted file mode 100644 index acd7015..0000000 --- a/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/OrderBean.java +++ /dev/null @@ -1,52 +0,0 @@ -/** - * 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.example.sql; - -import java.util.HashMap; -import java.util.Map; -import java.util.Random; - -/** - * Bean that generates and process orders. - */ -public class OrderBean { - - private int counter; - private Random ran = new Random(); - - /** - * Generates a new order structured as a {@link Map} - */ - public Map<String, Object> generateOrder() { - Map<String, Object> answer = new HashMap<String, Object>(); - answer.put("id", counter++); - answer.put("item", counter % 2 == 0 ? 111 : 222); - answer.put("amount", ran.nextInt(10) + 1); - answer.put("description", counter % 2 == 0 ? "Camel in Action" : "ActiveMQ in Action"); - return answer; - } - - /** - * Processes the order - * - * @param data the order as a {@link Map} - * @return the transformed order - */ - public String processOrder(Map<String, Object> data) { - return "Processed order id " + data.get("id") + " item " + data.get("item") + " of " + data.get("amount") + " copies of " + data.get("description"); - } -} http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/META-INF/LICENSE.txt ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/META-INF/LICENSE.txt b/examples/camel-example-sql/src/main/resources/META-INF/LICENSE.txt deleted file mode 100755 index 6b0b127..0000000 --- a/examples/camel-example-sql/src/main/resources/META-INF/LICENSE.txt +++ /dev/null @@ -1,203 +0,0 @@ - - Apache License - Version 2.0, January 2004 - http://www.apache.org/licenses/ - - TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION - - 1. Definitions. - - "License" shall mean the terms and conditions for use, reproduction, - and distribution as defined by Sections 1 through 9 of this document. - - "Licensor" shall mean the copyright owner or entity authorized by - the copyright owner that is granting the License. - - "Legal Entity" shall mean the union of the acting entity and all - other entities that control, are controlled by, or are under common - control with that entity. For the purposes of this definition, - "control" means (i) the power, direct or indirect, to cause the - direction or management of such entity, whether by contract or - otherwise, or (ii) ownership of fifty percent (50%) or more of the - outstanding shares, or (iii) beneficial ownership of such entity. - - "You" (or "Your") shall mean an individual or Legal Entity - exercising permissions granted by this License. - - "Source" form shall mean the preferred form for making modifications, - including but not limited to software source code, documentation - source, and configuration files. - - "Object" form shall mean any form resulting from mechanical - transformation or translation of a Source form, including but - not limited to compiled object code, generated documentation, - and conversions to other media types. - - "Work" shall mean the work of authorship, whether in Source or - Object form, made available under the License, as indicated by a - copyright notice that is included in or attached to the work - (an example is provided in the Appendix below). - - "Derivative Works" shall mean any work, whether in Source or Object - form, that is based on (or derived from) the Work and for which the - editorial revisions, annotations, elaborations, or other modifications - represent, as a whole, an original work of authorship. For the purposes - of this License, Derivative Works shall not include works that remain - separable from, or merely link (or bind by name) to the interfaces of, - the Work and Derivative Works thereof. - - "Contribution" shall mean any work of authorship, including - the original version of the Work and any modifications or additions - to that Work or Derivative Works thereof, that is intentionally - submitted to Licensor for inclusion in the Work by the copyright owner - or by an individual or Legal Entity authorized to submit on behalf of - the copyright owner. For the purposes of this definition, "submitted" - means any form of electronic, verbal, or written communication sent - to the Licensor or its representatives, including but not limited to - communication on electronic mailing lists, source code control systems, - and issue tracking systems that are managed by, or on behalf of, the - Licensor for the purpose of discussing and improving the Work, but - excluding communication that is conspicuously marked or otherwise - designated in writing by the copyright owner as "Not a Contribution." - - "Contributor" shall mean Licensor and any individual or Legal Entity - on behalf of whom a Contribution has been received by Licensor and - subsequently incorporated within the Work. - - 2. Grant of Copyright License. Subject to the terms and conditions of - this License, each Contributor hereby grants to You a perpetual, - worldwide, non-exclusive, no-charge, royalty-free, irrevocable - copyright license to reproduce, prepare Derivative Works of, - publicly display, publicly perform, sublicense, and distribute the - Work and such Derivative Works in Source or Object form. - - 3. Grant of Patent License. Subject to the terms and conditions of - this License, each Contributor hereby grants to You a perpetual, - worldwide, non-exclusive, no-charge, royalty-free, irrevocable - (except as stated in this section) patent license to make, have made, - use, offer to sell, sell, import, and otherwise transfer the Work, - where such license applies only to those patent claims licensable - by such Contributor that are necessarily infringed by their - Contribution(s) alone or by combination of their Contribution(s) - with the Work to which such Contribution(s) was submitted. If You - institute patent litigation against any entity (including a - cross-claim or counterclaim in a lawsuit) alleging that the Work - or a Contribution incorporated within the Work constitutes direct - or contributory patent infringement, then any patent licenses - granted to You under this License for that Work shall terminate - as of the date such litigation is filed. - - 4. Redistribution. You may reproduce and distribute copies of the - Work or Derivative Works thereof in any medium, with or without - modifications, and in Source or Object form, provided that You - meet the following conditions: - - (a) You must give any other recipients of the Work or - Derivative Works a copy of this License; and - - (b) You must cause any modified files to carry prominent notices - stating that You changed the files; and - - (c) You must retain, in the Source form of any Derivative Works - that You distribute, all copyright, patent, trademark, and - attribution notices from the Source form of the Work, - excluding those notices that do not pertain to any part of - the Derivative Works; and - - (d) If the Work includes a "NOTICE" text file as part of its - distribution, then any Derivative Works that You distribute must - include a readable copy of the attribution notices contained - within such NOTICE file, excluding those notices that do not - pertain to any part of the Derivative Works, in at least one - of the following places: within a NOTICE text file distributed - as part of the Derivative Works; within the Source form or - documentation, if provided along with the Derivative Works; or, - within a display generated by the Derivative Works, if and - wherever such third-party notices normally appear. The contents - of the NOTICE file are for informational purposes only and - do not modify the License. You may add Your own attribution - notices within Derivative Works that You distribute, alongside - or as an addendum to the NOTICE text from the Work, provided - that such additional attribution notices cannot be construed - as modifying the License. - - You may add Your own copyright statement to Your modifications and - may provide additional or different license terms and conditions - for use, reproduction, or distribution of Your modifications, or - for any such Derivative Works as a whole, provided Your use, - reproduction, and distribution of the Work otherwise complies with - the conditions stated in this License. - - 5. Submission of Contributions. Unless You explicitly state otherwise, - any Contribution intentionally submitted for inclusion in the Work - by You to the Licensor shall be under the terms and conditions of - this License, without any additional terms or conditions. - Notwithstanding the above, nothing herein shall supersede or modify - the terms of any separate license agreement you may have executed - with Licensor regarding such Contributions. - - 6. Trademarks. This License does not grant permission to use the trade - names, trademarks, service marks, or product names of the Licensor, - except as required for reasonable and customary use in describing the - origin of the Work and reproducing the content of the NOTICE file. - - 7. Disclaimer of Warranty. Unless required by applicable law or - agreed to in writing, Licensor provides the Work (and each - Contributor provides its Contributions) on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or - implied, including, without limitation, any warranties or conditions - of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A - PARTICULAR PURPOSE. You are solely responsible for determining the - appropriateness of using or redistributing the Work and assume any - risks associated with Your exercise of permissions under this License. - - 8. Limitation of Liability. In no event and under no legal theory, - whether in tort (including negligence), contract, or otherwise, - unless required by applicable law (such as deliberate and grossly - negligent acts) or agreed to in writing, shall any Contributor be - liable to You for damages, including any direct, indirect, special, - incidental, or consequential damages of any character arising as a - result of this License or out of the use or inability to use the - Work (including but not limited to damages for loss of goodwill, - work stoppage, computer failure or malfunction, or any and all - other commercial damages or losses), even if such Contributor - has been advised of the possibility of such damages. - - 9. Accepting Warranty or Additional Liability. While redistributing - the Work or Derivative Works thereof, You may choose to offer, - and charge a fee for, acceptance of support, warranty, indemnity, - or other liability obligations and/or rights consistent with this - License. However, in accepting such obligations, You may act only - on Your own behalf and on Your sole responsibility, not on behalf - of any other Contributor, and only if You agree to indemnify, - defend, and hold each Contributor harmless for any liability - incurred by, or claims asserted against, such Contributor by reason - of your accepting any such warranty or additional liability. - - END OF TERMS AND CONDITIONS - - APPENDIX: How to apply the Apache License to your work. - - To apply the Apache License to your work, attach the following - boilerplate notice, with the fields enclosed by brackets "[]" - replaced with your own identifying information. (Don't include - the brackets!) The text should be enclosed in the appropriate - comment syntax for the file format. We also recommend that a - file or class name and description of purpose be included on the - same "printed page" as the copyright notice for easier - identification within third-party archives. - - Copyright [yyyy] [name of copyright owner] - - Licensed 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. - http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/META-INF/NOTICE.txt ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/META-INF/NOTICE.txt b/examples/camel-example-sql/src/main/resources/META-INF/NOTICE.txt deleted file mode 100644 index 2e215bf..0000000 --- a/examples/camel-example-sql/src/main/resources/META-INF/NOTICE.txt +++ /dev/null @@ -1,11 +0,0 @@ - ========================================================================= - == NOTICE file corresponding to the section 4 d of == - == the Apache License, Version 2.0, == - == in this case for the Apache Camel distribution. == - ========================================================================= - - This product includes software developed by - The Apache Software Foundation (http://www.apache.org/). - - Please read the different LICENSE files present in the licenses directory of - this distribution. http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml b/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml deleted file mode 100644 index f78fd24..0000000 --- a/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml +++ /dev/null @@ -1,78 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - - 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. - ---> -<beans xmlns="http://www.springframework.org/schema/beans"; - xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; - xsi:schemaLocation=" - http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd - http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd";> - - <!-- START SNIPPET: e1 --> - <!-- this is the JDBC data source which uses an in-memory only Apache Derby database --> - <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close"> - <property name="driverClassName" value="org.apache.derby.jdbc.EmbeddedDriver"/> - <property name="url" value="jdbc:derby:memory:orders;create=true"/> - <property name="username" value=""/> - <property name="password" value=""/> - </bean> - - <!-- bean which creates/destroys the database table for this example --> - <bean id="initDatabase" class="org.apache.camel.example.sql.DatabaseBean" - init-method="create" destroy-method="destroy"> - <property name="dataSource" ref="dataSource"/> - </bean> - - <!-- configure the Camel SQL component to use the JDBC data source --> - <bean id="sql" class="org.apache.camel.component.sql.SqlComponent"> - <property name="dataSource" ref="dataSource"/> - </bean> - <!-- END SNIPPET: e1 --> - - <!-- START SNIPPET: e2 --> - <!-- order bean is our business logic bean that creates new orders --> - <bean id="orderBean" class="org.apache.camel.example.sql.OrderBean"/> - - <!-- here is Camel configured with a number of routes --> - <camelContext xmlns="http://camel.apache.org/schema/spring";> - - <!-- use Camel property placeholder loaded from the given file --> - <propertyPlaceholder id="placeholder" location="classpath:sql.properties"/> - - <!-- route that generate new orders and insert them in the database --> - <route id="generateOrder-route"> - <from uri="timer:foo?period=5s"/> - <transform> - <method ref="orderBean" method="generateOrder"/> - </transform> - <to uri="sql:{{sql.insertOrder}}"/> - <log message="Inserted new order ${body[id]}"/> - </route> - - <!-- route that process the orders by picking up new rows from the database - and when done processing then update the row to mark it as processed --> - <route id="processOrder-route"> - <from uri="sql:{{sql.selectOrder}}?onConsume={{sql.markOrder}}"/> - <to uri="bean:orderBean?method=processOrder"/> - <log message="${body}"/> - </route> - - </camelContext> - <!-- END SNIPPET: e2 --> - -</beans> http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/features.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/features.xml b/examples/camel-example-sql/src/main/resources/features.xml deleted file mode 100644 index 905ce8e..0000000 --- a/examples/camel-example-sql/src/main/resources/features.xml +++ /dev/null @@ -1,33 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - - 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. - ---> -<features> - <repository>mvn:org.apache.camel.karaf/apache-camel/${project.version}/xml/features</repository> - - <feature name="camel-example-sql" version="${project.version}"> - <feature version="${project.version}">camel</feature> - <feature version="${project.version}">camel-spring</feature> - <feature version="${project.version}">camel-sql</feature> - <bundle>mvn:org.apache.derby/derby/${derby-version}</bundle> - <bundle>mvn:org.apache.commons/commons-pool2/${commons-pool2-version}</bundle> - <bundle>wrap:mvn:org.apache.commons/commons-dbcp2/${commons-dbcp2-version}$overwrite=merge&DynamicImport-Package=*</bundle> - <bundle>mvn:org.apache.camel.example/camel-example-sql/${project.version}</bundle> - </feature> - -</features> http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/log4j2.properties ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/log4j2.properties b/examples/camel-example-sql/src/main/resources/log4j2.properties deleted file mode 100644 index d9f0508..0000000 --- a/examples/camel-example-sql/src/main/resources/log4j2.properties +++ /dev/null @@ -1,23 +0,0 @@ -## --------------------------------------------------------------------------- -## 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. -## --------------------------------------------------------------------------- - -appender.out.type = Console -appender.out.name = out -appender.out.layout.type = PatternLayout -appender.out.layout.pattern = [%30.30t] %-30.30c{1} %-5p %m%n -rootLogger.level = INFO -rootLogger.appenderRef.out.ref = out http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/camel-example-sql/src/main/resources/sql.properties ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql/src/main/resources/sql.properties b/examples/camel-example-sql/src/main/resources/sql.properties deleted file mode 100644 index 2390260..0000000 --- a/examples/camel-example-sql/src/main/resources/sql.properties +++ /dev/null @@ -1,29 +0,0 @@ -## --------------------------------------------------------------------------- -## 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. -## --------------------------------------------------------------------------- - -## START SNIPPET: e1 -## notice we use named parameters in the queries, eg :#name. A named query parameter must start with :# -## sql that insert new orders -sql.insertOrder=insert into orders (id, item, amount, description, processed) values (:#id, :#item, :#amount, :#description, false) - -## sql that select all unprocessed orders -sql.selectOrder=select * from orders where processed = false - -## sql that update the order as being processed -sql.markOrder=update orders set processed = true where id = :#id - -## END SNIPPET: e1 http://git-wip-us.apache.org/repos/asf/camel/blob/d3a7c8c5/examples/pom.xml ---------------------------------------------------------------------- diff --git a/examples/pom.xml b/examples/pom.xml index 114a65d..b673f54 100644 --- a/examples/pom.xml +++ b/examples/pom.xml @@ -116,7 +116,6 @@ <module>camel-example-spring-security</module> <module>camel-example-ssh</module> <module>camel-example-ssh-security</module> - <module>camel-example-sql</module> <module>camel-example-sql-blueprint</module> <module>camel-example-swagger-cdi</module> <module>camel-example-swagger-osgi</module>
