Author: cmueller
Date: Sun Jun  3 19:00:47 2012
New Revision: 1345743

URL: http://svn.apache.org/viewvc?rev=1345743&view=rev
Log:
CAMEL-4734: Consolidate the database vendors in our unit tests

Modified:
    camel/trunk/examples/camel-example-etl/pom.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/persistence.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/spring/camel-context.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/persistence.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/spring/camel-context.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/persistence.xml
    
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/spring/camel-context.xml

Modified: camel/trunk/examples/camel-example-etl/pom.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/pom.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- camel/trunk/examples/camel-example-etl/pom.xml (original)
+++ camel/trunk/examples/camel-example-etl/pom.xml Sun Jun  3 19:00:47 2012
@@ -58,6 +58,10 @@
       <groupId>org.springframework</groupId>
       <artifactId>spring-aop</artifactId>
     </dependency>
+    <dependency>
+      <groupId>org.apache.geronimo.specs</groupId>
+      <artifactId>geronimo-jpa_2.0_spec</artifactId>
+    </dependency>
 
     <!-- lets use log4j -->
     <dependency>
@@ -70,8 +74,8 @@
     </dependency>
 
     <dependency>
-      <groupId>org.hsqldb</groupId>
-      <artifactId>hsqldb</artifactId>
+      <groupId>org.apache.derby</groupId>
+      <artifactId>derby</artifactId>
     </dependency>
     <dependency>
       <groupId>org.apache.geronimo.specs</groupId>
@@ -151,9 +155,7 @@
       <id>hibernate</id>
       <properties>
         <camel.osgi.import.additional>
-          org.hsqldb,
-          org.hsqldb.util,
-          org.hsqldb.jdbc,
+          org.apache.derby.*,
           org.hibernate.ejb
         </camel.osgi.import.additional>
       </properties>
@@ -229,9 +231,7 @@
       </build>
       <properties>
         <camel.osgi.import.additional>
-          org.hsqldb,
-          org.hsqldb.util,
-          org.hsqldb.jdbc
+          org.apache.derby.*
         </camel.osgi.import.additional>
       </properties>
       <dependencies>
@@ -258,46 +258,20 @@
       </build>
       <properties>
         <camel.osgi.import.additional>
-          org.hsqldb,
-          org.hsqldb.util,
-          org.hsqldb.jdbc
+          org.apache.derby.*
         </camel.osgi.import.additional>
       </properties>
       <dependencies>
         <dependency>
           <groupId>org.eclipse.persistence</groupId>
-          <artifactId>javax.persistence</artifactId>
-          <version>1.2.0</version>
-        </dependency>
-        <dependency>
-          <groupId>org.eclipse.persistence</groupId>
-          <artifactId>org.eclipse.persistence.antlr</artifactId>
-          <version>1.2.0</version>
-        </dependency>
-        <dependency>
-          <groupId>org.eclipse.persistence</groupId>
-          <artifactId>org.eclipse.persistence.asm</artifactId>
-          <version>1.2.0</version>
-        </dependency>
-        <dependency>
-          <groupId>org.eclipse.persistence</groupId>
-          <artifactId>org.eclipse.persistence.core</artifactId>
-          <version>1.2.0</version>
-        </dependency>
-        <dependency>
-          <groupId>org.eclipse.persistence</groupId>
-          <artifactId>org.eclipse.persistence.jpa</artifactId>
-          <version>1.2.0</version>
-        </dependency>
-        <dependency>
-          <groupId>org.hsqldb</groupId>
-          <artifactId>hsqldb</artifactId>
+          <artifactId>eclipselink</artifactId>
+          <version>2.3.2</version>
         </dependency>
       </dependencies>
       <repositories>
         <repository>
           <id>Eclipse</id>
-          <url>http://eclipse.ialto.org/rt/eclipselink/maven.repo</url>
+          
<url>http://www.eclipse.org/downloads/download.php?r=1&amp;nf=1&amp;file=/rt/eclipselink/maven.repo</url>
         </repository>
       </repositories>
     </profile>

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/persistence.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/persistence.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/persistence.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/persistence.xml
 Sun Jun  3 19:00:47 2012
@@ -17,10 +17,10 @@
                <class>org.apache.camel.example.etl.CustomerEntity</class>
 
                <properties>
