File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc type 2 driver for sql server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc type 2 driver for sql server" Watch "jdbc type 2 driver for sql server" New topic

jdbc type 2 driver for sql server

chain singh
Ranch Hand

Joined: Feb 28, 2012
Posts: 117

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

Joined: Oct 21, 2008
Posts: 1107

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


  • 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)
    I agree. Here's the link:
    subject: jdbc type 2 driver for sql server
    It's not a secret anymore!