OpenWGA 7.10 - OpenWGA Concepts and Features

Content Stores » Platforms

MySQL

The MySQL database server is a relational database platform available as open source and the most frequently used platform for OpenWGA content stores. MySQL is owned by the Oracle corporation.

OpenWGA supports the usage of OpenWGA content stores on MySQL database servers of version 5.0 or higher.

Preparations

In order to connect to the MySQL database server OpenWGA needs the JDBC driver Connector/J in the classpath of the application server. Use a version appropriate for the MySQL server version in use.

When using the OpenWGA debian packages you can install the additional package openwga-driver-mysql to install the Connector/J driver version coming with your debian package repository. It will also automatically add this driver to the classpath of your OpenWGA server.

For all other installation methods put the JDBC driver JAR files into the classpath of your application server:

  • If you used the official linux installer you can put them into "/opt/tomcat/lib"
  • In OpenWGA Developer Studio just open the configuration of your runtime project by double-clicking the file "runtime.xml", go to register "configuration" and add the files there in section "Tomcat Libraries".

You will need to restart the OpenWGA server for the driver to become available.

Special features

OpenWGA offers support for a "shared server connection pool" for MySQL which can be enabled as option on the database server configuration in OpenWGA admin client. Using this all of your content stores and data sources on the given MySQL server will use a shared connection pool with a fixed maximum of used connections.