Kbase 21247: How To Configure JDBCTEST To Test JDBC Issues
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Solution ID: 21247
GOAL:
How to configure JDBCTEST in order to test and learn JDBC APIs.
FACT(s) (Environment):
Progress 9.1x
FIX:
JDBCTEST contains menu selections that correspond to specific JDBC functions -- for example, connecting to a database or passing a SQL statement. Functionality includes the ability to:
-- execute a single JDBC method, or execute multiple JDBC methods
simultaneously, to perform common tasks such as returning a result sets.
-- display the results of all JDBC function calls in one window
while displaying fully commented, JAVA JDBC code in an alternate
window.
First, set the CLASSPATH environment variable to include %DLC%\java\jdbc.zip on Windows, and $DLC/java/jdbc.zip on UNIX, prior to starting JDBCTEST.
On Windows, start JDBCTEST.bat
On UNIX, start JDBCTEST.sh
Second, test the connection.
1) Start up a database with the -S parameter.
2) Bring up JDBCTEST, Select Driver/Register Driver, and type the
following in Driver URL:
com.progress.sql.jdbc.JdbcProgressDriver
Click on OK
3) Select Connection/Connect to Database,
in Database field type URL jdbc.jdbcprogress:T:host:service:dbname
in User Name field type login
in Password field type passwd
Click Connect button.