CSV Socket Reader Input Adapter Sample

Contents

Importing This Sample into StreamBase Studio
Sample Location
Running This Sample in StreamBase Studio
Running This Sample in Terminal Windows

This sample demonstrates reading CSV data from a TCP socket. The CSV Socket Reader is configured to connect to a server running on port 9000 of the local computer to read CSV data. The sample comes with a very simple server written in Java. The source code and compiled JAR of this server can be found in the sample's directory. The server simply listens on port 9000 and serves the contents of a file at one line per second to any connections. The default input file is input.txt, but you can specify a different file on the command line that starts the server.

Importing This Sample into StreamBase Studio

In StreamBase Studio, import this sample with the following steps:

  • From the top menu, click File → Load StreamBase Sample.

  • Select this sample from the Embedded Adapters list.

  • Click OK.

StreamBase Studio creates a single project containing the sample files.

Sample Location

By default, the sample files are installed in:

On Windows

C:\Program Files\StreamBase Systems\StreamBase.n.m\sample\adapter\embedded\csvsocketreader\

On UNIX

/opt/streambase/sample/adapter/embedded/csvsocketreader/

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace. StreamBase Systems recommends that you use the workspace copy of the sample, especially on UNIX, where you may not have write access to /opt/streambase. In the default installation, the path to this sample in your Studio workspace is: 

UNIX:       
  ~/streambase-studio-n.m-workspace/sample_adapter_embedded_cvssocketreader
Windows XP:
  C:\Documents and Settings\username\My Documents\StreamBase Studio n.m Workspace\
      sample_adapter_embedded_cvssocketreader
Windows Vista:
  C:\Users\username\Documents\StreamBase Studio n.m Workspace\
      sample_adapter_embedded_cvssocketreader

Running This Sample in StreamBase Studio

  1. Open a terminal window on UNIX, or a StreamBase Command Prompt on Windows, outside of StreamBase Studio.

  2. In the window, navigate to the directory where the sample is installed, or to your workspace copy of the sample, as described above

  3. In the window, run the sample server with this command: java -jar simpleserver.jar

  4. In the Package Explorer, double-click to open the CSVSocketReader.sbapp application. Make sure the application is the currently active tab in the EventFlow Editor.

  5. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  6. As the server sends lines of the input file to the application, they will appear in the Application Output pane.

  7. When done, press F9 or click the Stop Running Application button.

  8. In the window running simpleserver, press Ctrl-C to stop the server.

Running This Sample in Terminal Windows

  1. Open three terminal windows on UNIX, or three StreamBase Command Prompts on Windows. In each window, navigate to the directory where the sample is installed, or to your workspace copy of the sample, as described above.

  2. In window 1, run the sample server with this command: java -jar simpleserver.jar

  3. In window 2, run sbd CSVSocketReader.sbapp

  4. In window 3, run sbc dequeue OutputStream1

  5. Look for the processed tuples being output in window 3, one tuple per second.

  6. When done, run sbadmin shutdown

  7. In the window running simpleserver, press Ctrl-C to stop the server.