Skip to content

Latest commit

 

History

History
89 lines (59 loc) · 3.1 KB

README.DB2.md

File metadata and controls

89 lines (59 loc) · 3.1 KB
Raw

Run sample with DB2

Build the sample

Sample studio_integration do not need to be compiled, so you can skip this section.

Before you build the oil sample, you must edit build.properties for the appropriate path locations:

  • If you want to run the sample with IBM DB2, db2.jdbc.connector.path should point to your JDBC driver location.
  • opl.home should point to your OPL home, unless you have a CPLEX_STUDIO_DIR128 set. (this variable should exists if you installed on a Windows machine).

The build file, build.xml, imports the build file from the OPL samples, in <opl home>/examples/opl_interfaces/java/build_common.xml. This build file defines all variables that are needed to configure the execution.

The example is compiled using the compile Ant target:

ant compile

The example is automatically compiled with the run Ant targets is invoked.

Setup the sample database

To run the sample with DB2. you need to install DB2. DB2 Express-C is a free community edition of DB2. DB2 Express-C is available on Microsoft Windows, Linux and Mac OS.

You can download and install DB2 Express-C from here.

In a DB2 Command Window:

Create database using db2 create database CUSTOMDB

Run the following SQL script to create and populate the example database:

db2 -tvmf data/oil_db2.sql

You can download the DB2 jdbc driver here. Note that if you installed DB2 Express-C, your JDBC driver is db2jcc4.jar in <DB2 installdir>/SQLLIB/java.

Depending on the sample you run, you need to edit, build.properties to make db2.jdbc.connector.path point to your DB2 jdbc driver.

Depending on the sample you run, you need to edit build.properties to make db2.jdbc.connector.path point to your DB2 jdbc driver (i.e. db2jcc4.jar).

In sample studio_integration, you will need to edit jdbc.js to point to your jdbc driver, or add an OPL_JDBC_DRIVER environment variable pointing to it:

	var jdbc_driver = IloOplGetEnv("OPL_JDBC_DRIVER");
	if (! jdbc_driver ) {
		jdbc_driver = "../../external_libs/db2jcc4.jar";  // default for this project
	}

For sample oil, edit data\db_db2.xml for your JDBC connection string and credentials. Your connection string looks like db2://localhost:<port>/<database_name> where port is the DB2 port (default is 50000), <database_name> is the name of your database (default is CUSTOMDB).

Run the oil sample

Compile and run the sample for IBM DB2:

$ ant run_db2
  • Uses data/oil.mod as a model file
  • Uses data/oil.dat as a data file
  • Uses data/db_db2.xml to customize the JDBC custom data source.

Other samples

The other samples do not need to be compiled, and will use oplrun executable. Each sample directory contains a convenience run.bat command line to run the sample. Otherwise you run them using the run target:

$ ant run