• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Doubt on using third party driver?

 
dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,


i have always been using JdbcOdbc bridge driver in my
applications,but this time i want to learn something new
by using third party driver in my database application,since there are

Type1
Type2
Type3
Type4


drivers avaliable

but i dont have any idea on how can i proceed with it
as per my knowledge, in order to use any third party
driver i have to download it first
.

One more doubt i have is..... based on the Types of drivers mentioned above does the database also change from Sql to Oracle to MySql

But how to make it work i my application i mean where i must place the jar file and later access the i.e load driver in my application.

too many doubts in one post i am sorry for it

But if anyone could ellaborate and explain
on drivers it will be realy helpful

Thanks in advance..........

Dhwani:>Winning is not important but it is the only thing.
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
as per my knowledge, in order to use any third party driver i have to download it first

Correct. You can generally get JDBC drivers in the same place where you got the database itself. If you can't find it there, google for "download jdbc driver <<<insert name of your database>>>".

based on the Types of drivers mentioned above does the database also change from Sql to Oracle to MySql

The types of drivers are independent of the DB used. The most commonly used type is type 4; if that's available, look no further.

But how to make it work i my application i mean where i must place the jar file and later access the i.e load driver in my application.

Like any other jar file, it needs to be in the classpath both during compilation and during runtime. Example code of how to use the driver can usually be found in the driver documentation. It's pretty much the same for all of them.
 
dhwani mathur
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Sorry for my late response

but thanks a bunch for such a good
explanation



Dhwani:>Winning is not important but it is the only thing.
[ April 03, 2008: Message edited by: dhwani mathur ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic