Author: davsclaus
Date: Fri Jan 18 10:29:02 2013
New Revision: 1435070
URL: http://svn.apache.org/viewvc?rev=1435070&view=rev
Log:
New example for using SQL component
Modified:
camel/trunk/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java
camel/trunk/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml
camel/trunk/examples/camel-example-sql/src/main/resources/features.xml
Modified:
camel/trunk/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java
URL:
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java?rev=1435070&r1=1435069&r2=1435070&view=diff
==============================================================================
---
camel/trunk/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java
(original)
+++
camel/trunk/examples/camel-example-sql/src/main/java/org/apache/camel/example/sql/DatabaseBean.java
Fri Jan 18 10:29:02 2013
@@ -51,8 +51,24 @@ public class DatabaseBean {
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
+ }
+ }
}
Modified:
camel/trunk/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml
URL:
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml?rev=1435070&r1=1435069&r2=1435070&view=diff
==============================================================================
---
camel/trunk/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml
(original)
+++
camel/trunk/examples/camel-example-sql/src/main/resources/META-INF/spring/camel-context.xml
Fri Jan 18 10:29:02 2013
@@ -29,8 +29,9 @@
<property name="password" value=""/>
</bean>
- <!-- bean which creates the database table for this example -->
- <bean id="initDatabase" class="org.apache.camel.example.sql.DatabaseBean"
init-method="create">
+ <!-- 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>
Modified: camel/trunk/examples/camel-example-sql/src/main/resources/features.xml
URL:
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-sql/src/main/resources/features.xml?rev=1435070&r1=1435069&r2=1435070&view=diff
==============================================================================
--- camel/trunk/examples/camel-example-sql/src/main/resources/features.xml
(original)
+++ camel/trunk/examples/camel-example-sql/src/main/resources/features.xml Fri
Jan 18 10:29:02 2013
@@ -23,7 +23,8 @@
<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:commons-dbcp/commons-dbcp/${commons-dbcp-bundle-version}</bundle>
+
<bundle>mvn:mvn:commons-pool/commons-pool/${commons-pool-version}</bundle>
+
<bundle>mvn:mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.commons-dbcp/${commons-dbcp-bundle-version}</bundle>
<bundle>mvn:org.apache.camel/camel-example-sql/${project.version}</bundle>
</feature>
