• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Doubt on using third party driver?

 
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
On top of spaghetti all covered in cheese, there was this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic