[jbpm-commits] JBoss JBPM SVN: r3696 - in jbpm3/trunk: modules/db/scripts and 1 other directories.

Author: alex.guizar(a)jboss.com Date: 2009-01-21 11:10:57 -0500 (Wed, 21 Jan 2009) New Revision: 3696 Added: jbpm3/trunk/modules/db/src/main/resources/postgresql.properties Modified: jbpm3/trunk/hudson/profiles.xml.local.qa jbpm3/trunk/hudson/profiles.xml.redhat.qa jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml Log: JBPM-1369 uncomment postgresql properties in hudson profiles enable schema update run Modified: jbpm3/trunk/hudson/profiles.xml.local.qa =================================================================== --- jbpm3/trunk/hudson/profiles.xml.local.qa 2009-01-21 09:34:00 UTC (rev 3695) +++ jbpm3/trunk/hudson/profiles.xml.local.qa 2009-01-21 16:10:57 UTC (rev 3696) @@ -5,11 +5,13 @@ <!-- This profile can also be defined in ~/.m2/settings.xml --> <profile> <id>jboss-home-profile</id> + <activation> <property> <name>user.name</name> </property> </activation> + <properties> <jdbc.mysql.server>localhost</jdbc.mysql.server> @@ -28,14 +30,12 @@ <jdbc.sybase.driver>com.sybase.jdbc3.jdbc.SybDriver</jdbc.sybase.driver> <jdbc.sybase.datasource>com.sybase.jdbc3.jdbc.SybXADataSource</jdbc.sybase.datasource> - <!-- PostgreSQL is currently not supported <jdbc.postgresql.server>localhost</jdbc.postgresql.server> <jdbc.postgresql.port>5432</jdbc.postgresql.port> <jdbc.postgresql.database>jbpmtest</jdbc.postgresql.database> <jdbc.postgresql.url>jdbc:postgresql://${jdbc.postgresql.server}:${jdbc.postgresql.port}/${jdbc.postgresql.database}</jdbc.postgresql.url> <jdbc.postgresql.username>jbpmtest</jdbc.postgresql.username> <jdbc.postgresql.password></jdbc.postgresql.password> - --> </properties> </profile> Modified: jbpm3/trunk/hudson/profiles.xml.redhat.qa =================================================================== --- jbpm3/trunk/hudson/profiles.xml.redhat.qa 2009-01-21 09:34:00 UTC (rev 3695) +++ jbpm3/trunk/hudson/profiles.xml.redhat.qa 2009-01-21 16:10:57 UTC (rev 3696) @@ -5,37 +5,37 @@ <!-- This profile can also be defined in ~/.m2/settings.xml --> <profile> <id>jboss-home-profile</id> + <activation> <property> <name>user.name</name> </property> </activation> + <properties> - + <jdbc.mysql.url>jdbc:mysql://dev02.qa.atl2.redhat.com/jbpm3</jdbc.my... <jdbc.mysql.server>dev02.qa.atl2.redhat.com</jdbc.mysql.server> <jdbc.mysql.port>3306</jdbc.mysql.port> <jdbc.mysql.database>jbpmtest</jdbc.mysql.database> <jdbc.mysql.username>jbpm3</jdbc.mysql.username> <jdbc.mysql.password>jbpm3</jdbc.mysql.password> - + <jdbc.sybase.url>jdbc:jtds:sybase://dev77.qa.atl2.redhat.com:4100/jbpm3</jdbc.sybase.url> <jdbc.sybase.server>dev77.qa.atl2.redhat.com</jdbc.sybase.server> <jdbc.sybase.port>4100</jdbc.sybase.port> <jdbc.sybase.database>jbpm3</jdbc.sybase.database> <jdbc.sybase.username>jbpm3</jdbc.sybase.username> <jdbc.sybase.password>jbpm3</jdbc.sybase.password> - - <!-- PostgreSQL is currently not supported + <jdbc.postgresql.url>jdbc:postgresql://localhost:5432/jbpmtest</jdbc.postgresql.url> <jdbc.postgresql.server>localhost</jdbc.postgresql.server> <jdbc.postgresql.port>5432</jdbc.postgresql.port> <jdbc.postgresql.database>jbpmtest</jdbc.postgresql.database> <jdbc.postgresql.username>jbpmtest</jdbc.postgresql.username> <jdbc.postgresql.password></jdbc.postgresql.password> - --> </properties> </profile> - + </profiles> </profilesXml> Modified: jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml =================================================================== --- jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml 2009-01-21 09:34:00 UTC (rev 3695) +++ jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml 2009-01-21 16:10:57 UTC (rev 3696) @@ -48,6 +48,7 @@ <target name="update-schema" depends="setup-schema" description="Generate jBPM Database Update Scripts"> <jbpmschema output="${scriptsdir}/jbpm.jpdl.mysql.update322.sql" config="hibernate.cfg.mysql.xml" properties="mysql.properties" action="update" delimiter=";"/> + <jbpmschema output="${scriptsdir}/jbpm.jpdl.postgresql.update322.sql" config="hibernate.cfg.postgresql.xml" properties="postgresql.properties" action="update" delimiter=";"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.sybase.update322.sql" config="hibernate.cfg.sybase.xml" properties="sybase.properties" action="update" delimiter=";"/> </target> Added: jbpm3/trunk/modules/db/src/main/resources/postgresql.properties =================================================================== --- jbpm3/trunk/modules/db/src/main/resources/postgresql.properties (rev 0) +++ jbpm3/trunk/modules/db/src/main/resources/postgresql.properties 2009-01-21 16:10:57 UTC (rev 3696) @@ -0,0 +1,8 @@ +hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect +# +# This uses the jbpm322 database schema as reference for the SchemaUpdate task +# +hibernate.connection.driver_class=org.postgresql.Driver +hibernate.connection.url=jdbc\:postgresql\://${jdbc.postgresql.server}\:${jdbc.postgresql.port}/jbpm322 +hibernate.connection.username=${jdbc.postgresql.username} +hibernate.connection.password=${jdbc.postgresql.password}