multiple jdbc drivers

[purusingh1]

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

[nebulom]

Use 2 or more Connection.

[purusingh1]

You mean

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

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

[nebulom]

Yes. Something like

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();
		}
	}
}

[purusingh1]

Thanks a lot.