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.