Using DBIntegrator Client for JDBC

[Top] [Prev][Next][Bottom]



 

Using the Sample Applet

Included with the DBIntegrator Client for JDBC is a sample applet/application called DBSample. Use it to test your data source connection.

The sample consists of the following files:
 
File Description
DBSample.html Demo html page which uses DBSample.class.
DBSample.java DBSample.class and AppletFrame.class Source Code. (The file has a .txt suffix to make it easier to view.)
DBSample.class Sample applet/application.
AppletFrame.class Class used by DBSample when run as an application.

Configuring the Sample Applet

Make sure the CLASSPATH environment variable is set properly. For more information, see the Setting the CLASSPATH Variable section.

If you will be using DBSample as an application (running "java DBSample"), make sure the directory which contains DBSample.class and AppletFrame.class is on the CLASSPATH. Or, if you will be using DBSample as an applet and you want the JDBC driver classes to be loaded from your Internet/intranet server, make sure the 'simba.jdbc' package is in the same directory as DBSample.html and DBSample.class.

Running the Sample Applet

To Use DBSample as an Application:
Run the Java interpreter passing 'DBSample' on the command line, as shown here:
java DBSample
To Use DBSample as an Applet:
Run any JDK 1.3.1 enabled browser, and point to the DBSample.html page on a web
server (not a file:// URL).

Using the sample's interface

Here is a screen capture of the sample's interface:



1. Fill in the required fields:
    Server Name -- Host name or IP address of the server DBIntegrator Server is running on. If running DBSample as an applet through the brower, type the server name exactly as it appears in the browser's URL.
    Server Port  -- TCP port number which DBIntegrator Server is 'listening' on.
    Data Source -- ODBC Data Source Name as listed in the odbcdmn.ini file (or ODBC.INI Registry section) on the DBIntegrator Server.
    User and Password are also required to access a DataServer database.
    See Connecting to Data Sources for more information.
2. Click 'Connect'. Connection information or errors are displayed in the Results field.

3. Once a connection has been established you can request information about the database by clicking 'View Tables' or 'Database Information', or you can enter an SQL Command and click 'Execute'. Results of these queries are displayed in the Results field.


[Top] [Prev][Next][Bottom]


csr@unify.com

Copyright © 1998-9, 2002, Unify Corporation. All rights reserved.