You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Denny Lee <de...@yahoo.com> on 2005/03/01 18:26:00 UTC

Tomcat and IIS Authorization

Hello All,
I am creating a web app that has users and admins and
I need to limit certain configuration pages only to
admins.  I must use NTLM to authenticate users into
the web site and somehow get the credential to
determine if the user has sufficient access or not. 
How can I do this? Can I do this through IIS?  So far
I got authentication part working using jcfis but I
can't seem to get the role of the user.  I tried
tagish JAAS but keep getting missing LoginModule
error.  Any help would be great. Thanks.

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Darryl Wagoner <da...@mason-nh.net>.
 >Sounds like it can't find the driver.  Do you have the Connector/J jar 
installed in the correct place?  Should be in common/lib.


I think so!  I have 
$CATALINA/common/lib/mysql-connector-java-3.0.16-ga-bin.jar which I 
believe to be the correct.

I just downloaded and installed 3.1 with same result.

thanks

-- 
Darryl Wagoner - WA1GON

"Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]

Join the TrustedQSL mailing list.  An Open Source solution.
Post message: TrustedQSL@yahoogroups.com Subscribe:  TrustedQSL-subscribe@yahoogroups.com List owner:  TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Justin Crabtree <cr...@otc.edu>.
Parsons Technical Services wrote:
> Resource Link
> 
> http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/globalresources.html
> 
> http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html#Resource%20Links 
> 
> 
> Doug
> 
> 
> ----- Original Message ----- From: "Darryl Wagoner" 
> <da...@mason-nh.net>
> To: "Tomcat Users List" <to...@jakarta.apache.org>
> Sent: Tuesday, March 01, 2005 5:09 PM
> Subject: newbie having problems with MySQL JDBC/JNDI Datasource example
> 
> 
>> Greetings,
>>
>> Not sure if this made it the first time.  I didn't see it show up on 
>> the list
>>
>> I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work 
>> and I am missing something.
>>
>> I get this error:  My webapp directory is /DBTest.
>>
>> What am I missing?
>>
>> thanks
>>
>> -darryl
>>
>>
>> --- Error Page ---
>>
>> *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 JDBC driver of class '' for connect URL 'null'"
>> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845) 
>>
>> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778) 
>>
>> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) 
>>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
>> 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 JDBC driver of class '' for connect URL 'null'"
>> 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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100) 
>>
>> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) 
>>
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>>
>>

Sounds like it can't find the driver.  Do you have the Connector/J jar 
installed in the correct place?  Should be in common/lib.


-- 
Justin Crabtree
Java Programmer
Ozarks Technical Community College
447-7533



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Parsons Technical Services <pa...@earthlink.net>.
Resource Link

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/globalresources.html

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/context.html#Resource%20Links

Doug


----- Original Message ----- 
From: "Darryl Wagoner" <da...@mason-nh.net>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Tuesday, March 01, 2005 5:09 PM
Subject: newbie having problems with MySQL JDBC/JNDI Datasource example


