The fifth example shows, how to access databases with the DatabaseSender. It uses a table named example5
specially designed for this example. This table is already setup in the all-inclusive distribution. For the other distributions, you will find create statements in XBUS_HOME/src/sql
to setup the example5
table. When there is no file for your database, you have to edit an existing one. Please be aware, that the first column (number
) must be an automatically incrementing datatype.
First an XML file is read by the FileReceiver
. This file contains three SQL statements:
- The first statement inserts a row in the database.
- The second and third statement select the whole content of the table, with different sorting.
The SQL statements will be sent to the database, the result is returned in a XML format and written into a file. The XML formats of the request and response are described here.
In a Windows command window type receiversingle Example5InFile
, in a Unix shell type receiversingle.sh Example5InFile
to start the processing of this example.