Connecting with Properties

Print-friendly Version

Training Index

[Table of Contents]

Skeleton Code

• ConnectMe.java

This exercise results in an application that connects to an ODBC database through the JDBC-ODBC Bridge. You have to run it from the command line, rather than from a page in a browser. Also, you have to ensure that the database server is enabled.

Instead of hardcoding a datasource, username, and password in the program, an external file is used for this information. This is the method for the remaining exercises.

Perform the following tasks:

1. Setup the file odbc.datasource in the current directory to have three key-value resources. (key=value)

Key	Value
datasource.name	contains the name of the ODBC datasource
datasource.username	contains the username to access datasource
datasource.password	contains the password of odbc.username

2. Import the JDBC package.
3. Load the sun.jdbc.odbc.JdbcOdbcDriver class.
4. Create a Connection to the DriverManager.
5. Examine the database metadata to display the name and version of the database and driver.
6. Close the connection.

The task numbers above are linked to the step-by-step help page. Also available is a complete solution, which meets these requirements, and Expected Behavior.

Copyright © 1996 Magelang Institute. All Rights Reserved.