< Previous | Front page | Next >
Skip to end of metadata
Go to start of metadata

Overview

In BPEL component, we are using the in-memory H2 database, this page is trying to give you an example that update it to a Mysql database.

Changing database steps

Download db ANT script.

Download the db ANT script zip from here, we use the RiftSaw-3.0.0 Final release (used in SwitchYard 1.0.0.Final) as an example.

Create and install the mysql database driver.

  1. create the folder in $SwitchYard/modules/mysql/main, and then copy the mysql-connector-java-5.1.12.jar (of course, you can choose other versions, but in this page, we are using this version as an example) inside it.
  2. create a module.xml along with it, the content is like following:
  3. add the mysql driver and the datasource in standalone.xml file.

Update the database information, and run ANT script to populate the riftsaw schema

Go to the folder that you have extracted for db script zip that we downloaded earlier, let us call it '$dbscript'.

  1. update the jdbc properties properly in $dbscript/jdbc/mysql.properties. (for other databases, update other $database.properties file)
  2. update the build.xml file's database property as your target db, (mysql in this case)
  3. run following command to populate the schema:
    you should be able to view the tables via: ant db.show.tables command, and drop the database script through: ant drop.riftsaw.schema

Override the properties for bpel component in standalone.xml file

Go to the $SwitchYard/standalone/configuration/standalone.xml, find the BPELComponent, and then overriding following properties:

Then you should be ready to start the SwitchYard, the BPEL component will use the database that you created.

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.