Perforce JViews Charts Sample: JDBC Sample (JSF and JavaScript)

Description

This sample displays data imported from a CSV file. The set of data is displayed by a JViews Charts Faces component.

How to Use the Sample

Use the toolbar buttons to fit or to set zoom or pan interactor on this chart.
Use the combo boxes to select a chart stylesheet or a chart display type.

Installing the Thin-Client Sample

The sample contains a WAR file (Web Archive) that allows you to easily install the sample on any server that supports the Servlet API 2.1 or later. For your convenience, the WAR will be copied to the Tomcat web server that is supplied with the Perforce JViews installation when you start the server using the supplied scripts. Tomcat is the official reference implementation of the Servlet and JSP specifications. If you are already using an up-to-date Web or application server, there is a good chance that it already has everything you need. The sample can also be deployed to WebSphere Application Server (WAS).

Running the Sample Using Tomcat

If you intend to use the Tomcat Web server provided with this installation, follow these instructions to start the server: Running the Server-Side Samples. The scripts to start the server can be found in the tools/tomcat-jsf directory.
Note: if you are running on Windows then you will find menu items in the Windows "start" menu to start and stop the Tomcat server.

Once the server is running, you can see the sample by opening the following page:

Perforce JViews Charts Sample: JDBC Sample (JSF and JavaScript)
http://localhost:8080/jsf-chart-jdbc

Running the Sample Using WebSphere Application Server

In addition to the instructions provided for using Tomcat, the samples can be viewed on WebSphere Application Server. Follow the instructions: Running the Server-Side Samples and use the scripts to start the server and deploy the sample.

Once the server is running, you can see the sample by opening the following page: http://localhost:9443/jsf-chart-jdbc
The WAS administrative console can be used to verify or modify server settings: http://localhost:9043/ibm/console/

Note: the WAS server can start on a range of port numbers, therefore the value is not guaranteed to remain the same. The scripts provided with the samples can be used to obtain the port numbers used by the Admin Console and by the deployed Web applications. To retrieve a list of all the WAS port numbers, run the command line instruction: ant -f build_was.xml ws.list.ports

Topics Covered

JavaServer Faces
JDBC

Detailed Description

This sample shows how to load data from a database using a JDBC connection. The data is stored in a CSV file. The corresponding data set is displayed in a chart.

The data is extracted from the CSV data source and stored in the data sets using an IlvJDBCDataSource initialized for a JDBC-CSV connection (the connection string is equal to jdbc:relique:csv:FILE_DIRECTORY and the driver name to org.relique.jdbc.csv.CsvDriver). A query is executed to retrieve the data and build the corresponding data sets. Data is displayed by a JViews Charts Faces component.