Database Access - Java - page 739

Table 18-2. Some JDBC drivers

Driver class Start of dbURL Database

Bridge to Microsoft ODBC (in-
cluded with JDK on Windows
platforms)

sun.jdbc.odbc.JdbcOdbcDriver jdbc:odbc:

Instant Database (IDB)

jdbc.idbDriver jdbc:idb:

oracle.jdbc.Driver.OracleDriver jdbc:oracle:thin:@server:port#:dbname Oracle

PostgreSQL (freeware database) postgresql.Driver jdbc:postgres://host/database

MySql (freeware database)

org.gjt.mm.mysql.Driver jdbc:mysql://host/database

Example 18-4 is a sample application that connects to a database. Note that we now have to
catch the checked exception SQLException because we're using the JDBC API. (The
Class.forName() method is in java.lang , and so it is part of the standard Java API, not
part of JDBC.)

Example 18-4. Connect.java
public public class class Connect Connect {

public public static void main ( String [] av ) {

String dbURL = "jdbc:odbc:Companies" ;
try

static void

try {
// Load the jdbc-odbc bridge driver
Class . forName ( "sun.jdbc.odbc.JdbcOdbcDriver" );

// Enable logging
DriverManager . setLogWriter ( new

new PrintWriter (( System . err )));

System . out . println ( "Getting Connection" );
Connection conn =
DriverManager . getConnection ( dbURL , "ian" , "" ); // user, passwd

// If a SQLWarning object is available, print its
// warning(s). There may be multiple warnings chained.

SQLWarning warn = conn . getWarnings ();
while while ( warn != null null ) {

System . out . println ( "SQLState: " + warn . getSQLState ());