> Greetings,
>
> Not sure if this made it the first time.  I didn't see it show up on the 
> list
>
> I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and I 
> am missing something.
>
> I get this error:  My webapp directory is /DBTest.
>
> What am I missing?
>
> thanks
>
> -darryl
>
>
> --- Error Page ---
>
> *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 
> JDBC driver of class '' for connect URL 'null'"
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> 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 
> JDBC driver of class '' for connect URL 'null'"
> 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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
>
> --- Server.xml ---
> <?xml version='1.0' encoding='utf-8'?>
> <!-- $Id$ -->
> <Server>
>
>  <Listener 
> className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
>  <Listener 
> className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
> er"/>
>  <GlobalNamingResources>
>    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
>    <Resource auth="Container" description="User database that can be 
> updated an
> d saved"
>    name="UserDatabase" type="org.apache.catalina.UserDatabase"
>    pathname="conf/tomcat-users.xml" 
> factory="org.apache.catalina.users.MemoryUs
> erDatabaseFactory"/>
>
>  </GlobalNamingResources>
>
>  <Service name="Catalina">
>    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
> maxThreads="150" minSpareThreads="25">
>    </Connector>
>    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
>    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
> minSpareThreads="25">
>    </Connector>
>    <Connector port="8009" protocol="AJP/1.3"
>    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
> redirectPort="8443">
>    </Connector>
>
>    <Engine defaultHost="localhost" name="Catalina">
>      <Host appBase="webapps" name="localhost">
>      <Context path="/DBTest" docBase="DBTest" debug="5">
>      reloadable="true" crossContext="true">
>          <Resource name="TestDB" type="javax.sql.DataSource" 
> password="javadude"
>          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
> maxWait="5000" username="javauser"
>          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
>          maxActive="4"/>
>      </Context>
>
>
> --- web.xml ---
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <!DOCTYPE web-app
>    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
>    "http://java.sun.com/dtd/web-app_2_3.dtd">
>
>
> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" 
> xmlns:xsi="http://www.w3.org/20
> 01/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">
>  <description>MySQL Test App</description>
>  <resource-ref>
>      <description>DB Connection</description>
>      <res-ref-name>jdbc/TestDB</res-ref-name>
>      <res-type>javax.sql.DataSource</res-type>
>      <res-auth>Container</res-auth>
>  </resource-ref>
> </web-app>
>
>
> -- 
> Darryl Wagoner - WA1GON
>
> "Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]
>
> Join the TrustedQSL mailing list.  An Open Source solution.
> Post message: TrustedQSL@yahoogroups.com Subscribe: 
> TrustedQSL-subscribe@yahoogroups.com List owner: 
> TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by David Smith <dn...@cornell.edu>.
No problem.  Amazing what an extra set of eyes will catch, isn't it?

Enjoy!
David

Darryl Wagoner wrote:

> David,
>
> I have been looking at this off and on for weeks and could not see the 
> problem.  I changed the context to
> be jdbc/TestDB and it worked.
>
> Thank you very much!!!!
>
> David Smith wrote:
>
>> In your context definition, you have <Resource name="TestDB"......
>>
>> In your web.xml, you have <res-ref-name>jdbc/TestDB</res-ref-name>
>>
>> These two need to match.  If one is jdbc/TestDB, so must the other.
>>
>> --David
>>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Darryl Wagoner <da...@mason-nh.net>.
David,

I have been looking at this off and on for weeks and could not see the 
problem.  I changed the context to
be jdbc/TestDB and it worked.

Thank you very much!!!!

David Smith wrote:

> In your context definition, you have <Resource name="TestDB"......
>
> In your web.xml, you have <res-ref-name>jdbc/TestDB</res-ref-name>
>
> These two need to match.  If one is jdbc/TestDB, so must the other.
>
> --David
>


-- 
Darryl Wagoner - WA1GON

"Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]

Join the TrustedQSL mailing list.  An Open Source solution.
Post message: TrustedQSL@yahoogroups.com Subscribe:  TrustedQSL-subscribe@yahoogroups.com List owner:  TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by David Smith <dn...@cornell.edu>.
In your context definition, you have <Resource name="TestDB"......

In your web.xml, you have <res-ref-name>jdbc/TestDB</res-ref-name>

These two need to match.  If one is jdbc/TestDB, so must the other.

--David


Darryl Wagoner wrote:

