[hibernate-commits] Hibernate SVN: r17776 - search/trunk.

Friday, 16 October 2009

Author: jcosta(a)redhat.com
Date: 2009-10-16 08:32:50 -0400 (Fri, 16 Oct 2009)
New Revision: 17776

Modified:
   search/trunk/pom.xml
Log:
HSEARCH-404 - Updated database profiles in pom.xml

Modified: search/trunk/pom.xml
===================================================================

--- search/trunk/pom.xml	2009-10-16 12:32:24 UTC (rev 17775)
+++ search/trunk/pom.xml	2009-10-16 12:32:50 UTC (rev 17776)
@@ -349,93 +349,98 @@
                 <jdbc.isolation/>
             </properties>
         </profile>
+        <!--
+            ###################################################################
+            Profiles naming db instances in the Red Hat QA/QE lab
+
+            First, those with OSS drivers
+            ###################################################################
+        -->
+
+        <!-- The MySQL 5 test envionment -->
         <profile>
-            <id>postgresql</id>
+            <id>mysql5</id>
             <dependencies>
                 <dependency>
-                    <groupId>postgresql</groupId>
-                    <artifactId>postgresql</artifactId>
-                    <version>8.3-603.jdbc3</version>
+                    <groupId>mysql</groupId>
+                    <artifactId>mysql-connector-java</artifactId>
+                    <version>5.0.5</version>
                 </dependency>
             </dependencies>
             <properties>
-               
<db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect>
-                <jdbc.driver>org.postgresql.Driver</jdbc.driver>
-               
<jdbc.url>jdbc:postgresql://localhost:5432/hibernate</jdbc.url>
-                <jdbc.user>hibernate</jdbc.user>
-                <jdbc.pass>hibernate</jdbc.pass>
+               
<db.dialect>org.hibernate.dialect.MySQL5InnoDBDialect</db.dialect>
+                <jdbc.driver>com.mysql.jdbc.Driver</jdbc.driver>
+               
<jdbc.url>jdbc:mysql://vmg08.mw.lab.eng.bos.redhat.com/hibbr330</jdb...
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
+
+        <!-- The MySQL 5.1 test envionment -->
         <profile>
-            <id>mysql</id>
+            <id>mysql51</id>
             <dependencies>
                 <dependency>
                     <groupId>mysql</groupId>
                     <artifactId>mysql-connector-java</artifactId>
-                    <version>5.1.6</version>
+                    <version>5.0.5</version>
                 </dependency>
             </dependencies>
             <properties>
                
<db.dialect>org.hibernate.dialect.MySQL5InnoDBDialect</db.dialect>
                 <jdbc.driver>com.mysql.jdbc.Driver</jdbc.driver>
-                <jdbc.url>jdbc:mysql://localhost/hibernate</jdbc.url>
-                <jdbc.user>hibernate</jdbc.user>
-                <jdbc.pass>hibernate</jdbc.pass>
+               
<jdbc.url>jdbc:mysql://vmg02.mw.lab.eng.bos.redhat.com/hibbr330</jdb...
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
+
+        <!-- The MySQL 5.1 Cluster test envionment -->
         <profile>
-            <id>sqlserver</id>
+            <id>mysql51-cluster</id>
             <dependencies>
                 <dependency>
-                    <groupId>net.sourceforge.jtds</groupId>
-                    <artifactId>jtds</artifactId>
-                    <version>1.2</version>
+                    <groupId>mysql</groupId>
+                    <artifactId>mysql-connector-java</artifactId>
+                    <version>5.0.5</version>
                 </dependency>
             </dependencies>
             <properties>
-               
<db.dialect>org.hibernate.dialect.SQLServerDialect</db.dialect>
-                <jdbc.driver>net.sourceforge.jtds.jdbc.Driver</jdbc.driver>
-               
<jdbc.url>jdbc:jtds:sqlserver://ec2-67-202-7-25.compute-1.amazonaws.com:1433;DatabaseName=hibernate
-                </jdbc.url>
-                <jdbc.user>hibernate</jdbc.user>
-                <jdbc.pass>hibernate</jdbc.pass>
+                <db.dialect>org.hibernate.dialect.MySQL5Dialect</db.dialect>
+                <jdbc.driver>com.mysql.jdbc.Driver</jdbc.driver>
+               
<jdbc.url>jdbc:mysql:loadbalance://dev61.qa.atl2.redhat.com:3306,dev62.qa.atl2.redhat.com:3306/hibbr330</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
 
