Contents
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.
-
Open a terminal window on UNIX, or a StreamBase Command Prompt on Windows, outside of StreamBase Studio.
-
In the window, navigate to the directory where the sample is installed, or to your workspace copy of the sample, as described above
-
In the window, run the sample server with this command:
java -jar simpleserver.jar
-
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. -
Click the
Run button. This opens the SB Test/Debug perspective and starts the application.
-
As the server sends lines of the input file to the application, they will appear in the Application Output pane.
-
When done, press F9 or click the
Stop Running Application button.
-
In the window running
simpleserver
, press Ctrl+C to stop the server.
-
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.
-
In window 1, run the sample server with this command:
java -jar simpleserver.jar
-
In window 2, run
sbd CSVSocketReader.sbapp
-
In window 3, run
sbc dequeue OutputStream1
-
Look for the processed tuples being output in window 3, one tuple per second.
-
When done, run
sbadmin shutdown
-
In the window running
simpleserver
, press Ctrl+C to stop the server.
In StreamBase Studio, import this sample with the following steps:
-
From the top menu, click
→ . -
Select this sample from the Embedded Adapters list.
-
Click OK.
StreamBase Studio creates a single project containing the sample files.
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 the permission problems that can occur when trying to work with the initially installed location of the sample. The default workspace location for this sample is:
studio-workspace
/sample_csvsocketreader
See Default Installation Directories for the location of studio-workspace
on your system.
In the default TIBCO StreamBase installation, this sample's files are initially installed in:
streambase-install-dir
/sample/csvsocketreader
See Default Installation Directories for the default location of studio-workspace
on your system.