tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Len Popp" <len.p...@gmail.com>
Subject Re: JNDI Datasource Problem
Date Sun, 19 Feb 2006 21:22:18 GMT
There is no ResourceParams in 5.5. Check the documentation again, and
make sure you're looking at the docs for 5.5 not 5.0.

--
Len

On 2/19/06, Mark Whitby <ug82msw@cs.bham.ac.uk> wrote:
> Yes I'm using version 5.5.15.  What I have in the server.xml file is what is
> advised in the Tomcat set up pages.  So would it make any difference
> removing one of these or as it's ignored does it not matter?
>
> Mark
>
> ----- Original Message -----
> From: "Bill Barker" <wbarker@wilshire.com>
> To: <users@tomcat.apache.org>
> Sent: Sunday, February 19, 2006 8:40 PM
> Subject: Re: JNDI Datasource Problem
>
>
> > Since you have <WatchedResources />, this suggests you are using some
> > version of 5.5.  In this case, the <ResourceParams /> is ignored (you set
> > them as attributes on the <Resource /> tag).
> >
> > "Mark Whitby" <ug82msw@cs.bham.ac.uk> wrote in message
> > news:008201c6358a$5cb91430$0201a8c0@MarksLaptop...
> >> I've done that and I now get the following error:
> >>
> >> org.apache.jasper.JasperException: Unable to get connection, DataSource
> >> invalid: "java.sql.SQLException: No suitable driver"
> >>
> >> This is what I have in my context.xml file:
> >>
> >> <!-- The contents of this file will be loaded for each web
> >> application -->
> >> <Context>
> >>
> >>    <!-- Default set of monitored resources -->
> >>    <WatchedResource>WEB-INF/web.xml</WatchedResource>
> >>
> >>    <!-- Uncomment this to disable session persistence across Tomcat
> >> restarts -->
> >>    <!--
> >>    <Manager pathname="" />
> >>    -->
> >>
> >> <ResourceLink
> >>            name="jdbc/TestDB"
> >>            global="jdbc/TestDB"
> >>            type="javax.sql.DataSource" auth="Container" />
> >>
> >>
> >> </Context>
> >>
> >>
> >> Any further suggestions?
> >>
> >> Mark
> >> ----- Original Message -----
> >> From: "Parsons Technical Services" <parsonstechnical@earthlink.net>
> >> To: "Tomcat Users List" <users@tomcat.apache.org>
> >> Sent: Sunday, February 19, 2006 7:02 PM
> >> Subject: Re: JNDI Datasource Problem
> >>
> >>
> >>> Look up resource link. It goes in the context.xml
> >>>
> >>> Also only put the jar file in the common/lib and no where else.
> >>>
> >>>
> >>> ----- Original Message -----
> >>> From: "Mark Whitby" <ug82msw@cs.bham.ac.uk>
> >>> To: "Tomcat Users List" <users@tomcat.apache.org>
> >>> Sent: Sunday, February 19, 2006 12:53 PM
> >>> Subject: JNDI Datasource Problem
> >>>
> >>>
> >>> Hey guys,
> >>>
> >>> Thanks for the help with the previous problem I had, I've managed to
> >>> solve them now thanks to your help.  But now I'm having a problem with
> >>> setting up a DataSource connection.  I've followed the example word for
> >>> word and got the following error:
> >>>
> >>> 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'"
> >>>
> >>> I did a google search for this but only managed to find something on the
> >>> NetBeans website which wasn't much help.  I've edited the server.xml
> >>> file as stated, placed the relevent jar file
> >>> (mysql-connector-java-3.1.12-bin.jar) in the lib folder in my web
> >>> application and in the /common/lib folder in the Tomcat home folder and
> >>> I've reset the server and I'm still getting the same problem.
> >>>
> >>> I'm using MySQL, database is called 'fyptest' and the table is called
> >>> 'testdata'.  So where am I going wrong?
> >>>
> >>> Many thanks
> >>>
> >>> Mark Whitby
> >>>
> >>> Server.xml file:
> >>>
> >>> <Context path="/DBTest" docBase="DBTest"
> >>>        debug="5" reloadable="true" crossContext="true">
> >>>
> >>>  <Logger className="org.apache.catalina.logger.FileLogger"
> >>>             prefix="localhost_DBTest_log." suffix=".txt"
> >>>             timestamp="true"/>
> >>>
> >>>  <Resource name="jdbc/TestDB"
> >>>               auth="Container"
> >>>               type="javax.sql.DataSource"/>
> >>>
> >>>  <ResourceParams name="jdbc/TestDB">
> >>>    <parameter>
> >>>      <name>factory</name>
> >>>      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> >>>    </parameter>
> >>>
> >>>    <!-- Maximum number of dB connections in pool. Make sure you
> >>>         configure your mysqld max_connections large enough to handle
> >>>         all of your db connections. Set to 0 for no limit.
> >>>         -->
> >>>    <parameter>
> >>>      <name>maxActive</name>
> >>>      <value>100</value>
> >>>    </parameter>
> >>>
> >>>    <!-- Maximum number of idle dB connections to retain in pool.
> >>>         Set to -1 for no limit.  See also the DBCP documentation on this
> >>>         and the minEvictableIdleTimeMillis configuration parameter.
> >>>         -->
> >>>    <parameter>
> >>>      <name>maxIdle</name>
> >>>      <value>30</value>
> >>>    </parameter>
> >>>
> >>>    <!-- Maximum time to wait for a dB connection to become available
> >>>         in ms, in this example 10 seconds. An Exception is thrown if
> >>>         this timeout is exceeded.  Set to -1 to wait indefinitely.
> >>>         -->
> >>>    <parameter>
> >>>      <name>maxWait</name>
> >>>      <value>10000</value>
> >>>    </parameter>
> >>>
> >>>    <!-- MySQL dB username and password for dB connections  -->
> >>>    <parameter>
> >>>     <name>username</name>
> >>>     <value>javauser</value>
> >>>    </parameter>
> >>>    <parameter>
> >>>     <name>password</name>
> >>>     <value>pilks2</value>
> >>>    </parameter>
> >>>
> >>>    <!-- Class name for the old mm.mysql JDBC driver - uncomment this
> >>> entry and comment next
> >>>         if you want to use this driver - we recommend using Connector/J
> >>> though
> >>>    <parameter>
> >>>       <name>driverClassName</name>
> >>>       <value>org.gjt.mm.mysql.Driver</value>
> >>>    </parameter>
> >>>     -->
> >>>
> >>>    <!-- Class name for the official MySQL Connector/J driver -->
> >>>    <parameter>
> >>>       <name>driverClassName</name>
> >>>       <value>com.mysql.jdbc.Driver</value>
> >>>    </parameter>
> >>>
> >>>    <!-- The JDBC connection url for connecting to your MySQL dB.
> >>>         The autoReconnect=true argument to the url makes sure that the
> >>>         mm.mysql JDBC Driver will automatically reconnect if mysqld
> >>> closed the
> >>>         connection.  mysqld by default closes idle connections after 8
> >>> hours.
> >>>         -->
> >>>    <parameter>
> >>>      <name>url</name>
> >>>
> >>> <value>jdbc:mysql://localhost:3306/fyptest?autoReconnect=true</value>
> >>>    </parameter>
> >>>  </ResourceParams>
> >>> </Context>
> >>>
> >>> web.xml file:
> >>>
> >>>  <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>
> >>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >>> For additional commands, e-mail: users-help@tomcat.apache.org
> >>>
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

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


Mime
View raw message