> Greetings,
>
> Not sure if this made it the first time.  I didn't see it show up on 
> the list
>
> I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work 
> and I am missing something.
>
> I get this error:  My webapp directory is /DBTest.
>
> What am I missing?
>
> thanks
>
> -darryl
>
>
> --- Error Page ---
>
> *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 JDBC driver of class '' for connect URL 'null'"
>     org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845) 
>
>     org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778) 
>
>     org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
>     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) 
>
>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) 
>
>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
>     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 JDBC driver of class '' for connect URL 'null'"
>     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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100) 
>
>     org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
>     org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
>     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>     org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325) 
>
>     org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) 
>
>     org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
>     javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
>
> --- Server.xml ---
> <?xml version='1.0' encoding='utf-8'?>
> <!-- $Id$ -->
> <Server>
>
>  <Listener 
> className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
>  <Listener 
> className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
> er"/>
>  <GlobalNamingResources>
>    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
>    <Resource auth="Container" description="User database that can be 
> updated an
> d saved"
>    name="UserDatabase" type="org.apache.catalina.UserDatabase"
>    pathname="conf/tomcat-users.xml" 
> factory="org.apache.catalina.users.MemoryUs
> erDatabaseFactory"/>
>
>  </GlobalNamingResources>
>
>  <Service name="Catalina">
>    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
> maxThreads="150" minSpareThreads="25">
>    </Connector>
>    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
>    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
> minSpareThreads="25">
>    </Connector>
>    <Connector port="8009" protocol="AJP/1.3"
>    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
> redirectPort="8443">
>    </Connector>
>
>    <Engine defaultHost="localhost" name="Catalina">
>      <Host appBase="webapps" name="localhost">
>      <Context path="/DBTest" docBase="DBTest" debug="5">
>      reloadable="true" crossContext="true">
>          <Resource name="TestDB" type="javax.sql.DataSource" 
> password="javadude"
>          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
> maxWait="5000" username="javauser"
>          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
>          maxActive="4"/>
>      </Context>
>
>
> --- web.xml ---
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <!DOCTYPE web-app
>    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
>    "http://java.sun.com/dtd/web-app_2_3.dtd">
>
>
> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" 
> xmlns:xsi="http://www.w3.org/20
> 01/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">
>  <description>MySQL Test App</description>
>  <resource-ref>
>      <description>DB Connection</description>
>      <res-ref-name>jdbc/TestDB</res-ref-name>
>      <res-type>javax.sql.DataSource</res-type>
>      <res-auth>Container</res-auth>
>  </resource-ref>
> </web-app>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Drew Jorgenson <de...@omniplatform.com>.
Woops, my bad, that's not it, I should have read the entire message :(

Drew.

On Tue, 2005-03-01 at 18:51, Drew Jorgenson wrote:
> javax.servlet.ServletException: Unable to get connection, DataSource 
> invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create 
> JDBC driver of class '' for connect URL 'null'"
> 
> what is your connection URL? it doesn't seem like you're supplying one
> to the driver. If you're passing it as a string, make sure it's not
> null.
> 
> Drew.
> 
> On Tue, 2005-03-01 at 17:31, Parsons Technical Services wrote:
> > What version are you running of Tomcat?
> > 
> > Did you put in your resource link?
> > 
> > Doug
> > 
> > 
> > ----- Original Message ----- 
> > From: "Darryl Wagoner" <da...@mason-nh.net>
> > To: "Tomcat Users List" <to...@jakarta.apache.org>
> > Sent: Tuesday, March 01, 2005 5:09 PM
> > Subject: newbie having problems with MySQL JDBC/JNDI Datasource example
> > 
> > 
> > > Greetings,
> > >
> > > Not sure if this made it the first time.  I didn't see it show up on the 
> > > list
> > >
> > > I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and I 
> > > am missing something.
> > >
> > > I get this error:  My webapp directory is /DBTest.
> > >
> > > What am I missing?
> > >
> > > thanks
> > >
> > > -darryl
> > >
> > >
> > > --- Error Page ---
> > >
> > > *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 
> > > JDBC driver of class '' for connect URL 'null'"
> > > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
> > > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
> > > org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
> > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> > > 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 
> > > JDBC driver of class '' for connect URL 'null'"
> > > 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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
> > > org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
> > > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> > > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> > > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > >
> > >
> > > --- Server.xml ---
> > > <?xml version='1.0' encoding='utf-8'?>
> > > <!-- $Id$ -->
> > > <Server>
> > >
> > >  <Listener 
> > > className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
> > >  <Listener 
> > > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
> > > er"/>
> > >  <GlobalNamingResources>
> > >    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
> > >    <Resource auth="Container" description="User database that can be 
> > > updated an
> > > d saved"
> > >    name="UserDatabase" type="org.apache.catalina.UserDatabase"
> > >    pathname="conf/tomcat-users.xml" 
> > > factory="org.apache.catalina.users.MemoryUs
> > > erDatabaseFactory"/>
> > >
> > >  </GlobalNamingResources>
> > >
> > >  <Service name="Catalina">
> > >    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
> > > maxThreads="150" minSpareThreads="25">
> > >    </Connector>
> > >    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
> > >    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
> > > minSpareThreads="25">
> > >    </Connector>
> > >    <Connector port="8009" protocol="AJP/1.3"
> > >    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
> > > redirectPort="8443">
> > >    </Connector>
> > >
> > >    <Engine defaultHost="localhost" name="Catalina">
> > >      <Host appBase="webapps" name="localhost">
> > >      <Context path="/DBTest" docBase="DBTest" debug="5">
> > >      reloadable="true" crossContext="true">
> > >          <Resource name="TestDB" type="javax.sql.DataSource" 
> > > password="javadude"
> > >          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
> > > maxWait="5000" username="javauser"
> > >          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
> > >          maxActive="4"/>
> > >      </Context>
> > >
> > >
> > > --- web.xml ---
> > > <?xml version="1.0" encoding="ISO-8859-1"?>
> > >
> > > <!DOCTYPE web-app
> > >    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
> > >    "http://java.sun.com/dtd/web-app_2_3.dtd">
> > >
> > >
> > > <web-app xmlns="http://java.sun.com/xml/ns/j2ee"
> > > xmlns:xsi="http://www.w3.org/20
> > > 01/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">
> > >  <description>MySQL Test App</description>
> > >  <resource-ref>
> > >      <description>DB Connection</description>
> > >      <res-ref-name>jdbc/TestDB</res-ref-name>
> > >      <res-type>javax.sql.DataSource</res-type>
> > >      <res-auth>Container</res-auth>
> > >  </resource-ref>
> > > </web-app>
> > >
> > >
> > > -- 
> > > Darryl Wagoner - WA1GON
> > >
> > > "Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]
> > >
> > > Join the TrustedQSL mailing list.  An Open Source solution.
> > > Post message: TrustedQSL@yahoogroups.com Subscribe: 
> > > TrustedQSL-subscribe@yahoogroups.com List owner: 
> > > TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> > >
> > > 
> > 
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Drew Jorgenson <de...@omniplatform.com>.
javax.servlet.ServletException: Unable to get connection, DataSource 
invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create 
JDBC driver of class '' for connect URL 'null'"

