more then one Drivers at once

[Shrawan Bhageria]

HI ALL

Can we Load more then one Drivers at once?
if yes than pl. explain with example

thanks
shrawan

[Ulf Dittmer]

Yes, you can open connections to different databases using different drivers at the same time. I don't think an example is necessary; simple duplicate the code you use to connect to your database and change the parameters - done!

[Yilmaz Mete]

Class.forName() registers the forName()'s parameter class with the DriverManager once and only once; and these drivers map specific URLs onto themselves. "jdbc.drivers" system property contains them actually too.

Ex.

try
   {
// if URL is sth like [B]mysql:....[/B]==> MySQL Driver will be used
// if URL is sth like [B]oracle:....[/B]==> Oracle Driver will be used
// or write your own Driver which can connect to both RDBMS Systems by itself.
//But not that easy I assure you.
   String url = "";
   conn = DriverManager.getConnection(url);
   }
catch (SQLException e)
   {
   System.out.println("ERROR: failed to connect!");
   System.out.println("ERROR: " + e.getMessage());
   e.printStackTrace();
   return;
   }