File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes more then one Drivers at once Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "more then one Drivers at once" Watch "more then one Drivers at once" New topic

more then one Drivers at once

Shrawan Bhageria
Ranch Hand

Joined: Jun 20, 2005
Posts: 52

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

Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
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

Joined: Dec 23, 2003
Posts: 28
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.

I agree. Here's the link:
subject: more then one Drivers at once
It's not a secret anymore!