Author: alex.guizar(a)jboss.com Date: 2009-06-24 02:53:24 -0400 (Wed, 24 Jun 2009) New Revision: 5101 Added: jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/db2.properties Modified: jbpm3/branches/jbpm-3.2-soa/modules/db/scripts/antrun-jbpmschema.xml jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/oracle.properties Log: JBPM-1357: Add QA for db2 (RESOLVED) Specify the connection properties for update Modified: jbpm3/branches/jbpm-3.2-soa/modules/db/scripts/antrun-jbpmschema.xml =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/db/scripts/antrun-jbpmschema.xml 2009-06-24 04:57:29 UTC (rev 5100) +++ jbpm3/branches/jbpm-3.2-soa/modules/db/scripts/antrun-jbpmschema.xml 2009-06-24 06:53:24 UTC (rev 5101) @@ -15,20 +15,15 @@ <!-- ================================================================== --> <target name="setup-schema"> - - <!-- echo message="${maven.runtime.classpath}"/ --> - <taskdef name="jbpmschema" classname="org.jbpm.ant.JbpmSchemaTask"> <classpath path="${maven.runtime.classpath}"/> </taskdef> <property name="scriptsdir" value="${basedir}/target/classes"/> <mkdir dir="${scriptsdir}"/> - </target> <target name="create-schema" depends="setup-schema" description="Generate jBPM Database Schemas"> - <jbpmschema output="${scriptsdir}/jbpm.jpdl.db2.sql" config="hibernate.cfg.db2.xml" action="create"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.derby.sql" config="hibernate.cfg.derby.xml" action="create"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.firebird.sql" config="hibernate.cfg.firebird.xml" action="create"/> @@ -42,21 +37,14 @@ <jbpmschema output="${scriptsdir}/jbpm.jpdl.postgresql.sql" config="hibernate.cfg.postgresql.xml" action="create" delimiter=";"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.sapdb.sql" config="hibernate.cfg.sapdb.xml" action="create"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.sybase.sql" config="hibernate.cfg.sybase.xml" action="create"/> - - <!--[JBPM-1813] Fix create schema generation --> - <!--jbpmschema output="${scriptsdir}/jbpm.jpdl.informix.sql" config="hibernate.cfg.informix.xml" action="create"/--> - <!--jbpmschema output="${scriptsdir}/jbpm.jpdl.pointbase.sql" config="hibernate.cfg.pointbase.xml" action="create"/--> - <!--jbpmschema output="${scriptsdir}/jbpm.jpdl.progress.sql" config="hibernate.cfg.progress.xml" action="create"/--> - </target> <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" /> + <jbpmschema output="${scriptsdir}/jbpm.jpdl.sybase.update322.sql" config="hibernate.cfg.sybase.xml" properties="sybase.properties" action="update"/> <jbpmschema output="${scriptsdir}/jbpm.jpdl.oracle.update322.sql" config="hibernate.cfg.oracle.xml" properties="oracle.properties" action="update" delimiter=";"/> - + <jbpmschema output="${scriptsdir}/jbpm.jpdl.db2.update322.sql" config="hibernate.cfg.db2.xml" properties="db2.properties" action="update"/> </target> </project> Added: jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/db2.properties =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/db2.properties (rev 0) +++ jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/db2.properties 2009-06-24 06:53:24 UTC (rev 5101) @@ -0,0 +1,8 @@ +hibernate.dialect=org.hibernate.dialect.DB2Dialect +# +# This uses the jbpm322 database schema as reference for the SchemaUpdate task +# +hibernate.connection.driver_class=com.ibm.db2.jcc.DB2Driver +hibernate.connection.url=${jdbc.db2.url} +hibernate.connection.username=jbpm322 +hibernate.connection.password=jbpm322 Modified: jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/oracle.properties =================================================================== --- jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/oracle.properties 2009-06-24 04:57:29 UTC (rev 5100) +++ jbpm3/branches/jbpm-3.2-soa/modules/db/src/main/resources/oracle.properties 2009-06-24 06:53:24 UTC (rev 5101) @@ -3,6 +3,6 @@ # This uses the jbpm322 database schema as reference for the SchemaUpdate task # hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver -hibernate.connection.url=jdbc:oracle:thin:@${jdbc.oracle.server}:${jdbc.oracle.port}:jbpm322 -hibernate.connection.username=${jdbc.oracle.username} -hibernate.connection.password=${jdbc.oracle.password} +hibernate.connection.url=${jdbc.oracle.url} +hibernate.connection.username=jbpm322 +hibernate.connection.password=jbpm322