All Examples
package examples.jdbc.odbc
about this package
This package shows how to select data and database
metadata with WebLogic's multitier WebLogic JDBC driver, using the
JDBC-ODBC bridge and an ODBC driver.
You must define the data you want access with the ODBC Data Source Administrator.
On a Windows computer, use the ODBC Control Panel to define the data source. On
other platforms, check the documentation provided with your ODBC driver manager
for instructions. You put the Data Source Name (DSN) that you define in ODBC into
the database URL to allow the WebLogic T3 driver to open the data source.
This package also requires a running WebLogic Server and the
WebLogic JDBC multitier JDBC driver.
For more info on WebLogic JDBC and using the JDBC-ODBC bridge, see the
Developers Guide, Using WebLogic
JDBC, and see the Tech Tip, What do I
do with all these connections, anyway?
how to use this package
To set up this example:
- Set up your development shell as described in Setting up your environment.
- Change the ODBC_DSN
portion of the URL to match an ODBC Data Source Name (DSN) in your
ODBC environment.
- Compile the Java file with the following command:
$ javac -d %CLIENT_CLASSES% simpleselect.java
- Start the WebLogic Server.
- Run this program from a command line, with:
$ java examples.jdbc.odbc.simpleselect
there's more . . .
Read more about using this JDBC driver in the general Developers Guide,
Using the jdbcKona
family of JDBC drivers, and on using the JDBC/ODBC bridge with
WebLogic JDBC in the Developers Guide for
WebLogic JDBC
Using WebLogic JDBC.