what is your connection URL? it doesn't seem like you're supplying one
to the driver. If you're passing it as a string, make sure it's not
null.

Drew.

On Tue, 2005-03-01 at 17:31, Parsons Technical Services wrote:
> What version are you running of Tomcat?
> 
> Did you put in your resource link?
> 
> Doug
> 
> 
> ----- Original Message ----- 
> From: "Darryl Wagoner" <da...@mason-nh.net>
> To: "Tomcat Users List" <to...@jakarta.apache.org>
> Sent: Tuesday, March 01, 2005 5:09 PM
> Subject: newbie having problems with MySQL JDBC/JNDI Datasource example
> 
> 
> > Greetings,
> >
> > Not sure if this made it the first time.  I didn't see it show up on the 
> > list
> >
> > I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and I 
> > am missing something.
> >
> > I get this error:  My webapp directory is /DBTest.
> >
> > What am I missing?
> >
> > thanks
> >
> > -darryl
> >
> >
> > --- Error Page ---
> >
> > *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 
> > JDBC driver of class '' for connect URL 'null'"
> > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
> > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
> > org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> > 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 
> > JDBC driver of class '' for connect URL 'null'"
> > 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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
> > org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >
> > --- Server.xml ---
> > <?xml version='1.0' encoding='utf-8'?>
> > <!-- $Id$ -->
> > <Server>
> >
> >  <Listener 
> > className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
> >  <Listener 
> > className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
> > er"/>
> >  <GlobalNamingResources>
> >    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
> >    <Resource auth="Container" description="User database that can be 
> > updated an
> > d saved"
> >    name="UserDatabase" type="org.apache.catalina.UserDatabase"
> >    pathname="conf/tomcat-users.xml" 
> > factory="org.apache.catalina.users.MemoryUs
> > erDatabaseFactory"/>
> >
> >  </GlobalNamingResources>
> >
> >  <Service name="Catalina">
> >    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
> > maxThreads="150" minSpareThreads="25">
> >    </Connector>
> >    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
> >    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
> > minSpareThreads="25">
> >    </Connector>
> >    <Connector port="8009" protocol="AJP/1.3"
> >    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
> > redirectPort="8443">
> >    </Connector>
> >
> >    <Engine defaultHost="localhost" name="Catalina">
> >      <Host appBase="webapps" name="localhost">
> >      <Context path="/DBTest" docBase="DBTest" debug="5">
> >      reloadable="true" crossContext="true">
> >          <Resource name="TestDB" type="javax.sql.DataSource" 
> > password="javadude"
> >          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
> > maxWait="5000" username="javauser"
> >          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
> >          maxActive="4"/>
> >      </Context>
> >
> >
> > --- web.xml ---
> > <?xml version="1.0" encoding="ISO-8859-1"?>
> >
> > <!DOCTYPE web-app
> >    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
> >    "http://java.sun.com/dtd/web-app_2_3.dtd">
> >
> >
> > <web-app xmlns="http://java.sun.com/xml/ns/j2ee"
> > xmlns:xsi="http://www.w3.org/20
> > 01/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">
> >  <description>MySQL Test App</description>
> >  <resource-ref>
> >      <description>DB Connection</description>
> >      <res-ref-name>jdbc/TestDB</res-ref-name>
> >      <res-type>javax.sql.DataSource</res-type>
> >      <res-auth>Container</res-auth>
> >  </resource-ref>
> > </web-app>
> >
> >
> > -- 
> > Darryl Wagoner - WA1GON
> >
> > "Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]
> >
> > Join the TrustedQSL mailing list.  An Open Source solution.
> > Post message: TrustedQSL@yahoogroups.com Subscribe: 
> > TrustedQSL-subscribe@yahoogroups.com List owner: 
> > TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> > 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Re: newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Parsons Technical Services <pa...@earthlink.net>.
What version are you running of Tomcat?

