Populating output

In order to automatically create a result set, the M3 Web Services Designer must be able to call the database itself. To do this, it requires a JDBC driver. The JDBC driver is usually a jar file available from the database vendor's website. If SQL queries are enabled on the server side, you can ask your M3 Web Services Server administrator for the correct driver to use, as the server also requires the same file.

See information about importing the required JDBC driver in Specifying the Development Settings.

  1. Click Populate output from statement.... The Select configuration window is displayed.
  2. Select the configuration so that the correct driver name and URL can be determined. Click OK.

    The Enter database credentials window is displayed.

  3. Specify the login to the database and click Finish.

    The output results are now retrieved.

    Note: The above example from M3 shows the field lengths as double the length you might expect. This is a quirk of the driver and a Unicode database, and is not a fault of M3 Web Services.
  4. Save the result by pressing CTRL+S.