This repository provides an OPL extension that provides database connectivity using a JDBC custom datasource. This extension allows read and write of tuplesets from/to a database.
The extension is based on a JDBC custom datasource. For more information and a java sample, you can refer to OPL-jdbc-custom-data-source.
This example will work with OPL versions greater than 12.6, even if it is configured to run with 12.9.0 version.
-
This sample assumes that IBM ILOG CPLEX Optimization Studio 12.9.0 is installed and configured in your environment.
-
Install Java.
Once installed, you can check that it is accessible using this command:java -version -
The sample assumes you have a database with JDBC drivers installed. This sample specifically provides instructions for IBM DB2 Express-C and MySQL Comunity Server, but is compatible with minimal changes with other JDBC compatible databases.
You can download the sample by cloning the github repository:
git clone https://github.com/IBMDecisionOptimization/OPL-jdbc-data-source.git
Then you download the latest binaries from https://github.com/IBMDecisionOptimization/OPL-jdbc-data-source/releases
The zip file contain an opl_jdbc directory containing a .js and a .jar files. Copy those files next to your OPL project directory, next to your .dat and .mod files.
Before you run the sample, you need to create and populate an example database. See details in subsections:
The examples/studio_integration sample shows how to
use the jdbc custom data source as a library, without having the need to
invoke OPL runtime from java. You can use this method to access database
using a jdbc-custom-data-source from oplrun or OPL Studio.
- The custom data source reader supports scalar values, sets and tuplessets. Arrays are not supported.
- Inner tuples are not supported.
This sample is delivered under the Apache License Version 2.0, January 2004 (see LICENSE.txt).