-        <!--
-            ###################################################################
-            Profiles naming db instances in the Red Hat QA/QE lab
-
-            First, those with OSS drivers
-            ###################################################################
-        -->
-
-        <!-- The MySQL5 test envionment -->
+        <!-- The PostgreSQL 8.2.4 test envionment -->
         <profile>
-            <id>mysql5</id>
+            <id>postgresql824</id>
             <dependencies>
                 <dependency>
-                    <groupId>mysql</groupId>
-                    <artifactId>mysql-connector-java</artifactId>
-                    <version>5.0.5</version>
+                    <groupId>postgresql</groupId>
+                    <artifactId>postgresql</artifactId>
+                    <version>8.2-504</version>
+                    <classifier>jdbc3</classifier>
                 </dependency>
             </dependencies>
             <properties>
-               
<db.dialect>org.hibernate.dialect.MySQL5InnoDBDialect</db.dialect>
-                <jdbc.driver>com.mysql.jdbc.Driver</jdbc.driver>
-               
<jdbc.url>jdbc:mysql://dev02.qa.atl.jboss.com/hibbrtru</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+               
<db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect>
+                <jdbc.driver>org.postgresql.Driver</jdbc.driver>
+               
<jdbc.url>jdbc:postgresql://vmg01.mw.lab.eng.bos.redhat.com:5432:hibbr330</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
 
-        <!-- The PostgreSQL test envionment -->
+        <!-- The PostgreSQL 8.3.7 test envionment -->
         <profile>
-            <id>postgresql823</id>
+            <id>postgresql837</id>
             <dependencies>
                 <dependency>
                     <groupId>postgresql</groupId>
@@ -447,9 +452,9 @@
             <properties>
                
<db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect>
                 <jdbc.driver>org.postgresql.Driver</jdbc.driver>
-               
<jdbc.url>jdbc:postgresql://dev01.qa.atl.jboss.com:5432:hibbrtru</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+               
<jdbc.url>jdbc:postgresql://vmg03.mw.lab.eng.bos.redhat.com:5432:hibbr330</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
@@ -479,37 +484,62 @@
                 <db.dialect>org.hibernate.dialect.DB2Dialect</db.dialect>
                 <jdbc.driver>com.ibm.db2.jcc.DB2Driver</jdbc.driver>
                
<jdbc.url>jdbc:db2://dev32.qa.atl.jboss.com:50000/jbossqa</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
 
-        <!-- The DB2 9.x test envionment (using 9x drivers)-->
+        <!-- The DB2 9.1 test envionment (using 9x drivers)-->
         <profile>
             <id>db2v91</id>
             <dependencies>
                 <dependency>
                     <groupId>com.ibm</groupId>
                     <artifactId>db2jcc</artifactId>
-                    <version>3.1.57</version>
+                    <version>3.8.47</version>
                 </dependency>
                 <dependency>
                     <groupId>com.ibm</groupId>
                     <artifactId>db2jcc_license_cu</artifactId>
-                    <version>3.1.57</version>
+                    <version>3.8.47</version>
                 </dependency>
             </dependencies>
             <properties>
                 <db.dialect>org.hibernate.dialect.DB2Dialect</db.dialect>
                 <jdbc.driver>com.ibm.db2.jcc.DB2Driver</jdbc.driver>
                
<jdbc.url>jdbc:db2://dev67.qa.atl.jboss.com:50000/jbossqa</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
 
+        <!-- The DB2 9.7 test envionment (using 9x drivers)-->
+        <profile>
+            <id>db2v97</id>
+            <dependencies>
+                <dependency>
+                    <groupId>com.ibm</groupId>
+                    <artifactId>db2jcc</artifactId>
+                    <version>3.57.82</version>
+                </dependency>
+                <dependency>
+                    <groupId>com.ibm</groupId>
+                    <artifactId>db2jcc_license_cu</artifactId>
+                    <version>3.57.82</version>
+                </dependency>
+            </dependencies>
+            <properties>
+                <db.dialect>org.hibernate.dialect.DB2Dialect</db.dialect>
+                <jdbc.driver>com.ibm.db2.jcc.DB2Driver</jdbc.driver>
+               
<jdbc.url>jdbc:db2://vmg06.mw.lab.eng.bos.redhat.com:50000/jbossqa</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
+                <jdbc.isolation/>
+            </properties>
+        </profile>
+
         <!-- The Oracle9i test envionment -->
         <profile>
             <id>oracle9i</id>
@@ -525,8 +555,8 @@
                
