JDBC Table Data Construct Sample

Add a reference in the project's sbd.sbconf file to the JDBC driver JAR file provided by your database vendor. This is done using the <jar> child element under the <java-vm> element. For example, to use Microsoft SQL Server 2008:

<java-vm>
     ...
     <jar file="/path/to/sqljdbc4.jar"/>
     ...
</java-vm>

Add the JAR to the project's Java build path. Right-click the project folder in Studio's Package Explorer view, and select Build Path → Configure Build Path (or invoke Project → Properties in Studio's top-level menu). In the Properties dialog, select Java Build Path on the left, then select the Libraries tab. On that tab, select Add External JARs, then browse to and select the appropriate driver JAR file or files on your system. Click OK to close the dialog.

Define your external JDBC data source in the project's sbd.sbconf file in the <data-sources> element. For example, to add a Microsoft SQL 2008 data source:

<data-sources>
    ...
    <data-source name="mssql2008" type="jdbc">
      <uri value="jdbc:sqlserver://mssql2008.server.com"/>
      <driver value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
      <param name="user" value="sqluser"/>
      <param name="password" value="sqlpass"/>
    </data-source>
    ...
</data-sources>

Configure the URI, username, and password parameters appropriately for your installation.

In the OrderBook table's Data Source tab, select the JDBC Data Source (which you previously defined in sbd.sbconf) from the drop-down menu.

Optional step for stored procedures: If your database supports stored procedures, the GetOrdersBySymbol Query operator can call a stored procedure to select data records. To enable this, you might need administrative access to the database system. Select the GetOrdersBySymbol Query operator and click its General tab. Commands in database-specific syntax to execute the procedure are listed in the Description field. Copy the one you need, then click the Query Settings tab and paste the copied command into the SQL statement field.

Use a database browser client application to start and connect to the database. Copy the appropriate code snippet from the create-proc.txt file and send the stored procedure to the database.

Make sure the database you are connecting to is up and active.

To run the application, in the Package Explorer, right-click JDBCQuery.sbapp and select Run As → StreamBase Application. StreamBase Studio opens the Test/Debug perspective and starts the application.

In the Test/Debug perspective, go to the Feed Simulations tab, select OrderBookFeedSim from the list, and click the Run button. Rows are inserted to the JDBC OrderBook table through the InsertIn input stream. If you view the InsertOut output stream, you can see those data records as they are entered.

Switch to the Manual Input view. Select the ReadIn input stream from the drop-down menu, and click Send Data. This issues a query that returns all rows in the table where Side='bid'. To see those results, select the ReadOut stream in the Application Output tab.

From the Manual Input view, select the DeleteIn input stream. Based on the results from the previous Read query, type a known value for the QuoteID field, and click Send Data. You can then run step 9 again to confirm that this QuoteID was deleted from the OrderBook table.

Optional step for stored procedures: If you configured for stored procedure support in step 5, call it as follows: In the Manual Input tab, select the StoredProcIn input stream. In the Symbol field, enter a known value in the table. The feed simulation supplied by this project populates the table with the Symbols TIBX, GOOG, IBM, and MSFT. Click Send Data and view the results returned on the StoredProcOut output stream.

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