multiple jdbc drivers

Is it possible to use multiple jdbc drivers at a same time in my application?

Use 2 or more Connection.

You mean

Drivermanager.registerDriver(new driver1);
connection con1 DriverManager.getConnection(...);

Drivermanager.registerDriver(new driver2);
connection con2 DriverManager.getConnection(...);

Yes. Something like

Code:

---

import java.sql.*;

public class test{
        public static void main(String[] args){
                Connection cn1;
                Connection cn2;
                try{
                        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                        String url="jdbc:microsoft:sqlserver://localhost:1433;database=northwind";
                        cn1=DriverManager.getConnection(url,"sa","password");                       

                        Statement s1=cn1.createStatement();
                        ResultSet rs1=s1.executeQuery("use northwind select * from categories");
                        while(rs1.next()){
                                System.out.println(rs1.getString(2));
                        }

                        System.out.println("\n\n");

                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        String filename="D:/ian/projects/database/northwind.mdb";
                        String database="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
                        database+=filename.trim()+";DriverID=22;READONLY=true}";
                        cn2=DriverManager.getConnection(database,"","");                       

                        Statement s2=cn2.createStatement();
                        ResultSet rs2=s2.executeQuery("select * from employees");
                        while(rs2.next()){
                                System.out.println(rs2.getString(2));
                        }
                }
                catch(Exception ex){
                        ex.printStackTrace();
                }
        }
}

---

Thanks a lot.