permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes programming with all JDBC Drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "programming with all JDBC Drivers" Watch "programming with all JDBC Drivers" New topic

programming with all JDBC Drivers

siva raman

Joined: Sep 15, 2003
Posts: 5
Hai programmers,
I would like to make database access using all 4 types of Java Drivers.
I normally use JDBCODBC Driver or vendor specific driver like OracleDriver.
But didn't even tried or know how to use Type2, Type3,Type4 drivers.
pl help me by giving the codes
thanking you,
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The whole point is that the code should be the same. The code to access the database and the database type should be independant. This is no longer true if you use database specific SQL, so try not to do that.
You only need to change two things and the rest should stay the same. Change the Class.forName() line to refer to the new Driver, and change the database URL to refer to the new Driver.
I agree. Here's the link:
subject: programming with all JDBC Drivers
It's not a secret anymore!