Name java:jdbc is not bound in this Context

[Hanna Habashy]

I am struggling with this error for many hours now.
Tomcat 7.0 inside Eclipse 3.6

Server.xml

   
<Context docBase="MyProject" path="/MyProject" reloadable="true" 
      			source="org.eclipse.jst.jee.server:MyProject">
      
      <Resource auth="Container" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
      			name="jdbc/MSSQLDataSource" password="MyProject" type="javax.sql.DataSource" 
      			url="jdbc:sqlserver://DEVDB01T;DatabaseName=MyProject" username="MyProject"/>
     </Context>

 

Web.xml

   
<resource-ref>
        <description>The DS</description>
        <res-ref-name>jdbc/MSSQLDataSource</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
 

I tried first on Eclipse Galileo and Tomcat 6.2, then I upgraded to Eclipse 3.6 and Tomcat 7.0. Same error.

Any help is greatly appreciated.

[Jeanne Boyarsky]

Is the error occuring on server startup or when you call the code to lookup the DataSource? If the later, are you using "java:comp/env/jdbc/MSSQLDataSource" as the name?

[Hanna Habashy]

Jeanne Boyarsky wrote:Is the error occuring on server startup or when you call the code to lookup the DataSource? If the later, are you using "java:comp/env/jdbc/MSSQLDataSource" as the name?

I get the error when I access the datasource. This is an old project that has been running for years. I am doing some maintinance on it, but I cannot deploy it locally.

[Jeanne Boyarsky]

Jeanne Boyarsky wrote: If the later, are you using "java:comp/env/jdbc/MSSQLDataSource" as the name?

How about this part of the question? When we upgraded the JavaRanch version of Tomcat, we were missing the "java:comp/env". Older versions of Tomcat didn't require it.