Author: stliu Date: 2010-09-01 23:08:59 -0400 (Wed, 01 Sep 2010) New Revision: 20305 Modified: core/branches/Branch_3_3_2_GA_CP/parent/pom.xml Log: JBPAPP-4999 update db profiles Modified: core/branches/Branch_3_3_2_GA_CP/parent/pom.xml =================================================================== --- core/branches/Branch_3_3_2_GA_CP/parent/pom.xml 2010-09-01 20:05:34 UTC (rev 20304) +++ core/branches/Branch_3_3_2_GA_CP/parent/pom.xml 2010-09-02 03:08:59 UTC (rev 20305) @@ -483,7 +483,7 @@ <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> - <version>5.1.12</version> + <version>5.1.13</version> <scope>test</scope> </dependency> </dependencies> @@ -504,9 +504,8 @@ <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> - <version>8.2-510</version> + <version>8.4-701.jdbc4</version> <scope>test</scope> - <classifier>jdbc4</classifier> </dependency> </dependencies> <properties> @@ -518,7 +517,25 @@ <jdbc.isolation/> </properties> </profile> - + <profile> + <id>postgresql82-jdbc3</id> + <dependencies> + <dependency> + <groupId>postgresql</groupId> + <artifactId>postgresql</artifactId> + <version>8.4-701.jdbc3</version> + <scope>test</scope> + </dependency> + </dependencies> + <properties> + <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 8.3.7 test envionment --> <profile> <id>postgresql83</id> @@ -526,9 +543,8 @@ <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> - <version>8.3-605</version> + <version>8.4-701.jdbc4</version> <scope>test</scope> - <classifier>jdbc4</classifier> </dependency> </dependencies> <properties> @@ -540,6 +556,25 @@ <jdbc.isolation/> </properties> </profile> + <profile> + <id>postgresql83-jdbc3</id> + <dependencies> + <dependency> + <groupId>postgresql</groupId> + <artifactId>postgresql</artifactId> + <version>8.4-701.jdbc3</version> + <scope>test</scope> + </dependency> + </dependencies> + <properties> + <db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect> + <jdbc.driver>org.postgresql.Driver</jdbc.driver> + <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> <!-- ################################################################### @@ -554,7 +589,7 @@ <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc4</artifactId> - <version>3.58.82</version> + <version>4.9.78</version> </dependency> <dependency> <groupId>com.ibm</groupId> @@ -572,47 +607,50 @@ <jdbc.isolation /> </properties> </profile> - - <!-- The DB2 9.x test envionment (using 9x drivers)--> <profile> - <id>db2-91</id> + <id>db2-97-jdbc3</id> <dependencies> <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc</artifactId> - <version>3.1.57</version> + <version>3.59.81</version> </dependency> <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc_license_cu</artifactId> - <version>3.1.57</version> + <version>3.57.86</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.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 --> + <!-- The DB2 9.x test envionment (using 9x drivers)--> <profile> - <id>oracle9i</id> + <id>db2-91</id> <dependencies> <dependency> - <groupId>com.oracle</groupId> - <artifactId>ojdbc14</artifactId> - <!-- use the 10g drivers which are surprisingly largely bug free --> - <version>10.0.2.0</version> + <groupId>com.ibm</groupId> + <artifactId>db2jcc</artifactId> + <version>3.8.70</version> </dependency> + <dependency> + <groupId>com.ibm</groupId> + <artifactId>db2jcc_license_cu</artifactId> + <version>3.1.57</version> + </dependency> </dependencies> <properties> - <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> + <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>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> <jdbc.isolation /> @@ -640,25 +678,6 @@ </properties> </profile> <!-- The Oracle11g test envionment --> - <!-- <profile> - <id>oracle11g</id> - <dependencies> - <dependency> - <groupId>com.oracle</groupId> - <artifactId>ojdbc6</artifactId> - <version>11.2.0.1.0</version> - <scope>test</scope> - </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> --> <profile> <id>oracle11g</id> <dependencies> @@ -680,25 +699,6 @@ </profile> <!-- The Oracle11gRAC test envionment --> - <!-- <profile> - <id>oracle11gRAC</id> - <dependencies> - <dependency> - <groupId>com.oracle</groupId> - <artifactId>ojdbc6</artifactId> - <version>11.2.0.1.0</version> - <scope>test</scope> - </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> --> <profile> <id>oracle11gRAC</id> <dependencies> @@ -718,61 +718,59 @@ <jdbc.isolation/> </properties> </profile> - <!-- The Sybase 15 test envionment --> + + <!-- The Sybase 15(JDBC4) test envionment --> <profile> <id>sybase15</id> <dependencies> <dependency> <groupId>com.sybase</groupId> <artifactId>jconnect</artifactId> - <version>6.0.5_26564</version> + <version>7.0.0_26502</version> </dependency> </dependencies> <properties> <db.dialect>org.hibernate.dialect.SybaseASE15Dialect</db.dialect> - <jdbc.driver>com.sybase.jdbc3.jdbc.SybDriver</jdbc.driver> + <jdbc.driver>com.sybase.jdbc4.jdbc.SybDriver</jdbc.driver> <jdbc.url>jdbc:sybase:Tds:dev77.qa.atl2.redhat.com:5000/hibbr330?DYNAMIC_PREPARE=true</jdbc.url> <jdbc.user>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> <jdbc.isolation /> </properties> </profile> - - <!-- The SQLServer2005 (MS JDBC) test envionment --> <profile> - <id>mssql2005</id> + <id>sybase155</id> <dependencies> <dependency> - <groupId>com.microsoft.sqlserver</groupId> - <artifactId>msjdbc</artifactId> - <version>2.0.1008.2</version> - <classifier>4</classifier> + <groupId>com.sybase</groupId> + <artifactId>jconnect</artifactId> + <version>7.0.0_26502</version> + <scope>test</scope> </dependency> </dependencies> <properties> - <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> + <db.dialect>org.hibernate.dialect.SybaseASE15Dialect</db.dialect> + <jdbc.driver>com.sybase.jdbc4.jdbc.SybDriver</jdbc.driver> + <jdbc.url>jdbc:sybase:Tds:vmg09.mw.lab.eng.bos.redhat.com:5000/hibbr330?DYNAMIC_PREPARE=true</jdbc.url> <jdbc.user>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> - <jdbc.isolation>4096</jdbc.isolation> + <jdbc.isolation /> </properties> </profile> - - <!-- The SQLServer2005 (MS JDBC) test envionment --> + <!-- The SQLServer2008 (JDBC4) test envionment --> <profile> <id>mssql2008</id> <dependencies> <dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>msjdbc</artifactId> - <version>2.0.1008.2</version> + <version>3.0.1301.101</version> <classifier>4</classifier> <scope>test</scope> </dependency> </dependencies> <properties> - <db.dialect>org.hibernate.dialect.SQLServerDialect</db.dialect> + <db.dialect>org.hibernate.dialect.SQLServer2008Dialect</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> @@ -780,46 +778,28 @@ <jdbc.isolation>4096</jdbc.isolation> </properties> </profile> - <!-- The Oracle11g test envionment for jdk1.5 --> + + <!-- The SQLServer2005 (JDBC4) test envionment --> <profile> - <id>oracle11g-jdbc3</id> + <id>mssql2005</id> <dependencies> <dependency> - <groupId>com.oracle</groupId> - <artifactId>ojdbc14</artifactId> - <version>10.2.0.4</version> - <scope>test</scope> + <groupId>com.microsoft.sqlserver</groupId> + <artifactId>msjdbc</artifactId> + <version>3.0.1301.101</version> + <classifier>4</classifier> </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> + <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>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> - <jdbc.isolation/> + <jdbc.isolation>4096</jdbc.isolation> </properties> </profile> - <!-- The Oracle11gRAC test envionment for jdk1.5--> - <profile> - <id>oracle11gRAC-jdbc3</id> - <dependencies> - <dependency> - <groupId>com.oracle</groupId> - <artifactId>ojdbc14</artifactId> - <version>10.2.0.4</version> - <scope>test</scope> - </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 SQLServer2005 (MS JDBC) test envionment for jdk1.5 --> <profile> <id>mssql2005-jdbc3</id> @@ -827,7 +807,7 @@ <dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>msjdbc</artifactId> - <version>1.1</version> + <version>2.0.1008.2</version> </dependency> </dependencies> <properties>