Overview of JDBC Query Data Source - EcoSys - Customization & Programming - Hexagon

EcoSys Gateway Web Service API Client

Language
English
Product
EcoSys
Search by Category
Customization & Programming
EcoSys Version
9.1

EcoSys Gateway can be read from any JDBC query as its input source in place of a flat file.

To invoke this mode, specify the input file on the command line to begin with the "@" character. This indicates that the input file is a configuration property file (rather than a data file) with details about how to execute a SQL query.

Example

java -jar gateway.jar create http://.../restxml/Sample/ @query.txt ...

The contents of the "query.txt" configuration property file are described below.

In JDBC query mode, the column names returned by the query are used as the input data header, and the values on each row are used as input data records. The query is read until all the resulting rows are processed, the same as if it were reading from a file.

When operating in JDBC mode, the output performance report from EPC Gateway will also include timing data about the SQL query data source performance. EPC Gateway runs a query to get the size of data being received via JDBC data source, which can be skipped using -skiprowcount option from the command line. See examples on how to use this option.