DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20623>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20623

No connection for MySQL

           Summary: No connection for MySQL
           Product: Cocoon 2
           Version: 2.0.4
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: general components
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I try to use MySQL with JDBC driver "mysql-connector-java-3.0.8-stable-bin.jar".
My cocoon.xconf looks like this:
        <datasources>
                <jdbc name="test">
                        <pool-controller max="5" min="2"/>
                        <dburl>jdbc:mysql://localhost/test</dburl>
                        <user>glaser</user>
                        <password>Sara22</password>
                </jdbc>
        </datasources>

My sitemap looks like that:
  <map:pipeline>
        <map:match pattern="test">
        <map:generate src="_xml/sql.xml"/>
                <map:transform type="sql">
                        <map:parameter name="use-connection" value="test"/>
                </map:transform>
                <map:serialize type="xml"/>
        </map:match>
  </map:pipeline>
My web.xml looks like that:
    <init-param>
      <param-name>extra-classpath</param-name>
      <param-value>E:\mysql-connector-java-3.0.8-stable-bin.jar</param-value>
    </init-param>


Cocoon doesn't get a connection. Following error occurs:
DEBUG   (2003-06-09) 20:59.41:553   [core.manager] (/cocoon/test) HttpProcessor
[8080][4]/JdbcConnectionFactory: Exception in JdbcConnectionFactory.newInstance:
java.lang.ClassNotFoundException: 
org.apache.avalon.excalibur.datasource.Jdbc3Connection

There is only a class JdbcConnection given in avalon package provided by cocoon 
but not Jdbc3Connection.

btw. I'm using Tomcat 4.0.1.

Reply via email to