Loading of JDBC Driver

[Riyaz.hk77]

Hi Can i use OracleDriver od= new oracleDriver(...) to load the driver manager class in static way instead of dynamic way of class.forName(...), please suggest:confused::confused:

[chyrl]

OracleDriver? What API are you using?
Anyways, the only JDBC I knew for oracle is similar to MySQL.
But instead of loading the MySQL library, you must load/import the oracle driver (*.jar files).

And with the static way. I don't about that.

Class.forName(driverName).newInstance();

This is the only way (In my terms, I haven't tried other ways yet).

Cyril H.

[JosAH]

what are the different ways to load driver manager class while using jdbc, plzzzzzzzzzzzzzz explain:confused:

It depends on the driver and its version. Old drivers had to be instantiated, e.g. new MyDriver(); and you had to register them at the DriverManager. Later on you just had to mention the class as in ClassForName("foo.bar.MyDriver") and the driver would load and register itself. Again a bit later the DriverManager took a more active role and would read the "jdbc.drivers" property for available drivers and preload them. Nowadays the DataSource is the big hype. Read all about it in its API documentation.

kind regards,

Jos

[Riyaz.hk77]

Thnx, i wantto import the oracle driver and load the driver class in a static way. how can i do that

[Fubarable]

OP, please knock off the multiposting. I've locked your other two threads and have moved JosAH's reply here.

[JosAH]

Thnx, i wantto import the oracle driver and load the driver class in a static way. how can i do that

Instantiate a driver with the Class.forName( ... ) trick and get a connection by asking the DriverManager.getConnection( ... ) call.

kind regards,

Jos

[Riyaz.hk77]

Hi Jos thnx, but what u have suggested is dynamic way of loading the driver and it works fine but still i m not cleared on my question. Can i load a driver like for example Myclass m1= new Myclass();

[Tolls]

You can use this to register the driver directly if you want:

DriverManager.registerDriver (new oracle.jdbc.OracleDriver());

That's the other technique, if you don't plan on changing the database behind your code.

[JosAH]

Hi Jos thnx, but what u have suggested is dynamic way of loading the driver and it works fine but still i m not cleared on my question. Can i load a driver like for example Myclass m1= new Myclass();

That depends on the Driver. Does it have a no args public constructor? Does it register itself in that constructor? You have to follow the way the driver wants to be instantiated; for all other methods you're on your own.

kind regards,

Jos

[Tolls]

That depends on the Driver. Does it have a no args public constructor? Does it register itself in that constructor? You have to follow the way the driver wants to be instantiated; for all other methods you're on your own.

kind regards,

Jos

The answer to that is, yes...it does have a no args constructor.

[JosAH]

The answer to that is, yes...it does have a no args constructor.

Well, then all we can hope for is that the driver registers itself somewhere in its public constructor code, otherwise that would be a driver for in the fire place ;-)

kind regards,

Jos

[Tolls]

Well, there are two recommended ways for registering it.
The Class.forName() one and the above one I posted (registerDriver()).

Which is no different to any other driver.
WHy someone wants to do "Driver d = new OracleDriver();" I have absolutely no idea. You gain nothing at all from that.