Repository: camel Updated Branches: refs/heads/master 9f299e914 -> ccc566d65
CAMEL-7332 Added camel-sql-blueprint example Project: http://git-wip-us.apache.org/repos/asf/camel/repo Commit: http://git-wip-us.apache.org/repos/asf/camel/commit/ccc566d6 Tree: http://git-wip-us.apache.org/repos/asf/camel/tree/ccc566d6 Diff: http://git-wip-us.apache.org/repos/asf/camel/diff/ccc566d6 Branch: refs/heads/master Commit: ccc566d657c8def9700bd658aa78e5ad7b0a0a86 Parents: d114c98 Author: Willem Jiang <[email protected]> Authored: Mon Mar 31 20:15:08 2014 +0800 Committer: Willem Jiang <[email protected]> Committed: Mon Mar 31 20:15:44 2014 +0800 ---------------------------------------------------------------------- examples/camel-example-sql-blueprint/README.txt | 68 +++++++ examples/camel-example-sql-blueprint/pom.xml | 88 ++++++++ .../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 + .../OSGI-INF/blueprint/camel-context.xml | 76 +++++++ .../src/main/resources/features.xml | 31 +++ .../src/main/resources/log4j.properties | 30 +++ .../src/main/resources/sql.properties | 29 +++ 10 files changed, 662 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/camel/blob/ccc566d6/examples/camel-example-sql-blueprint/README.txt ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/README.txt b/examples/camel-example-sql-blueprint/README.txt new file mode 100644 index 0000000..ff72a9b --- /dev/null +++ b/examples/camel-example-sql-blueprint/README.txt @@ -0,0 +1,68 @@ +Camel SQL Blueprint Example +================= + +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. + +Standalone +---------- +You will need to compile this example first: + mvn compile + +To run the example type + mvn camel:run + +To stop the example hit ctrl + c + +This example uses Blueprint to setup and configure the database, +as well the CamelContext. You can see this in the following file: +In the src/main/resources/OSGI-INF/blueprint/camel-context.xml + +Apache Karaf / ServiceMix +------------------------- +You will need to compile this example first: + mvn compile + +To install Apache Camel in Karaf you type in the shell (we use version ${project.version}): + + features:chooseurl camel ${project.version} + features:install camel + +First you need to install the following features in Karaf/ServiceMix with: + + features:install camel-blueprint + features:install camel-sql + +Then you need to install JDBC connection pool and the Derby Database: + + osgi:install -s mvn:commons-pool/commons-pool/1.6 + osgi:install -s mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/1.4_3 + osgi:install -s mvn:org.apache.derby/derby/10.10.1.1 + +Then you can install the Camel example: + + osgi:install -s mvn:org.apache.camel/camel-example-sql-blueprint/${project.version} + +And you can see the application running by tailing the logs + + log:tail + +And you can use ctrl + c to stop tailing the log. + +This example is documented at + http://camel.apache.org/sql-example-blueprint.html + +If you hit any problems please talk to us 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/ccc566d6/examples/camel-example-sql-blueprint/pom.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/pom.xml b/examples/camel-example-sql-blueprint/pom.xml new file mode 100644 index 0000000..f434f37 --- /dev/null +++ b/examples/camel-example-sql-blueprint/pom.xml @@ -0,0 +1,88 @@ +<?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</groupId> + <artifactId>examples</artifactId> + <version>2.14-SNAPSHOT</version> + </parent> + + <artifactId>camel-example-sql-blueprint</artifactId> + <packaging>bundle</packaging> + <name>Camel :: Example :: SQL :: Blueprint</name> + <description>An example for showing Camel using SQL component with blueprint</description> + + <properties> + <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-blueprint</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>commons-dbcp</groupId> + <artifactId>commons-dbcp</artifactId> + </dependency> + + <!-- logging --> + <dependency> + <groupId>org.slf4j</groupId> + <artifactId>slf4j-log4j12</artifactId> + </dependency> + <dependency> + <groupId>log4j</groupId> + <artifactId>log4j</artifactId> + </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> + <configuration> + <!-- Tell camel run plugin to load application from the blueprint file --> + <useBlueprint>true</useBlueprint> + </configuration> + </plugin> + </plugins> + </build> + +</project> http://git-wip-us.apache.org/repos/asf/camel/blob/ccc566d6/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/DatabaseBean.java ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/DatabaseBean.java b/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/DatabaseBean.java new file mode 100644 index 0000000..abab97f --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/DatabaseBean.java @@ -0,0 +1,74 @@ +/** + * 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/ccc566d6/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/OrderBean.java ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/OrderBean.java b/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/OrderBean.java new file mode 100644 index 0000000..f32b255 --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/java/org/apache/camel/example/sql/OrderBean.java @@ -0,0 +1,52 @@ +/** + * 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 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 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/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/META-INF/LICENSE.txt ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/META-INF/LICENSE.txt b/examples/camel-example-sql-blueprint/src/main/resources/META-INF/LICENSE.txt new file mode 100755 index 0000000..6b0b127 --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/META-INF/LICENSE.txt @@ -0,0 +1,203 @@ + + 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/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/META-INF/NOTICE.txt ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/META-INF/NOTICE.txt b/examples/camel-example-sql-blueprint/src/main/resources/META-INF/NOTICE.txt new file mode 100644 index 0000000..2e215bf --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/META-INF/NOTICE.txt @@ -0,0 +1,11 @@ + ========================================================================= + == 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/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/OSGI-INF/blueprint/camel-context.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/OSGI-INF/blueprint/camel-context.xml b/examples/camel-example-sql-blueprint/src/main/resources/OSGI-INF/blueprint/camel-context.xml new file mode 100644 index 0000000..39231f4 --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/OSGI-INF/blueprint/camel-context.xml @@ -0,0 +1,76 @@ +<?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. +--> +<blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0"; + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + xmlns:cm="http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.0.0"; + xmlns:camel="http://camel.apache.org/schema/blueprint"; + xsi:schemaLocation=" + http://www.osgi.org/xmlns/blueprint/v1.0.0 http://www.osgi.org/xmlns/blueprint/v1.0.0/blueprint.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.dbcp.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/blueprint";> + + <!-- 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}}?consumer.onConsume={{sql.markOrder}}"/> + <to uri="bean:orderBean?method=processOrder"/> + <log message="${body}"/> + </route> + + </camelContext> +</blueprint> http://git-wip-us.apache.org/repos/asf/camel/blob/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/features.xml ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/features.xml b/examples/camel-example-sql-blueprint/src/main/resources/features.xml new file mode 100644 index 0000000..e19231a --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/features.xml @@ -0,0 +1,31 @@ +<?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-blueprint</feature> + <feature version="${project.version}">camel-sql</feature> + <bundle>mvn:org.apache.derby/derby/${derby-version}</bundle> + <bundle>mvn:commons-pool/commons-pool/${commons-pool-version}</bundle> + <bundle>mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/${commons-dbcp-bundle-version}</bundle> + <bundle>mvn:org.apache.camel/camel-example-sql-blueprint/${project.version}</bundle> + </feature> + +</features> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/camel/blob/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/log4j.properties ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/log4j.properties b/examples/camel-example-sql-blueprint/src/main/resources/log4j.properties new file mode 100644 index 0000000..70c9b65 --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/log4j.properties @@ -0,0 +1,30 @@ +## ------------------------------------------------------------------------ +## 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. +## ------------------------------------------------------------------------ + +# +# The logging properties +# +log4j.rootLogger=INFO, out + +#log4j.logger.org.apache.camel.component.sql=DEBUG + +# CONSOLE appender not used by default +log4j.appender.out=org.apache.log4j.ConsoleAppender +log4j.appender.out.layout=org.apache.log4j.PatternLayout +log4j.appender.out.layout.ConversionPattern=[%30.30t] %-30.30c{1} %-5p %m%n +#log4j.appender.out.layout.ConversionPattern=%d [%-15.15t] %-5p %-30.30c{1} - %m%n + http://git-wip-us.apache.org/repos/asf/camel/blob/ccc566d6/examples/camel-example-sql-blueprint/src/main/resources/sql.properties ---------------------------------------------------------------------- diff --git a/examples/camel-example-sql-blueprint/src/main/resources/sql.properties b/examples/camel-example-sql-blueprint/src/main/resources/sql.properties new file mode 100644 index 0000000..b6f60d1 --- /dev/null +++ b/examples/camel-example-sql-blueprint/src/main/resources/sql.properties @@ -0,0 +1,29 @@ +## ------------------------------------------------------------------------ +## 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
