Differences

This shows you the differences between two versions of the page.

Link to this comparison view

system_datasource [2016/09/22 02:36] (current)
Line 1: Line 1:
 +===== System DataSource =====
 +
 +''​System DataSource''​ defines a shared data access point. ​ It is defined in '/​www/​MbtSvr/​config/​config.properties'​ as follows:
 +
 +  DATASOURCE.TestDB.CONNSTRING=jdbc connection string
 +  DATASOURCE.TestDB.DRIVERCLASS=jdbc driver class path
 +  DATASOURCE.TestDB.PASSWORD=myDbUserID
 +  DATASOURCE.TestDB.USERNAME=myPassword
 +
 +where ''​TestDB''​ is the name of the data source to be used in the model.
 +
 +Typically you will use the following format to specify URI:
 +  sql:​datasource=TestDB;​sql=SELECT * FROM EMPLOYEE
 +
  
Print/export
QR Code
QR Code system_datasource (generated for current page)