-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
Hi All,
I'm trying to connect to the mysql database with cplex opl. I receive the error " impossible to load model". I didn't understand where is my error.
below is my code:
prepare {
includeScript("jdbc.js");
var db = JDBCConnector("jdbc:mysql://finqfinancemysql:3306/testmysql?username=finqadmin&password= Password");
db.read("funds", "SELECT id FROM funds");
db.read("risk", "SELECT finq_risk_level FROM funds");
db.read("yield", "SELECT finq_yield_level FROM funds");
db.read("categories", "SELECT fund_type FROM funds");
db.read("houses", "SELECT fund_house FROM funds");
}
// EDIT: you want to change this for your actual driver
var jdbc_driver = "mysql-connector-java-8.0.30.jar"
// EDIT: specify where to look for the jdbc driver. Default is in . (besides this .js script) and in ../../external_libs
var jdbc_driver_path = ".;../../external_libs"
// EDIT: specfify where jdbc-custom-data-source is of the github project.
// default is to look in . and ../../lib
var libs = ".;../../lib";
Thanks,
Aviv
Metadata
Metadata
Assignees
Labels
No labels