Differences

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

Link to this comparison view

add_system_data_source [2016/09/22 02:35] (current)
Line 1: Line 1:
 +===== System Data Source =====
 +System data source is pre-defined jdbc database connection which is defined in //​config.properties//​ file.
 +
 +Each data source must have the following requirement properties defined:
 +  DATASOURCE.myID.CONNSTRING=jdbc connection string here
 +  DATASOURCE.myID.DRIVERCLASS=jdbc driver class path here
 +  ​
 +Optionally you may add the following properties:
 +  DATASOURCE.myID.USER=db login id
 +  DATASOURCE.myID.PASSWORD=login password
 +  DATASOURCE.myID.SQL=sql select statement
 +
 +In SQL select statement, you may use replacement token like: 
 +  SELECT COL1, COL2 FROM TABLE1 WHERE COL3='​@Param1@'​
 +where //​@Param1@//​ is the token and can be replaced with the parameter value specified using //​Param1=val//​ at runtime.
 +
 +For integration with XStudio, use the following SQL statement to access requirements:​
 +  SQL=SELECT req.requirement_name AS tag, d.requirement_description AS NAME FROM table_req_int req, table_req_int_data d WHERE req.requirement_id = d.requirement_id ORDER BY req.requirement_name
 +  ​
  
Print/export
QR Code
QR Code add_system_data_source (generated for current page)