<db.dialect>org.hibernate.dialect.Oracle9iDialect</db.dialect>
                 <jdbc.driver>oracle.jdbc.driver.OracleDriver</jdbc.driver>
                
<jdbc.url>jdbc:oracle:thin:@dev20.qa.atl.jboss.com:1521:qa</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
@@ -545,13 +575,53 @@
             <properties>
                
<db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect>
                 <jdbc.driver>oracle.jdbc.driver.OracleDriver</jdbc.driver>
-               
<jdbc.url>jdbc:oracle:thin:@dev01.qa.atl.jboss.com:1521:qadb01</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+               
<jdbc.url>jdbc:oracle:thin:@vmg05.mw.lab.eng.bos.redhat.com:1521:qaora10</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
 
+        <!-- The Oracle11g test envionment -->
+        <profile>
+            <id>oracle11g</id>
+            <dependencies>
+                <dependency>
+                    <groupId>com.oracle</groupId>
+                    <artifactId>ojdbc5</artifactId>
+                    <version>11.1.0.7.0</version>
+                </dependency>
+            </dependencies>
+            <properties>
+               
<db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect>
+                <jdbc.driver>oracle.jdbc.driver.OracleDriver</jdbc.driver>
+               
<jdbc.url>jdbc:oracle:thin:@dev04.qa.atl2.redhat.com:1521:qaora11</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
+                <jdbc.isolation/>
+            </properties>
+        </profile>
+
+        <!-- The Oracle11gRAC test envionment -->
+        <profile>
+            <id>oracle11gRAC</id>
+            <dependencies>
+                <dependency>
+                    <groupId>com.oracle</groupId>
+                    <artifactId>ojdbc5</artifactId>
+                    <version>11.1.0.7.0</version>
+                </dependency>
+            </dependencies>
+            <properties>
+               
<db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect>
+                <jdbc.driver>oracle.jdbc.driver.OracleDriver</jdbc.driver>
+               
<jdbc.url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=vmg24-vip.mw.lab.eng.bos.redhat.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=vmg25-vip.mw.lab.eng.bos.redhat.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=qarac.jboss)))</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
+                <jdbc.isolation/>
+            </properties>
+        </profile>
+
         <!-- The Sybase 15 test envionment -->
         <profile>
             <id>sybase15</id>
@@ -565,9 +635,9 @@
             <properties>
                
<db.dialect>org.hibernate.dialect.SybaseASE15Dialect</db.dialect>
                 <jdbc.driver>com.sybase.jdbc3.jdbc.SybDriver</jdbc.driver>
-               
<jdbc.url>jdbc:sybase:Tds:dev77.qa.atl2.redhat.com:5000/hibbrtru</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+               
<jdbc.url>jdbc:sybase:Tds:vmg07.mw.lab.eng.bos.redhat.com:5000/hibbr330</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation/>
             </properties>
         </profile>
@@ -586,12 +656,32 @@
                
<db.dialect>org.hibernate.dialect.SQLServerDialect</db.dialect>
                
<jdbc.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc.driver>
                
<jdbc.url>jdbc:sqlserver://dev30.qa.atl.jboss.com:3918</jdbc.url>
-                <jdbc.user>hibbrtru</jdbc.user>
-                <jdbc.pass>hibbrtru</jdbc.pass>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
                 <jdbc.isolation>4096</jdbc.isolation>
             </properties>
         </profile>
 
+        <!-- The SQLServer2005 (MS JDBC) test envionment -->
+        <profile>
+            <id>mssql2008</id>
+            <dependencies>
+                <dependency>
+                    <groupId>com.microsoft.sqlserver</groupId>
+                    <artifactId>msjdbc</artifactId>
+                    <version>1.1</version>
+                </dependency>
+            </dependencies>
+            <properties>
+               
<db.dialect>org.hibernate.dialect.SQLServerDialect</db.dialect>
+               
<jdbc.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc.driver>
+               
<jdbc.url>jdbc:sqlserver://vmg04.mw.lab.eng.bos.redhat.com:1433</jdbc.url>
+                <jdbc.user>hibbr330</jdbc.user>
+                <jdbc.pass>hibbr330</jdbc.pass>
+                <jdbc.isolation>4096</jdbc.isolation>
+            </properties>
+        </profile>
+
         <!-- ================================ -->
         <!-- Dependecy profiles to test w and -->
         <!-- w/o optional dependencies        -->


    

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[hibernate-commits] Hibernate SVN: r17776 - search/trunk.