Verify JDBC connectivity to DB2®, Oracle, Microsoft® SQL
Server (using several drivers), Cloudscape™, Sybase, and Informix®
Download Description
Compiling the tool verifies that the Java™ compile/install environment
is set up correctly on the target machine.
Running the tool (such as, java jdbctest) verifies that the java
runtime/classpath setup is correct, and verifies connectivity from a Java
Virtual Machine to an Oracle, DB2, Cloudscape, Sybase, or Infomix
Database. This can pinpoint problems related to accessing a WebSphere®
Application Server repository or business application database from within
WebSphere Application Server.
It also has the capability of determining the maximum available number of
connections to a database manager, and the ability to enter arbitrary SQL
statements against the target database.
Source only is provided. Users must compile the tool using any Java
runtime, such as the Java SDK provided with WebSphere Application Server,
by running:
javac -extdirs WebSphere_install_root_path
jdbctest.java
When running the tool (by executing "java jdbctest"), the user is prompted
for basic access and security information such as user ID, password, and
database name or jdbc URL. The tool will then attempt to connect to the
target database and display basic connectivity information.
For details on correctly setting up the path and classpath for compiling
and running jdbctest, as well as to see sample output, see the link under
Installation Instructions "jdbctest setup and overview link."
Prerequisites
Java SDK 1.1, 1.2.x , or 1.3.x (if using with WebSphere Application
Server, works with all currently bundled Java SDK's).
Installation Instructions
See "jdbctest setup and overview link" for instructions on compiling
and running this tool.