Plea for help w/Struts-Hibernate Plugin that has it working!

[David Erickson]

For some reason I just cannot make the Struts-Hibernate plugin work.. I
can't make the Struts-Hibernate Listener work either.  Here is the link to
class I am trying to use:

http://www.hibernate.org/133.html

Here is the error I get without fail every time.. now note that this jndi
connection WORKS fine when I use the HibernateUtil class, or when I use my
own JDNI tests.

Error:
2003-12-16 17:10:31,452 [DEBUG] impl.SessionImpl - opened session
2003-12-16 17:10:31,468 [DEBUG] transaction.JDBCTransaction - begin
2003-12-16 17:10:31,484 [DEBUG] util.JDBCExceptionReporter - SQL Exception
java.sql.SQLException: Cannot load JDBC driver class 'null'
 at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:529)
 at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3
12)
 at
net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(Datas
ourceConnectionProvider.java:59)
 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:262)
 at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3155)
 at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3138)
 at
net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:40)

My setup:
tomcat_home\common\lib contains:
commons-dbcp.jar
commons-pool.jar
jdbc2_0-stdext.jar
jndi.jar
mysql-connector-java-3.0.8-stable-bin.jar
hibernate2.jar
etc

Server.xml:
    <DefaultContext >
     <Resource name="jdbc/Salesweb" auth="Container"
type="javax.sql.DataSource"/>
     <ResourceParams name="jdbc/Salesweb">
      <parameter>
       <name>factory</name>
       <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
      <parameter>
       <name>maxActive</name>
       <value>100</value>
      </parameter>
      <parameter>
       <name>maxIdle</name>
       <value>30</value>
      </parameter>
      <parameter>
       <name>maxWait</name>
       <value>10000</value>
      </parameter>
      <parameter>
       <name>username</name>
       <value>myuser</value>
      </parameter>
      <parameter>
       <name>password</name>
       <value>mypass</value>
      </parameter>
      <parameter>
       <name>driverClassName</name>
       <value>org.gjt.mm.mysql.Driver</value>
      </parameter>
      <parameter>
       <name>url</name>

<value>jdbc:mysql://192.168.0.104:3306/salesweb?autoReconnect=true</value>
      </parameter>
     </ResourceParams>
    </DefaultContext>

web.xml:
 <resource-ref>
  <description>Salesweb Database Connection</description>
  <res-ref-name>jdbc/Salesweb</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
 </resource-ref>

hibernate.cfg.xml:
<hibernate-configuration>
    <session-factory>
        <property
name="connection.datasource">java:comp/env/jdbc/Salesweb</property>
        <property name="show_sql">true</property>
        <property
name="dialect">net.sf.hibernate.dialect.MySQLDialect</property>
  <!-- Mapping files -->
        <mapping resource="Prospect.hbm.xml"/>

    </session-factory>
</hibernate-configuration>

Thanks for any help in advance!!!
-David


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]