Configuring an IDE w/2 JDBC Drivers

[Dale DeMott]

I'm working w/Eclipse and currently have in my "RUN" config [under the argument tab] the following line.

-Djdbc.drivers=oracle.jdbc.OracleDriver

This is great if I want to only run 1 database. I have 2 that I need to use. Does anyone know how I can cofigure my eclipse to accept 2 jdbc drivers for 2 databases?

TIA

[Scott Selikoff]

I believe the command line option you list is more of a convenience option than a requirement. You can leave it off altogether, add both jars to the classpath, and then in the code registrar which jdbc driver you want to use during runtime.

[Paul Sturrock]

That will work, assuming there is a driver for that url in your classpath.
[ January 18, 2007: Message edited by: Paul Sturrock ]

[Dale DeMott]

Here's what I'm trying...

DBConnectionUtil.regJDBCDriver("oracle.jdbc.OracleDriver");

Here's the method...

    public static void regJDBCDriver(String fullyQualifiedPathOfDriver) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{
        DriverManager.registerDriver((Driver)Class.forName(fullyQualifiedPathOfDriver).newInstance());
    }

The problem is that the class that I'm registering does NOT extend the Driver class that the driver manager wants it cast to.

Any suggestions?...