tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mehdi.Ne...@bluewave.com
Subject Re: MySQL Hell
Date Wed, 22 Jan 2003 16:02:27 GMT

Thanks for your advice on which groups to try Barney - it was very useful
to someone out there...

jason, that worked - all I had to do was put the classes and jars in
~/common/classes and common/lib respectively

Many thanks,

Med




                                                                                         
                             
                      "mwm"                                                              
                             
                      <tomcatuserlist@ward-mu        To:       "Tomcat Users List" <tomcat-user@jakarta.apache.org>
   
                      rphy.co.uk>                    cc:                              
                                
                                                     Subject:  Re: MySQL Hell            
                             
                      22/01/2003 15:28                                                   
                             
                      Please respond to                                                  
                             
                      "Tomcat Users List"                                                
                             
                                                                                         
                             
                                                                                         
                             




Not really related, but I thought I'd mention that the driver has been
renamed to com.mysql.jdbc.Driver.
(The one you're using remains as a wrapper for backwards compatibility.)

Mike.


----- Original Message -----
From: "Jason Pyeron" <jason@pyeron.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Sent: Wednesday, January 22, 2003 3:23 PM
Subject: RE: MySQL Hell


We have encountered strange results when drivers are loaded in the WEB-INF
folders

we reccommend having the sysadmin putting them in the
TOMCAT_HOME/common/lib folder

-jason pyeron


On Wed, 22 Jan 2003, Barney Hamish wrote:

I'd suggest looking at the comments in the examples for DBCP about how the
examples need to be run. The required JDBC driver needs to be pre-loaded
for
it to work.

If you have any further questions you should probably send them to the
commons mailing list.

Hamish

> -----Original Message-----
> From: Mehdi.Nejad@bluewave.com [mailto:Mehdi.Nejad@bluewave.com]
> Sent: Wednesday, January 22, 2003 4:14 PM
> To: Tomcat Users List
> Subject: MySQL Hell
>
>
>
> Hello all,
>
> i have been breaking my brain trying to get connection pooling, using
> Tomcat 4.1.12's build in dbcp, with mySQL 3.23.
>
> I have followed the instructions on the how this should be
> done, and I am
> getting an exception when I try to get a connection .. (like
> many other
> people it seems)..  If anyone has solved this problem.. or
> has a link to a
> forum where this problem is answered please let me know..
>
> I have downloaded mysql-connector-java-2.0.14.zip
>
> I unzipped it and copied :
> *  the contents of WEB-INF/lib to my lib folder
> * contents of com to my WEB-INF/classes folder
> * contents of org to my WEB-INF/classes folder (this *does* contain
> org.gjt.mm.mysql.Driver)
>
> This does not work.  My jsp test code follows, and the
> Exception occurs on
> getConnection()...
>
> <%@ page language="java" import="java.sql.*, javax.sql.*,
> javax.naming.*"
> errorPage="error.jsp" %>
>
> <%
>       Context initContext = new InitialContext();
>       Context envContext  =
> (Context)initContext.lookup("java:/comp/env");
>       DataSource ds = (DataSource)envContext.lookup("jdbc/mehdi");
>       Connection conn = ds.getConnection();
>
> %>
>
> Exception is
>
> java.sql.SQLException: Cannot load JDBC driver class
> 'org.gjt.mm.mysql.Driver'
>
> SERVER.XML
>
>         <Context path="/mysql" docBase="mysql" debug="0"
> reloadable="true">
>
>  <Logger className="org.apache.catalina.logger.FileLogger"
>              prefix="localhost_DBTest_log." suffix=".txt"
>              timestamp="true"/>
>
>   <Resource name="jdbc/mehdi"
>                auth="Container"
>                type="javax.sql.DataSource"/>
>
>   <ResourceParams name="jdbc/mehdi">
>     <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 0 for no limit.
>          -->
>     <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>mehdi</value>
>     </parameter>
>     <parameter>
>      <name>password</name>
>      <value>mypass</value>
>     </parameter>
>
>     <!-- Class name for mm.mysql JDBC driver -->
>     <parameter>
>        <name>driverClassName</name>
>        <value>org.gjt.mm.mysql.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/mehdi?autoReconnect=true</value>
>     </parameter>
>   </ResourceParams>
>
>         </Context>
>
>
> running out of time, and hair.
>
> Thanks,
>
> Med
>
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:tomcat-user-help@jakarta.apache.org>

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


--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Owner & Lead                  Pyerotechnics Development, Inc. -
- +1 410 808 6646 (c)           500 West University Parkway #1S -
- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately.  Any other use of the email by you
is prohibited.




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




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






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


Mime
View raw message