You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jackrabbit.apache.org by ma...@apache.org on 2009/08/06 11:48:45 UTC

svn commit: r801582 - /jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml

Author: martijnh
Date: Thu Aug  6 09:48:44 2009
New Revision: 801582

URL: http://svn.apache.org/viewvc?rev=801582&view=rev
Log:
JCR-1456 Database connection pooling

* Added MSSQL configuration to profile.

Modified:
    jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml

Modified: jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml
URL: http://svn.apache.org/viewvc/jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml?rev=801582&r1=801581&r2=801582&view=diff
==============================================================================
--- jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml (original)
+++ jackrabbit/sandbox/JCR-1456/jackrabbit-core/pom.xml Thu Aug  6 09:48:44 2009
@@ -242,12 +242,19 @@
     </dependency>
   </dependencies>
 
+  <!--
+    These profiles can be used to run the (integration) tests against different DB backends.
+    For instance, if you want to run the integration tests against MySQL backend, do:
+    
+      mvn clean integration-test -Pmysql,use-descriptor-overlay
+    
+    Note: the ${config.db.name} database is dropped and re-created in the clean phase. 
+  -->
   <profiles>
     <profile>
-      <id>use-descriptor-overlay</id>
+      <id>mysql</id>
       <properties>
         <config.db.name>jackrabbit</config.db.name>
-        <!-- DB specific properties which are used for filtering -->
         <config.db.fsclass>org.apache.jackrabbit.core.fs.db.DbFileSystem</config.db.fsclass>
         <config.db.dsclass>org.apache.jackrabbit.core.data.db.DbDataStore</config.db.dsclass>
         <config.db.pmclass>org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager</config.db.pmclass>
@@ -257,11 +264,31 @@
         <config.db.pwd>pwd</config.db.pwd>
         <config.db.driver>com.mysql.jdbc.Driver</config.db.driver>
         <config.db.url>jdbc:mysql://localhost:3306/${config.db.name}?autoReconnect=true</config.db.url>
-        <!-- DB specific properties for the maven-sql plugin -->
         <config.db.metaurl>jdbc:mysql://localhost:3306/mysql?autoReconnect=true</config.db.metaurl>
         <config.db.dropcommand>drop database ${config.db.name}</config.db.dropcommand>
         <config.db.createcommand>create database ${config.db.name}</config.db.createcommand>
       </properties>
+    </profile>
+    <profile>
+      <id>mssql</id>
+      <properties>
+        <config.db.name>jackrabbit</config.db.name>
+        <config.db.fsclass>org.apache.jackrabbit.core.fs.db.MSSqlFileSystem</config.db.fsclass>
+        <config.db.dsclass>org.apache.jackrabbit.core.data.db.DbDataStore</config.db.dsclass>
+        <config.db.pmclass>org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager</config.db.pmclass>
+        <config.db.journalclass>org.apache.jackrabbit.core.journal.MSSqlDatabaseJournal</config.db.journalclass>
+        <config.db.schema>mssql</config.db.schema>
+        <config.db.user>user</config.db.user>
+        <config.db.pwd>$pwd</config.db.pwd>
+        <config.db.driver>net.sourceforge.jtds.jdbc.Driver</config.db.driver>
+        <config.db.url>jdbc:jtds:sqlserver://localhost:2433/${config.db.name}</config.db.url>
+        <config.db.metaurl>jdbc:jtds:sqlserver://localhost:2433/master</config.db.metaurl>
+        <config.db.dropcommand>drop database ${config.db.name}</config.db.dropcommand>
+        <config.db.createcommand>create database ${config.db.name}</config.db.createcommand>
+      </properties>
+    </profile>
+    <profile>
+      <id>use-descriptor-overlay</id>
       <build>
       <plugins>
         <!-- Drop/create the test database on clean -->        
@@ -276,6 +303,12 @@
               <type>jar</type>
               <scope>provided</scope>
             </dependency>
+            <dependency>
+              <groupId>net.sourceforge.jtds</groupId>
+              <artifactId>jtds</artifactId>
+              <version>1.2.2</version>
+              <scope>provided</scope>
+            </dependency>
           </dependencies>
           <configuration>
             <driver>${config.db.driver}</driver>
@@ -373,6 +406,12 @@
           <type>jar</type>
           <scope>test</scope>
         </dependency>
+        <dependency>
+          <groupId>net.sourceforge.jtds</groupId>
+          <artifactId>jtds</artifactId>
+          <version>1.2.2</version>
+          <scope>test</scope>
+        </dependency>
       </dependencies>
     </profile>
   </profiles>