-                       <property name="javax.persistence.jdbc.driver" 
value="org.hsqldb.jdbcDriver" />
+                       <property name="javax.persistence.jdbc.driver" 
value="org.apache.derby.jdbc.EmbeddedDriver" />
+                       <property name="javax.persistence.jdbc.url" 
value="jdbc:derby:target/derby;create=true" />
                        <property name="javax.persistence.jdbc.user" value="sa" 
/>
                        <property name="javax.persistence.jdbc.password" 
value="" />
-                       <property name="javax.persistence.jdbc.url" 
value="jdbc:hsqldb:mem:camel_etl" />
             <!-- property name="eclipselink.logging.file" 
value="target/camel-example-etl.log" />
                        <property name="eclipselink.logging.level" value="FINE" 
/-->
                        <property name="eclipselink.ddl-generation" 
value="drop-and-create-tables" />

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/spring/camel-context.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/spring/camel-context.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/spring/camel-context.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/eclipselink/META-INF/spring/camel-context.xml
 Sun Jun  3 19:00:47 2012
@@ -15,12 +15,11 @@
                License.
        -->
 <beans xmlns="http://www.springframework.org/schema/beans";
-       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xmlns:camel="http://camel.apache.org/schema/spring";
+       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
+    xmlns:camel="http://camel.apache.org/schema/spring";
        xsi:schemaLocation="
-       http://www.springframework.org/schema/beans
-       http://www.springframework.org/schema/beans/spring-beans.xsd
-       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
+       http://camel.apache.org/schema/spring 
http://camel.apache.org/schema/spring/camel-spring.xsd";>
 
        <camel:camelContext id="camel" trace="true" 
xmlns="http://camel.apache.org/schema/spring";>
                <camel:package>org.apache.camel.example.etl</camel:package>
@@ -31,8 +30,7 @@
                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
        </bean>
 
-       <bean id="transactionTemplate"
-               
class="org.springframework.transaction.support.TransactionTemplate">
+       <bean id="transactionTemplate" 
class="org.springframework.transaction.support.TransactionTemplate">
                <property name="transactionManager">
                        <bean 
class="org.springframework.orm.jpa.JpaTransactionManager">
                                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
@@ -44,32 +42,13 @@
                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
        </bean>
 
-       <bean id="entityManagerFactory"
-               
class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
+       <bean id="entityManagerFactory" 
class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
                <property name="persistenceUnitName" value="camel" />
                <property name="jpaVendorAdapter" ref="jpaAdapter" />
        </bean>
 
-       <!-- EclipseLink addapter -->
        <bean id="jpaAdapter" 
class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter">
-               <property name="databasePlatform" 
value="org.eclipse.persistence.platform.database.HSQLPlatform" />
-               <property name="database" value="HSQL" />
+               <property name="databasePlatform" 
value="org.eclipse.persistence.platform.database.DerbyPlatform" />
+               <property name="database" value="DERBY" />
        </bean>
-
-
-    <!-- This bean will cause OSGi server exit, so we disable it here -->
-       <!-- lets show a simple UI to browse the database
-       <bean id="databaseExplorer" 
class="org.apache.camel.spring.util.MainRunner"
-               lazy-init="false">
-               <property name="main" 
value="org.hsqldb.util.DatabaseManagerSwing" />
-               <property name="args">
-                       <list>
-                               <value>url</value>
-                               <value>jdbc:hsqldb:mem:camel_etl</value>
-                       </list>
-               </property>
-               <property name="delay" value="3000" />
-       </bean>
-    -->
-
 </beans>
\ No newline at end of file

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/persistence.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/persistence.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/persistence.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/persistence.xml
 Sun Jun  3 19:00:47 2012
@@ -16,11 +16,11 @@
        <persistence-unit name="camel" transaction-type="RESOURCE_LOCAL">
                <class>org.apache.camel.example.etl.CustomerEntity</class>
                
-               <!-- Hibernate -->
                <properties>
