You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Craig Dixon <di...@gmail.com> on 2005/07/08 23:00:28 UTC
Datasource works in Tomcat 5.5.4 but not 5.5.9
I am encountering a very strange problem when trying to use a
datasource in Tomcat. I got Tomcat 5.5.4 to access the datasource by
using the following in
<TomcatHome>\conf\Catalina\localhost\<webAppContext>.xml
<Context path="/appName" docBase="appName"
debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/RDM" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="*hidden*" password="*hidden*"
driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:RDM_CURRENT_11"/>
</Context>
I use this in conjunction with the following in
<TomcatHome>\webapps\<appName>\WEB-INF\web.xml:
<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app 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"
version="2.4">
<resource-ref>
<description>RDM</description>
<res-ref-name>jdbc/RDM</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
This works like a dream.
I tried upgrading to Tomcat 5.5.9. I downloaded and installed the
admin add-on application, then added the datasource via the admin
interface as follows:
JNDI Name: RDM
Datasource URL: jdbc:odbc:RDM_CURRENT_11
JDBC Driver Class: sun.jdbc.odbc.JdbcOdbcDriver
Username: *hidden*
Password: *hidden*
MaxActiveConnections: 100
MaxIdleConnections: 30
MaxWaitForConnection: 10000
Validation Query:
Now I get the following error:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented
it from fulfilling this request.
exception
javax.servlet.ServletException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create PoolableConnectionFactory ([Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.)"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.gradprofile_jsp._jspService(org.apache.jsp.gradprofile_jsp:171)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
javax.servlet.jsp.JspException: Unable to get connection, DataSource
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
create PoolableConnectionFactory ([Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.)"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
org.apache.jsp.gradprofile_jsp._jspx_meth_sql_query_0(org.apache.jsp.gradprofile_jsp:190)
org.apache.jsp.gradprofile_jsp._jspService(org.apache.jsp.gradprofile_jsp:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache
Tomcat/5.5.9 logs.
Apache Tomcat/5.5.9
I still have 5.5.4 installed, and when I switch back to it, everything
works fine. I'd like to work in the most current version, though.
Anyone have any ideas about this?
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Datasource works in Tomcat 5.5.4 but not 5.5.9
Posted by Craig Dixon <di...@gmail.com>.
After some more testing, I have determined that I can remove the user
name and password from context.xml in Tomcat 5.5.4, and it still
works. Removing the entire Resource tag, however, causes it to crash
out, as it should. This means that Tomcat 5.5.4 needs the connection
information in context.xml, but authenticates from elsewhere, probably
Active Directory, since I have to log on to my desktop workstation via
Active Directory.
Any idea why 5.5.9 will not authenticate this way, or more
importantly, how to cause it to authenticate this way?
On 7/8/05, Craig Dixon <di...@gmail.com> wrote:
> I am encountering a very strange problem when trying to use a
> datasource in Tomcat. I got Tomcat 5.5.4 to access the datasource by
> using the following in
> <TomcatHome>\conf\Catalina\localhost\<webAppContext>.xml
>
> <Context path="/appName" docBase="appName"
> debug="5" reloadable="true" crossContext="true">
>
> <Resource name="jdbc/RDM" auth="Container" type="javax.sql.DataSource"
> maxActive="100" maxIdle="30" maxWait="10000"
> username="*hidden*" password="*hidden*"
> driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
> url="jdbc:odbc:RDM_CURRENT_11"/>
>
> </Context>
>
>
>
> I use this in conjunction with the following in
> <TomcatHome>\webapps\<appName>\WEB-INF\web.xml:
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <web-app 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"
> version="2.4">
>
> <resource-ref>
> <description>RDM</description>
> <res-ref-name>jdbc/RDM</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> </web-app>
>
>
>
> This works like a dream.
>
> I tried upgrading to Tomcat 5.5.9. I downloaded and installed the
> admin add-on application, then added the datasource via the admin
> interface as follows:
>
> JNDI Name: RDM
> Datasource URL: jdbc:odbc:RDM_CURRENT_11
> JDBC Driver Class: sun.jdbc.odbc.JdbcOdbcDriver
> Username: *hidden*
> Password: *hidden*
> MaxActiveConnections: 100
> MaxIdleConnections: 30
> MaxWaitForConnection: 10000
> Validation Query:
>
> Now I get the following error:
>
> HTTP Status 500 -
>
> type Exception report
>
> message
>
> description The server encountered an internal error () that prevented
> it from fulfilling this request.
>
> exception
>
> javax.servlet.ServletException: Unable to get connection, DataSource
> invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> create PoolableConnectionFactory ([Microsoft][ODBC SQL Server
> Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.)"
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
> org.apache.jsp.gradprofile_jsp._jspService(org.apache.jsp.gradprofile_jsp:171)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> root cause
>
> javax.servlet.jsp.JspException: Unable to get connection, DataSource
> invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot
> create PoolableConnectionFactory ([Microsoft][ODBC SQL Server
> Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.)"
> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
> org.apache.jsp.gradprofile_jsp._jspx_meth_sql_query_0(org.apache.jsp.gradprofile_jsp:190)
> org.apache.jsp.gradprofile_jsp._jspService(org.apache.jsp.gradprofile_jsp:80)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> note The full stack trace of the root cause is available in the Apache
> Tomcat/5.5.9 logs.
> Apache Tomcat/5.5.9
>
>
>
> I still have 5.5.4 installed, and when I switch back to it, everything
> works fine. I'd like to work in the most current version, though.
> Anyone have any ideas about this?
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org