RelDBQueryDataService |
![]() ![]() ![]() |
org.moremotion.mmcomp.reldb.RelDBQueryDataService class existing in mmcomp_reldb.jar implements MoreMotion's org.moremotion.datasrc.DataService interface and it is used to query relational data bases with the SQL statements given as parameters. This class is configured with a dataSource element in the configuration as follows.
Parameters conn (Accepts MScript) The name of a JDBC connection that is configured with jdbcConnection element. query (Accepts MScript) The SQL query that defines the content of the data source. The output ADOM will contain an "item" node for each result record and each item node will contain sub-nodes for all the columns existing in the result set. Therefore it is recommended to select only the required columns (e.g. SELECT ID, NAME FROM ...) instead of selecting all columns (SELECT * FROM ...) By using MScript the SQL statements can be constructed dynamically.
See selecT Query In addition to the regular queries you can also make stored function calls in this parameter. Depending on the JDBC driver the stored function calls can be made directly or by enclosing within '{' and '}' characters. Example: {call my_stored_procedure}
See Navigation
See dataSource configuration element for other Data Source parameters.
|