-                       <property name="hibernate.dialect" 
value="org.hibernate.dialect.HSQLDialect"/>
+                       <property name="hibernate.dialect" 
value="org.hibernate.dialect.DerbyDialect"/>
+                       <property name="hibernate.connection.driver_class" 
value="org.apache.derby.jdbc.EmbeddedDriver"/>
+                       <property name="hibernate.connection.url" 
value="jdbc:derby:target/derby;create=true"/>
                        <property name="hibernate.hbm2ddl.auto" value="create"/>
                </properties>
-
        </persistence-unit>
 </persistence>

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/spring/camel-context.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/spring/camel-context.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/spring/camel-context.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/hibernate/META-INF/spring/camel-context.xml
 Sun Jun  3 19:00:47 2012
@@ -24,14 +24,15 @@
  -->
 
 <beans xmlns="http://www.springframework.org/schema/beans";
+       xmlns:camel="http://camel.apache.org/schema/spring";
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
        xsi:schemaLocation="
-       http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans.xsd
-       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
+         http://camel.apache.org/schema/spring 
http://camel.apache.org/schema/spring/camel-spring.xsd";>
 
-  <camelContext id="camel" xmlns="http://camel.apache.org/schema/spring";>
-    <package>org.apache.camel.example.etl</package>
-  </camelContext>
+  <camel:camelContext id="camel" trace="true">
+    <camel:package>org.apache.camel.example.etl</camel:package>
+  </camel:camelContext>
 
    <!--  Added for OSGI platform to allow -->
   <bean id="jpa" class="org.apache.camel.component.jpa.JpaComponent">
@@ -53,34 +54,9 @@
    <bean id="entityManagerFactory" 
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
     <property name="persistenceUnitName" value="camel"/>
     <property name="jpaVendorAdapter" ref="jpaAdapter"/>
-    <property name="dataSource" ref="dataSource" />
   </bean>
   
-  <bean id="jpaAdapter"
-        class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
-        <property name="databasePlatform" 
value="org.hibernate.dialect.HSQLDialect" />
+  <bean id="jpaAdapter" 
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
+        <property name="databasePlatform" 
value="org.hibernate.dialect.DerbyDialect" />
   </bean>
-  
-  <!--  DataSource Definition -->
-  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 
destroy-method="close">
-        <property name="driverClassName" value="org.hsqldb.jdbcDriver" />
-        <property name="url" value="jdbc:hsqldb:mem:camel_etl" />
-        <property name="username" value="sa" />
-        <property name="password" value="" />
-  </bean>
-
-  <!-- lets show a simple UI to browse the database, url should be - -url 
without the space -->
-  <!-- This bean will cause OSGi server exit, so we disable it here -->
-  <!--
-  <bean id="databaseExplorer" class="org.apache.camel.spring.util.MainRunner" 
lazy-init="false">
-    <property name="main" value="org.hsqldb.util.DatabaseManagerSwing"/>
-    <property name="args">
-      <list>
-        <value>- -url</value>
-        <value>jdbc:hsqldb:mem:camel_etl</value>
-      </list>
-    </property>
-    <property name="delay" value="1000"/>
-  </bean>
-  -->
-</beans>
+</beans>
\ No newline at end of file

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/persistence.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/persistence.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/persistence.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/persistence.xml
 Sun Jun  3 19:00:47 2012
@@ -16,36 +16,12 @@
        <persistence-unit name="camel" transaction-type="RESOURCE_LOCAL">
                <class>org.apache.camel.example.etl.CustomerEntity</class>
 
-               <!-- Hibernate properties 
-               <properties>
-                       <property name="hibernate.dialect" 
value="org.hibernate.dialect.HSQLDialect" />
-                       <property name="hibernate.hbm2ddl.auto" value="create" 
/>
-               </properties>
-        -->
-
-               <!--  OpenJPA & HSQL -->
-               <properties>
-                       <property name="openjpa.ConnectionDriverName" 
value="org.hsqldb.jdbcDriver" />
-                       <property name="openjpa.ConnectionURL" 
value="jdbc:hsqldb:mem:camel_etl" />
-                       <property name="openjpa.ConnectionUserName" value="sa" 
/>
-                       <property name="openjpa.ConnectionPassword" value="" />
-                       <property name="openjpa.jdbc.SynchronizeMappings" 
value="buildSchema" />
-                       <property name="openjpa.Log" value="commons" />
-                               <!--  value="DefaultLevel=INFO, Runtime=TRACE, 
Tool=INFO, SQL=TRACE" /> -->
-                       <property name="openjpa.ConnectionFactoryProperties" 
value="PrettyPrint=true, PrettyPrintLineLength=72" />
-               </properties>
-
-               <!-- OpenJPA & Derby 
                <properties>
                        <property name="openjpa.ConnectionURL" 
