• 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

Tomcat 7 connectivity with SqlServer 2008

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello everyone
I am stuck with a new problem.I want to use SQL SERVER 2008 as the database in my Servlet project but don't know how to configure it.Any type for connection may be useful either by a datasource or by Sql Server Driver .
kindly help !!!
 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

http://www.tutorialspoint.com/jdbc/jdbc-create-tables.htm

Check this out.

You need to have your relevant database jar in your class path.

and also you need to pass your relevant database url along with its user id and password.
 
Bartender
Posts: 2856
10
Firefox Browser Fedora Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Madhav, welcome to Javaranch

There is no configuration needed on the database side, except that it should be listening on a port where you connect it to.
 
Saloon Keeper
Posts: 27762
196
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The most challenging part of getting SQL Server talking to a Java webapp server like Tomcat is in configuring SQL server to listen on a tcp/ip port, since out of the box SQL server was using internal Windows communications channels. You'll also generally want to use "real" userids in SQL server and not simply defer identification to the Windows login security system.

On the client side, Microsoft's SQL server JDBC driver had problems handling with complex transactions at one time, so I learned to love the open-source SQL Server driver available from sourceforge.net. I believe that the Microsoft-supplied drivers have become more reliable in recent years, but there's comfort in knowing that trustworthy alternatives are available.
 
reply
    Bookmark Topic Watch Topic
  • New Topic