Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-09-24
1
Medium Priority
?
1,695 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

661 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