New and improved JDBC test tool
 Downloadable files
 
Abstract
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.
 
URL LANGUAGE SIZE(Bytes)
jdbc test setup and overview English 10000
 
Download package
What is DD?
Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
jdbctest.java 5/28/2002 US English 15000 FTP DD
 
Technical support
1-800-IBM-SERV (U.S. Only)
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s): Windows
Software version: 6.0
Software edition:
Reference #: 4001799
IBM Group: Software Group
Modified date: Dec 17, 2006