WebMaker 4 to 5 come pre-configured to allow you to use 3 different databases: Microsoft SQL Server, Oracle, and IBM DB2.
Note: WebMaker 6 includes MySQL, MariaDB and PostgreSQL. WebMaker 7 includes Apache Derby. The WebMaker 6/7 jars have been attached to a post below and can be used for WebMaker 4 to 5. The MariaDB driver covers MySQL.
It is however possible to use any database that provides JDBC drivers if not built in. In order to do this, you will need to obtain the JDBC driver JAR from your database vendor. These jars must be Java 1.6 compatible.
{webmaker deployment location}\design\tomcat-design\common\lib
{webmaker deployment location}\runtime\tomcat-runtime\common\lib
You can now start up the studio and bring up the database connection setup screen. You should select the 'Other' option for the Database Type, and then manually enter the required details. You should be able to find out the name of the JDBC driver class to use, and the format of the Connection URL from the documentation for your database driver.
As an example, for MySQL the JDBC driver should be 'com.mysql.jdbc.Driver', and the connection URL should be of the form 'jdbc:mysql://localhost/database_name'. Please remember to change the localhost and database_name to the appropriate values.
For more details of how to use SQL Databases within WebMaker, please refer to the product documentation.
Please note, that if you are publishing your application you will need to make sure that the JDBC JAR also ends up in the output from the publication process.
Note: WebMaker 6 includes MySQL, MariaDB and PostgreSQL. WebMaker 7 includes Apache Derby. The WebMaker 6/7 jars have been attached to a post below and can be used for WebMaker 4 to 5. The MariaDB driver covers MySQL.
It is however possible to use any database that provides JDBC drivers if not built in. In order to do this, you will need to obtain the JDBC driver JAR from your database vendor. These jars must be Java 1.6 compatible.
{webmaker deployment location}\design\tomcat-design\common\lib
{webmaker deployment location}\runtime\tomcat-runtime\common\lib
You can now start up the studio and bring up the database connection setup screen. You should select the 'Other' option for the Database Type, and then manually enter the required details. You should be able to find out the name of the JDBC driver class to use, and the format of the Connection URL from the documentation for your database driver.
As an example, for MySQL the JDBC driver should be 'com.mysql.jdbc.Driver', and the connection URL should be of the form 'jdbc:mysql://localhost/database_name'. Please remember to change the localhost and database_name to the appropriate values.
For more details of how to use SQL Databases within WebMaker, please refer to the product documentation.
Please note, that if you are publishing your application you will need to make sure that the JDBC JAR also ends up in the output from the publication process.