12:40 p.m.
Marco Rietveld [http://community.jboss.org/people/marco.rietveld] modified the document:
"jBPM 5 (and Drools) database testing"
To view the document, visit: http://community.jboss.org/docs/DOC-17071
--------------------------------------------------------------
This article describes how to configure the jBPM project so that unit tests connect to a
database or your choice instead of using the default H2 (in-memory) database.
| * Overview of modifications (#overview)
* Explanation (#explanations)* The pom.xml and maven settings (#pomAndSettings)
* Filtering and the datasource.properties and persistence.xml files (#filtering)
* Using PersistenceUtil in unit tests (#persistenceUtil)
* Summary (#summary)
* Appendix (#appendix) |
h3. Overview of modifications
The jbpm project root pom.xml contains:
** Properties to be used to connect to the database of choice
** A database profile that can be used in order to inject a dependency for the jdbc driver
jar for the database
** An example profile, which has been commented out, which shows how do test without using
a settings file
2. A org.jbpm.persistence.util.PersistenceUtil class has been added to the
jbpm-persistence-jpa module.
3. The jbpm-persistence-jpa module now also has a test-jar goal: the test-jar produced
contains the PersistenceUtil class mentioned above.
4. In the modules in which persistence is used during testing, the following modifications
have been made:
* A datasource.properties file has been added to the src/test/resources directory.
* The pom.xml of the module has been modified so that filtering has been turned on for the
src/test/resources directory.
* The persistence.xml file in src/test/resources/META-INF has been modified so that the
hibernate.connection.* properties use variables.
How all of these modifications fit together is explained in the following section.
h3. Explanation
We essentially use maven to inject the values we want into the persistence configuration.
Unfortunately, because XA datasource configuration is not uniform across different
database vendors, there is also a utility class
(org.jbpm.persistence.util.PersistenceUtil) which contains database specific XA datasource
configuration and which we use to initiate and configure the XA datasource when testing.
An explanation follows the diagram below:
h5.
http://community.jboss.org/servlet/JiveServlet/showImage/102-17071-9-1676...
http://community.jboss.org/servlet/JiveServlet/downloadImage/102-17071-9-...
h5. A. The pom.xml and maven settings:
Properties
The jbpm project root pom (jbpm artifact) contains a number of maven.* properties: a
number of these settings are empty, and those that aren't are set to the h2 defaults.
However, we can create a local settings.xml file and run the following:
mvn clean test -ssettings-db.xml -Pdatabase
(The -Pdatabase is explained below)
By filling a local settings.xml file with the jdbc values that we want for, for example,
our local PostgreSQL database, we can then use those values later on when running our
tests.
Otherwise, we can also directly modify the pom.xml itself and fill the values in there.
Using a profile to inject a dependency
The -Pdatabase option in the mvn command above tells maven to use the profile that has an
id of "database".
In the project root pom, we have also defined a "database" profile that uses a
dependency. By setting the maven.jdbc.driver.jar property (in either the pom.xml or the
settings.xml file that you use) to the path of the appropriate jdbc driver class jar, we
can then ensure that the database specific driver classes are available to our tests.
[Depending on demand, we could also add properties to the pom.xml so that the groupId,
artifactId, and version of the driver class jar (instead of a system path) are defined and
used]
h5. B. Filtering and the datasource.properties and persistence.xml files:
In the pom.xml of the module in which the testing is done (for example,
jbpm-persistence-jpa or jbpm-bam), the following has also been added to the <build>
section of the module pom:
<build>
...
<testResources>
<testResource>
<directory>src/test/resources</directory>
<filtering>true</filtering>
</testResource>
</testResources>
...
</build>
When maven runs the process-test-resources goal, it +filters+ all files in and under the
src/main/resources directory. Any properties that have been defined in the (effective)
pom.xml being processed by maven, will be replaced with the values that have been assigned
to them.
In this case, the following two files in src/main/resources that are filtered for us:
* datasource.properties
* META-INF/persistence.xml
In the PersistenceUtil class, we read in the datasource.properties file. The test-compile
and process-test-resources goals ensure that the filtered version of this file -- where
all maven variables have been replaced with their assigned values -- is placed in the same
class path as the rest of the test classes and jars (target/, namely).
hibernate.xml is used by Hibernate/JPA when we instantiate an EntityManager.
h5. C. Using the PersistenceUtil in unit tests:
Lastly, when we write any unit tests that use persistence, instead of configuring the
datasource and entityManager ourselves, we use the static methods made available to us
from the PersistenceUtil class.
In our test class, we can use something like the following code:
import static org.jbpm.persistence.util.PersistenceUtil.*;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
...
import org.junit.After;
import org.junit.Before;
import bitronix.tm.TransactionManagerServices;
import bitronix.tm.resource.jdbc.PoolingDataSource;
public class MyPersistenceTest {
private PoolingDataSource ds1;
private EntityManagerFactory emf;
@Before
public void setUp() throws Exception {
ds1 = setupPoolingDataSource();
ds1.init();
emf = Persistence.createEntityManagerFactory( PERSISTENCE_UNIT_NAME );
}
@After
public void tearDown() throws Exception {
emf.close();
ds1.close();
}
setupPoolingDataSource() is a static method from the PersistenceUtil Class.
This method does the following:
1. It retrieves the properties stored in datasource.properties
2. It initializes a PoolingDataSource object.
3. Depending on the driver class that's been specified, other properties are injected
into the PoolingDataSource instance. * Depending on the database specific
PoolingDataSource implementations, different properties are necessary to initiate the XA
datasoruce.
h3. Summary
In order to run the unit tests on a different database, you can do one of two things:
If you want to run all of the tests with a specific database, the easiest way to do this
is the following:
1. Download the appropriate jdbc driver class jar for your database.
2. Fill a settings file with the appropriate values (including the path to your jdbc
driver class jar)
3. Run mvn -Pdatabase -ssettings.xml clean test !
Otherwise, if you are developing or debugging unit tests and running them with a specific
database, do the following:
1. Ensue that the appropriate jdbc driver classes are available by doing one of the
following: * Download the appropriate jdbc driver class jar for your database and use the
path to that jar.
* Modify the dependency in the database profile that it points to the correct jdbc driver
jar.
2. Modify the properties in the jBPM project root pom so that they contain the correct
values for your database.
3. Run mvn -Pdatabase clean test-compile
4. Debug/run your unit tests.
h3. Appendix
The following is an example of a maven settings.xml file that you could use to test on a
local PostgreSQL database that contained a "jbpm5" schema (with user
"jbpm5" and password "jbpm5")
<?xml version="1.0" encoding="UTF-8"?>
<settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0
http://maven.apache.org/xsd/settings-1.0.0.xsd">
<profiles>
<profile>
<id>database</id>
<properties>
<maven.hibernate.dialect>org.hibernate.dialect.PostgreSQLDialect</maven.hibernate.dialect>
<maven.datasource.classname>org.postgresql.xa.PGXADataSource</maven.datasource.classname>
<maven.jdbc.driver.class>org.postgresql.Driver</maven.jdbc.driver.class>
<maven.jdbc.db.name>jbpm5</maven.jdbc.db.name>
<maven.jdbc.db.port>5432</maven.jdbc.db.port>
<maven.jdbc.db.server>localhost</maven.jdbc.db.server>
<maven.jdbc.driver.jar>/home/awesomeUser/workspace/jbpm5/lib/postgresql-8.4-702.jdbc3.jar</maven.jdbc.driver.jar>
<maven.jdbc.username>jbpm5</maven.jdbc.username>
<maven.jdbc.password>jbpm5</maven.jdbc.password>
<maven.jdbc.url>jdbc:postgresql://localhost:5432/jbpm5</maven.jdbc.url>
</properties>
</profile>
</profiles>
<activeProfiles>
<activeProfile>database</activeProfile>
</activeProfiles>
</settings>
--------------------------------------------------------------
Comment by going to Community
[http://community.jboss.org/docs/DOC-17071]
Create a new document in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=102&am...]
