Example: Sending, Receiving, and Viewing Data

Use the working example provided in the adapter distribution to learn how to send a SQL query to the adapter, and receive XML-formatted stream data from Event Stream Processor and view it in a Web browser.

Prerequisites
A network connection.
Task
  1. Start Event Stream Processor.
    Operating System Step
    UNIX Open a terminal window:
    1. Start the example cluster:

      start_server_cluster.sh

    2. Start the project on the cluster:

      start_project.sh
    Windows Open a command window:
    1. Start the example cluster:

      start_server_cluster.bat

    2. Add project to the cluster, and start it on the cluster:

      start_project.bat
  2. Edit the adapter.sh script.
  3. Set the JAVA_HOME environment variable to the directory where the Java Runtime Environment (JRE) is installed.
  4. Start the adapter.
    Operating System Step
    UNIX Open a terminal window and enter:

    ./adapter.sh
    Windows Open a command window and enter:

    adapter.bat
  5. Wait five to ten seconds for the adapter to initialize.
  6. Start uploading stream records.
    Operating System Step
    UNIX Open a terminal window and enter:

    ./upload.sh
    Windows Open a command window and enter:

    upload.bat
  7. Load the HTTPAdapterClient.html page in a Web browser.
  8. Enter a valid SQL query, for example:
    SELECT * FROM Stream1
    Note: Queries that return a smaller number of records may not appear on some browsers because those browsers appear to expect a certain amount of data to be present in the buffer cache before they display the data. For example:
    SELECT * FROM Stream1
where intcol = 10
    • Mozilla FireFox browser -- displays record.
    • Google Chrome browser -- does not display record.
    • Internet Explorer browser -- does not display record.
    SELECT * FROM Stream1
where intCol > 10
    (executed in debug mode)
    • Mozilla FireFox browser -- records appear after they are sent to the browser.
    • Google Chrome browser -- records appear after the fifth record is sent to the browser.
    • Internet Explorer browser -- records appear after the 20th record is sent to the browser.
  9. Click Submit.
    Note the records being streamed into the Web browser window.
Parent topic: HTTP Output Adapter