This section describes how to create connection objects with the DataSource class.
It is recommended now that connection objects are created by the DataSource implementation class,
sun.jdbc.odbc.ee.DataSource.
Here is a sample program that creates a connection object using the DataSource class without using JNDI services:
/**
* OdbcAccessDataSource.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OdbcAccessDataSource {
public static void main(String [] args) {
Connection con = null;
try {
// Setting up the DataSource object
sun.jdbc.odbc.ee.DataSource ds
= new sun.jdbc.odbc.ee.DataSource();
ds.setDatabaseName("HY_ACCESS");
// Getting a connection object
con = ds.getConnection();
// Getting database info
DatabaseMetaData meta = con.getMetaData();
System.out.println("Server name: "
+ meta.getDatabaseProductName());
System.out.println("Server version: "
+ meta.getDatabaseProductVersion());
// Closing the connection
con.close();
} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}
The output confirms that I got a good connection with the DataSource implementation class.
But I also got 2 warnings that implementation class is Sun's experimenting implementation.
It could be removed in the future.
C:\>javac OdbcAccessDataSource.java
OdbcAccessDataSource.java:12:
warning: sun.jdbc.odbc.ee.DataSource is Sun proprietary API
and may be removed in a future release
sun.jdbc.odbc.ee.DataSource ds
^
OdbcAccessDataSource.java:13:
warning: sun.jdbc.odbc.ee.DataSource is Sun proprietary API
and may be removed in a future release
= new sun.jdbc.odbc.ee.DataSource();
^
2 warnings
C:\>java OdbcAccessDataSource
Server name: ACCESS
Server version: 04.00.0000
