tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Marcum <>
Subject Re: Seeking the right solution to java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Date Fri, 24 Jul 2009 00:21:33 GMT

Following its_toasted's recipes I have successfully implemented, successively, both Tomcat
managed Database pooling and Hibernate Managed Database pooling.

I did have a couple of issues to fix when implementing Hibernate managed pooling:
1) Order of entries into the xml.  I first simply appended the database connection and pooling
properties to my existing hibernate,cfg.xml.  Wrong!  The "mapping" element must come AFTER
the property elements to conform to the dtd.
2) I had to comment out the datasource property for the configuration to work.  Its-toated
referred to this porblem in the context of Tomcat managed pooling, but I had no problem with
it there.  I did have problems with that issue when configuring the Hibernate managed pooling.
 I have included here the hibernate.cfg.xml that works for me.  Note the datasource property
commented out.



    <property name="connection.datasource">java:comp/env/jdbc/CSRapp</property>
    <property name="show.sql">false</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

    <!-- Database connection information -->
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.url">jdbc:mysql://localhost:3306/CSRapp</property>
    <property name="connection.username">CSRapp</property>
    <property name="connection.password">CSRapp</property>

    <!-- Connection pool parameters -->
    <property name="connection_provider_class">org.hibernate.connection.CP30ConnectionProvider</property>
    <property name="c3p0.minPoolSize">4</property>
    <property name="c3p0.timeout">5000</property>

    <!-- Mapping files -->
    <mapping resource="org/bcs/server/utils/ServiceProvider.hbm.xml"/>



Wanting my database configuration tightly coupled to my application, the Hibernate managed
approach works best for me.

Thank you all for a great job and great help.

Caldarale, Charles R wrote:
>>From: []
>>Subject: Re: Seeking the right solution to
>>java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
>>PS - I just hacked together the Hibernate-controlled database
>>connection / pooling on a freshly installed Tomcat 6.0.20.
>>It works as advertised.
> A very comprehensive and useful writeup; thanks.  Please consider adding the Hibernate-controlled
pooling description to the Tomcat FAQ/Wiki Database section - or at least a pointer to the
relevant Hibernate doc.
>  - Chuck
is thus for use only by the intended recipient. If you received this in error, please contact
the sender and delete the e-mail and its attachments from all computers.
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message