Improve company productivity with a Business Account.Sign Up

x
?
Solved

JSP, Tomcat web.xml file for connection to a SQL Server 2000 Database.

Posted on 2004-09-24
1
Medium Priority
?
1,728 Views
Last Modified: 2010-05-18
Hi I have an issue with a web application that is currently running on Tomcat Server 5.0.27. I have this web.xml file that connects to the database and I need the proper syntax to add to the web.xml page.  This could be a question for SQL Server 2000, as well.
I have the 3 .jar files for the JDBC driver from Microsoft (msbase.jar, mssqlserver.jar, msutil.jar) and I had this connection working previously, but I lost the syntax somehow working back and fourth with Access and SQL.  
I have my JSP, and Servlets correctly put together, but I need the web.xml file to list the driver, name of the database, username, password, etc.  If someone knows the answer, please make sure it fits into this code from my web.xml file.  The name of the database is "Data9000SQL" that sits on MS SQL Server 2000. Again, I have all 3 .jar files, they are in the correct path, and I just need to change it from the access, which i have now, to the MS SQL Server 2000.

Here is my web.xml file code...................... I need to incorporate MS SQL Server 2k, instead of access which i already have.....

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
  <!-- JSPC servlet mappings start -->
  <servlet>
    <servlet-name>bah.arl.evaluations.servlet.SubmitServlet</servlet-name>
    <servlet-class>bah.arl.evaluations.servlet.SubmitServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>bah.arl.evaluations.servlet.SubmitServlet</servlet-name>
    <url-pattern>/evaluations.jsp</url-pattern>
  </servlet-mapping>

 <servlet>
    <servlet-name>bah.arl.evaluations.servlet.ResultServlet</servlet-name>
    <servlet-class>bah.arl.evaluations.servlet.ResultServlet</servlet-class>
  </servlet>
 <servlet-mapping>
    <servlet-name>bah.arl.evaluations.servlet.ResultServlet</servlet-name>
    <url-pattern>/results.jsp</url-pattern>
  </servlet-mapping>



  <description>


     Welcome to Evaluations
  </description>
  <display-name>Welcome to Evaluations</display-name>
  <!-- JSPC servlet mappings start -->
  <context-param>
    <param-name>abc</param-name>
    <param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>
  </context-param>
  <context-param>
    <param-name>dbName</param-name>
    <param-value>jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\projects\\evaluations\\db\\Data9000_Access</param-value>
  </context-param>
  <!-- JSPC servlet mappings end -->

</web-app>
0
Comment
Question by:apapanic
1 Comment
 
LVL 1

Accepted Solution

by:
matthew_york earned 1000 total points
ID: 12158628
Hi there, I've got a similar setup that i have configured along these lines, hope this helps:

// Tomcat  - server.xml

<Context docBase="App" path="/App" reloadable="true">
      <Resource auth="Container" name="jdbc/test" type="javax.sql.DataSource"/>
      <ResourceParams name="jdbc/test">
            <parameter>
                  <name>driverClassName</name>
                  <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
            </parameter>
            <parameter>
                  <name>url</name>
                  <value>jdbc:microsoft:sqlserver://locahost:1433</value>
            </parameter>
            <parameter>
                  <name>username</name>
                  <value>abc</value>
            </parameter>
            <parameter>
                  <name>password</name>
                  <value>def</value>
            </parameter>
            <parameter>
                  <name>databaseName</name>
                  <value>Data9000SQL</value>
            </parameter>
            <parameter>
                  <name>maxActive</name>
                  <value>100</value>
                  </parameter>
            <parameter>
                  <name>maxIdle</name>
                  <value>50</value>
            </parameter>
            <parameter>
                  <name>removeAbandoned</name>
                  <value>true</value>
            </parameter>
      </ResourceParams>
</Context>

// App - Application web.xml

<resource-ref>
      <res-ref-name>jdbc/test</res-ref-name>
      <res-type>javax.activation.DataSource</res-type>
      <res-auth>Container</res-auth>
      <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

One day, as you try to send an email from your SharePoint account, an error message appears saying: “E-mail Message Cannot be Sent.” You may have outgoing email settings misconfigured.
The most emerging queries of the user is to upload Outlook OST mailboxes to Office 365 account. So, here we will provide the manual as well as an automated solution for to transfer OST file to MS Office 365 in an absolute manner.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question