OpenLink UDA JDBCDemo sample application usage on Windows
This document describes how to use to the OpenLink UDA JDBCDemo sample application to make a connection to a target database with the OpenLink JDBC Drivers on Windows.
Prerequisites
- Install the OpenLink UDA JDBC Driver
- Ensure the OpenLink JDBC Driver (opljdbcX.jar) file in the CLASSPATH environment variable.
C:\Users\openlink>set %CLASSPATH%
Environment variable C:\Program Files\OpenLink Software\UDA\bin\opljdbc4_2.jar;C:\Program Files\OpenLink Software\UDA\jdk1.8\\megathin4_2.jar;
Usage
-
Goto the JDBCDemo sample application folder
C:\Program Files\OpenLink Software\UDA\Sample\JDBC\jdk1.8\JDBCDemo
by default
-
Run the
jdbcdemo.bat
file
-
Got to the
File
→ Set Connection URL` menu item to set the JDBC driver name and connect string
-
Set a valid JDBC
Driver Name
andConnection URL
(connect string) for the target database and click theOK
button to connect
-
Once connected enter a valid SQL query in the text windows provided and click the
Query
button to execute the query
-
A result page is now presented displaying the first row for results and the
Next
button can be clicked to scroll through the rows.