Did you put in your resource link?

Doug


----- Original Message ----- 
From: "Darryl Wagoner" <da...@mason-nh.net>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Tuesday, March 01, 2005 5:09 PM
Subject: newbie having problems with MySQL JDBC/JNDI Datasource example


> Greetings,
>
> Not sure if this made it the first time.  I didn't see it show up on the 
> list
>
> I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and I 
> am missing something.
>
> I get this error:  My webapp directory is /DBTest.
>
> What am I missing?
>
> thanks
>
> -darryl
>
>
> --- Error Page ---
>
> *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 
> JDBC driver of class '' for connect URL 'null'"
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> 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 
> JDBC driver of class '' for connect URL 'null'"
> 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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
> org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
>
> --- Server.xml ---
> <?xml version='1.0' encoding='utf-8'?>
> <!-- $Id$ -->
> <Server>
>
>  <Listener 
> className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
>  <Listener 
> className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
> er"/>
>  <GlobalNamingResources>
>    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
>    <Resource auth="Container" description="User database that can be 
> updated an
> d saved"
>    name="UserDatabase" type="org.apache.catalina.UserDatabase"
>    pathname="conf/tomcat-users.xml" 
> factory="org.apache.catalina.users.MemoryUs
> erDatabaseFactory"/>
>
>  </GlobalNamingResources>
>
>  <Service name="Catalina">
>    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
> maxThreads="150" minSpareThreads="25">
>    </Connector>
>    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
>    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
> minSpareThreads="25">
>    </Connector>
>    <Connector port="8009" protocol="AJP/1.3"
>    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
> redirectPort="8443">
>    </Connector>
>
>    <Engine defaultHost="localhost" name="Catalina">
>      <Host appBase="webapps" name="localhost">
>      <Context path="/DBTest" docBase="DBTest" debug="5">
>      reloadable="true" crossContext="true">
>          <Resource name="TestDB" type="javax.sql.DataSource" 
> password="javadude"
>          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
> maxWait="5000" username="javauser"
>          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
>          maxActive="4"/>
>      </Context>
>
>
> --- web.xml ---
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <!DOCTYPE web-app
>    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
>    "http://java.sun.com/dtd/web-app_2_3.dtd">
>
>
> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" 
> xmlns:xsi="http://www.w3.org/20
> 01/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">
>  <description>MySQL Test App</description>
>  <resource-ref>
>      <description>DB Connection</description>
>      <res-ref-name>jdbc/TestDB</res-ref-name>
>      <res-type>javax.sql.DataSource</res-type>
>      <res-auth>Container</res-auth>
>  </resource-ref>
> </web-app>
>
>
> -- 
> Darryl Wagoner - WA1GON
>
> "Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]
>
> Join the TrustedQSL mailing list.  An Open Source solution.
> Post message: TrustedQSL@yahoogroups.com Subscribe: 
> TrustedQSL-subscribe@yahoogroups.com List owner: 
> TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


