MS SQL TOMCAT CONNECTION POOLING

Discussions

Web tier: servlets, JSP, Web frameworks: MS SQL TOMCAT CONNECTION POOLING

  1. MS SQL TOMCAT CONNECTION POOLING (2 messages)

    I am currently trying to set up Tomcat 4.1 server to use connection pooling (jndi)to access a MS SQL 2000 database. I am able to successfully set up connection to Oracle database but I am not having any luck with MS SQL 2000. Could someone Please explain to me what I need to do to successfully set up and test the connection.

    Threaded Messages (2)

  2. MS SQL TOMCAT CONNECTION POOLING[ Go to top ]

    Get the JDBC driver from microsoft's site. look at the attached documentation for the exact url format. Worked for me before.

    David
  3. Thanks[ Go to top ]

    Thanks for the help. I have looked at the ms site, downloaded and installed the driver but I am still not able to get the connection to work. Do you know where I can obtain a sample server.xml file that has the connection ms sql setup already. I would like to look at the file to make sure what I am doing is correct. I believe my url setup might be the problem.
    Thanks