CSV Socket Reader Input Adapter Sample

About This Sample

This sample demonstrates the use of the TIBCO StreamBase® CSV Socket Reader to read 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-level menu, click FileLoad StreamBase Sample.

  • Type csvs to narrow the list of options.

  • Select CSV Socket Input Adapter from the StreamBase Standard Adapters category.

  • Click OK.

StreamBase Studio creates a project for the sample.

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 your workspace copy of the sample, as described above

  3. In the window, compile the sample server with this command: javac src\main\java\com\sample\adapter\csvsocketreader\SimpleServer.java

  4. In the window, run the sample server with this command: java -cp src\main\java com.sample.adapter.csvsocketreader.SimpleServer

  5. In the Project Explorer, open the sample you just loaded.

  6. Open the src/main/eventflow folder.

  7. Open the package folder (most samples contain a single package folder. Open the top-level package folder if your sample contains more than one folder).

  8. Open the CSVSocketReader.sbapp application file.

    If you see red marks, wait a moment for the project in Studio to load its features.

    If red marks do not resolve themselves in a moment, select the project and right-click MavenUpdate Project from the context menu.

  9. As the server sends lines of the input file to the application, they will appear in the Output Streams view.

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

  11. In the window running simpleserver, press Ctrl+C to stop the server.

Sample Location

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace, which is normally part of your home directory, with full access rights.

Important

Load this sample in StreamBase Studio, and thereafter use the Studio workspace copy of the sample to run and test it, even when running from the command prompt.

Using the workspace copy of the sample avoids permission problems. The default workspace location for this sample is:

studio-workspace/sample_csvsocketreader

See Default Installation Directories for the default location of studio-workspace on your system.