Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc type 2 driver for sql server

 
chain singh
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

i want to connect my web application to sql server 2008
server is on my local system so please tell me its type 2 driver and class path

thank you
chain singh
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
why do you want a type 2 driver?

After reading the wiki page on type 2 drivers and it's list of advantages and disadvantages

Advantages

  • As there is no implementation of jdbc-odbc bridge, its considerably faster than a type 1 driver.


  • Disadvantages

  • The vendor client library needs to be installed on the client machine.
  • Not all databases have a client side library
  • This driver is platform dependent
  • This driver supports all java applications except Applets




  • You will need to tell us the exact platform and version of the db you are working on (in case there are sub versions of 2008)
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic