The Java Developers Almanac 1.4

Home > List of Packages > java.sql [73 examples] > Connections [10 examples]

e243. Getting the Driver of a Connection

Given a connection, it is not possible to determine the driver that created the connection. Although the connection can return a driver name, the returned name cannot be used to find the driver. For example,

    try {
        DatabaseMetaData dmd = connection.getMetaData();
        String driverName = dmd.getDriverName();  // Mark Matthew's MySQL Driver
    } catch (SQLException e) {
    }

The best you can do is to use the URL used to create the connection:

    try {
        // Create connection from URL
        Connection conn = DriverManager.getConnection(url, username, password);
    
        // Get driver from URL
        Driver driver = DriverManager.getDriver(url);
    } catch (SQLException e) {
    }

Related Examples

e235. Connecting to an Oracle Database
e236. Connecting to a MySQL Database
e237. Connecting to a SQLServer Database
e238. Listing All Available Parameters for Creating a JDBC Connection
e239. Determining If a Database Supports Transactions
e240. Committing and Rolling Back Updates to a Database
e241. Handling a SQL Exception
e242. Determining If a SQL Warning Occurred
e244. Setting the Number of Rows to Prefetch When Executing a SQL Query

See also: Batching Database Meta Data Deleting Data Drivers Importing and Exporting Inserting and Updating Data Oracle OBJECTs Oracle VARRAYs Procedures and Functions Retrieving Data Scrollable Result Sets Tables Updatable Result Sets

© 2002 Addison-Wesley.