value="jdbc:derby:target/derby;create=true" />
                        <property name="openjpa.ConnectionDriverName" 
value="org.apache.derby.jdbc.EmbeddedDriver" />
                        <property name="openjpa.jdbc.SynchronizeMappings" 
value="buildSchema" />
-                       <property name="openjpa.Log"
-                               value="DefaultLevel=INFO, Runtime=TRACE, 
Tool=INFO, SQL=TRACE" />
+                       <property name="openjpa.Log" value="DefaultLevel=INFO, 
Runtime=TRACE, Tool=INFO, SQL=TRACE" />
                        <property name="openjpa.ConnectionFactoryProperties" 
value="PrettyPrint=true, PrettyPrintLineLength=72" />
                </properties>
-        -->
-
-
        </persistence-unit>
 </persistence>

Modified: 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/spring/camel-context.xml
URL: 
http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/spring/camel-context.xml?rev=1345743&r1=1345742&r2=1345743&view=diff
==============================================================================
--- 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/spring/camel-context.xml
 (original)
+++ 
camel/trunk/examples/camel-example-etl/src/profiles/openjpa/META-INF/spring/camel-context.xml
 Sun Jun  3 19:00:47 2012
@@ -22,8 +22,7 @@
        http://camel.apache.org/schema/spring
        http://camel.apache.org/schema/spring/camel-spring.xsd";>
 
-       <camel:camelContext id="camel" trace="true"
-               xmlns="http://camel.apache.org/schema/spring";>
+       <camel:camelContext id="camel" trace="true" 
xmlns="http://camel.apache.org/schema/spring";>
                <camel:package>org.apache.camel.example.etl</camel:package>
        </camel:camelContext>
 
@@ -32,8 +31,7 @@
                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
        </bean>
 
-       <bean id="transactionTemplate"
-               
class="org.springframework.transaction.support.TransactionTemplate">
+       <bean id="transactionTemplate" 
class="org.springframework.transaction.support.TransactionTemplate">
                <property name="transactionManager">
                        <bean 
class="org.springframework.orm.jpa.JpaTransactionManager">
                                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
@@ -45,39 +43,13 @@
                <property name="entityManagerFactory" 
ref="entityManagerFactory" />
        </bean>
 
-       <bean id="entityManagerFactory"
-               
class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
+       <bean id="entityManagerFactory" 
class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
                <property name="persistenceUnitName" value="camel" />
                <property name="jpaVendorAdapter" ref="jpaAdapter" />
        </bean>
 
-       <!--
-               Hibernate addapter <bean id="jpaAdapter"
-               
class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
-               <property name="databasePlatform"
-               value="org.hibernate.dialect.HSQLDialect" /> </bean>
-       -->
-
-       <!-- OpenJPA addapter -->
        <bean id="jpaAdapter" 
class="org.springframework.orm.jpa.vendor.OpenJpaVendorAdapter">
-               <property name="databasePlatform" 
value="org.apache.openjpa.jdbc.sql.HSQLDictionary" />
-               <property name="database" value="HSQL" />
-       </bean>
-
-
-    <!-- This bean will cause OSGi server exit, so we disable it here -->
-       <!-- lets show a simple UI to browse the database -->
-    <!--
-       <bean id="databaseExplorer" 
class="org.apache.camel.spring.util.MainRunner"
-               lazy-init="false">
-               <property name="main" 
value="org.hsqldb.util.DatabaseManagerSwing" />
-               <property name="args">
-                       <list>
-                               <value>- -url</value>
-                               <value>jdbc:hsqldb:mem:camel_etl</value>
-                       </list>
-               </property>
-               <property name="delay" value="3000" />
+               <property name="databasePlatform" 
value="org.apache.openjpa.jdbc.sql.DerbyDictionary" />
+               <property name="database" value="DERBY" />
        </bean>
-    -->
 </beans>
\ No newline at end of file


Reply via email to