• 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

SQLServer thindriver for Tomcat5.0

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In tomcat5.0 server.xml file we have thindriver for oracle,My-sql but we dont have for SQLServer from where I got thin driver and how to configure that driver in server.xml as well as in source code for Database connectivity with same thin sqlserver driver
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You can get a MS SQL Server thin Driver here, or you can use the Sun JDBC Driver search to find other Drivers.
You don't need to make any changes to the server.xml, you just need to change the class loaded in your Class.forName() line to the MS Driver, change the dtabaase URL to refer to your database, and place the JDBC JARs in the WEB-INF/lib directory for the web application.
Any JDBC sample code will show you how to connect, you just have to change the two parts listed above.
Dave
 
Ranch Hand
Posts: 15304
6
Mac OS X IntelliJ IDE Chrome
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
FYI - MS SQL JDBC Driver only supports the JDBC 2.0 spec. So be careful when you code.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I believe there are other Type-4 SQL Server Drivers (two that I've heard of, none that I've used), check the Driver search page.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic