[hibernate-commits] Hibernate SVN: r18132 - search/branches/v3_1_1_GA_CP.

Author: stliu Date: 2009-12-04 04:27:31 -0500 (Fri, 04 Dec 2009) New Revision: 18132 Modified: search/branches/v3_1_1_GA_CP/pom.xml Log: JBPAPP-3218 update db profile in hibernate eap 5 cp branch Modified: search/branches/v3_1_1_GA_CP/pom.xml =================================================================== --- search/branches/v3_1_1_GA_CP/pom.xml 2009-12-04 09:13:20 UTC (rev 18131) +++ search/branches/v3_1_1_GA_CP/pom.xml 2009-12-04 09:27:31 UTC (rev 18132) @@ -283,10 +283,7 @@ </snapshotRepository> </distributionManagement> - <profiles> - <!-- =============================== --> - <!-- Database profiles --> - <!-- =============================== --> + <profiles> <!-- HSQLDB is the default (eventually move to H2) --> <profile> <id>hsqldb</id> @@ -303,12 +300,33 @@ <properties> <db.dialect>org.hibernate.dialect.HSQLDialect</db.dialect> <jdbc.driver>org.hsqldb.jdbcDriver</jdbc.driver> - <jdbc.url>jdbc:hsqldb:.</jdbc.url> + <jdbc.url>jdbc:hsqldb:target/test/db/hsqldb/hibernate</jdbc.url> <jdbc.user>sa</jdbc.user> - <jdbc.pass/> - <jdbc.isolation/> + <jdbc.pass /> + <jdbc.isolation /> </properties> </profile> + + <!-- The H2 test envionment --> + <profile> + <id>h2</id> + <dependencies> + <dependency> + <groupId>org.h2database</groupId> + <artifactId>h2database</artifactId> + <version>1.0.20061217</version> + </dependency> + </dependencies> + <properties> + <db.dialect>org.hibernate.dialect.H2Dialect</db.dialect> + <jdbc.driver>org.h2.Driver</jdbc.driver> + <jdbc.url>jdbc:h2:mem:target/test/db/h2/hibernate</jdbc.url> + <jdbc.user>sa</jdbc.user> + <jdbc.pass /> + <jdbc.isolation /> + </properties> + </profile> + <!-- ################################################################### Profiles naming db instances in the Red Hat QA/QE lab @@ -317,7 +335,7 @@ ################################################################### --> - <!-- The MySQL 5 test envionment --> + <!-- The MySQL5 test envionment --> <profile> <id>mysql5</id> <dependencies> @@ -333,50 +351,10 @@ <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/> + <jdbc.isolation /> </properties> </profile> - <!-- The MySQL 5.1 test envionment --> - <profile> - <id>mysql51</id> - <dependencies> - <dependency> - <groupId>mysql</groupId> - <artifactId>mysql-connector-java</artifactId> - <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://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>mysql51-cluster</id> - <dependencies> - <dependency> - <groupId>mysql</groupId> - <artifactId>mysql-connector-java</artifactId> - <version>5.0.5</version> - </dependency> - </dependencies> - <properties> - <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> - <!-- The PostgreSQL 8.2.4 test envionment --> <profile> <id>postgresql824</id> @@ -384,8 +362,8 @@ <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> - <version>8.2-504</version> - <classifier>jdbc3</classifier> + <version>8.2-504.jdbc3</version> + <scope>test</scope> </dependency> </dependencies> <properties> @@ -405,8 +383,8 @@ <dependency> <groupId>postgresql</groupId> <artifactId>postgresql</artifactId> - <version>8.2-504</version> - <classifier>jdbc3</classifier> + <version>8.2-504.jdbc3</version> + <scope>test</scope> </dependency> </dependencies> <properties> @@ -425,44 +403,45 @@ ################################################################### --> - <!-- The DB2 8.x test envionment (using 9x drivers)--> + <!-- The DB2 9.7 test envionment (using 9x drivers)--> <profile> - <id>db2v82</id> + <id>db2v97</id> <dependencies> <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc</artifactId> - <version>3.1.57</version> + <version>3.57.86</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://dev32.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/> + <jdbc.isolation /> </properties> </profile> - <!-- The DB2 9.1 test envionment (using 9x drivers)--> + <!-- The DB2 9.x test envionment (using 9x drivers)--> <profile> <id>db2v91</id> <dependencies> <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc</artifactId> - <version>3.8.47</version> + <version>3.1.57</version> </dependency> <dependency> <groupId>com.ibm</groupId> <artifactId>db2jcc_license_cu</artifactId> - <version>3.8.47</version> + <version>3.1.57</version> </dependency> </dependencies> <properties> @@ -471,35 +450,10 @@ <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/> + <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.86</version> - </dependency> - <dependency> - <groupId>com.ibm</groupId> - <artifactId>db2jcc_license_cu</artifactId> - <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://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> @@ -517,7 +471,7 @@ <jdbc.url>jdbc:oracle:thin:@dev20.qa.atl.jboss.com:1521:qa</jdbc.url> <jdbc.user>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> - <jdbc.isolation/> + <jdbc.isolation /> </properties> </profile> @@ -535,53 +489,14 @@ <properties> <db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect> <jdbc.driver>oracle.jdbc.driver.OracleDriver</jdbc.driver> - <jdbc.url>jdbc:oracle:thin:@vmg05.mw.lab.eng.bos.redhat.com:1521:qaora10</jdbc.url> + <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/> + <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> @@ -595,10 +510,10 @@ <properties> <db.dialect>org.hibernate.dialect.SybaseASE15Dialect</db.dialect> <jdbc.driver>com.sybase.jdbc3.jdbc.SybDriver</jdbc.driver> - <jdbc.url>jdbc:sybase:Tds:vmg07.mw.lab.eng.bos.redhat.com:5000/hibbr330</jdbc.url> + <jdbc.url>jdbc:sybase:Tds:dev77.qa.atl2.redhat.com:5000/hibbr330</jdbc.url> <jdbc.user>hibbr330</jdbc.user> <jdbc.pass>hibbr330</jdbc.pass> - <jdbc.isolation/> + <jdbc.isolation /> </properties> </profile> @@ -622,25 +537,6 @@ </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 -->