newbie having problems with MySQL JDBC/JNDI Datasource example

Posted by Darryl Wagoner <da...@mason-nh.net>.
Greetings,

Not sure if this made it the first time.  I didn't see it show up on the 
list

I am trying to get the example in the MySQL JDBC/JNDI HOWTO to work and 
I am missing something.

I get this error:  My webapp directory is /DBTest.

What am I missing?

thanks

-darryl


--- Error Page ---

*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 JDBC driver of class '' for connect URL 'null'"
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
	org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:81)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	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 JDBC driver of class '' for connect URL 'null'"
	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.testDB_jsp._jspx_meth_sql_query_0(org.apache.jsp.testDB_jsp:100)
	org.apache.jsp.testDB_jsp._jspService(org.apache.jsp.testDB_jsp:58)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


--- Server.xml ---
<?xml version='1.0' encoding='utf-8'?>
<!-- $Id$ -->
<Server>

  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
  <Listener 
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListen
er"/>
  <GlobalNamingResources>
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>
    <Resource auth="Container" description="User database that can be 
updated an
d saved"
    name="UserDatabase" type="org.apache.catalina.UserDatabase"
    pathname="conf/tomcat-users.xml" 
factory="org.apache.catalina.users.MemoryUs
erDatabaseFactory"/>

  </GlobalNamingResources>

  <Service name="Catalina">
    <Connector port="8080" redirectPort="8443" maxSpareThreads="75" 
maxThreads="150" minSpareThreads="25">
    </Connector>
    <Connector port="8081" proxyName="dax.shecora.com" proxyPort="80"
    redirectPort="8443" maxSpareThreads="75" maxThreads="150" 
minSpareThreads="25">
    </Connector>
    <Connector port="8009" protocol="AJP/1.3"
    protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" 
redirectPort="8443">
    </Connector>

    <Engine defaultHost="localhost" name="Catalina">
      <Host appBase="webapps" name="localhost">
      <Context path="/DBTest" docBase="DBTest" debug="5">
      reloadable="true" crossContext="true">
          <Resource name="TestDB" type="javax.sql.DataSource" 
password="javadude"
          driverClassName="com.mysql.jdbc.Driver" maxIdle="2" 
maxWait="5000" username="javauser"
          url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"
          maxActive="4"/>
      </Context>


--- web.xml ---
<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">


<web-app xmlns="http://java.sun.com/xml/ns/j2ee" 
xmlns:xsi="http://www.w3.org/20
01/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">
  <description>MySQL Test App</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/TestDB</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
</web-app>


-- 
Darryl Wagoner - WA1GON

"Evil triumphs when good men do nothing."  - Edmund Burke [1729-1797]

Join the TrustedQSL mailing list.  An Open Source solution.
Post message: TrustedQSL@yahoogroups.com Subscribe:  TrustedQSL-subscribe@yahoogroups.com List owner:  TrustedQSL-owner@yahoogroups.com http://www.trustedQSL.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Compatibility Package

Posted by Aron Beal <ab...@u.washington.edu>.
Hello Everyone,

I'm trying to work with the latest stable(5.5.7) tomcat on OSX.  Running 
the shutdown script gives me this message:

"This release of Apache Tomcat was packaged to run on J2SE 5.0
or later. It can be run on earlier JVMs by downloading and
installing a compatibility package from the Apache Tomcat
binary download page."

 From RUNNING.txt, I get this:

Download the compat package from the binary download site:
http://jakarta.apache.org/site/binindex.cgi

Going there, I can not find this package anywhere.  Googling will yield 
the API docs for the package, but as for the package itself, there is no 
sign.

As Java is not past 1.4.2 on OSX, upgrading the java install is not a 
possibility.

Would very much appreciate if someone could pass along a link.

Thanks in advance,
Aron

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org