Re: mysql -> No suitable driver

[Geoff Howard]

yangontha Maung wrote:

Hi,

On Linux, after I put the .jar file in
/usr/local/cocoon/build/webapp/WEB-INF/lib, it works.
I am not sure about Windows environment.
 

All environments are the same  in this regard.  the WEB-INF/lib folder 
of your
webapp context is where the jars go.

Buf probably, you may need to define the CLASSPATH and
add the path and filename of .jar file to CLASSPATH.
 

No, this will have no effect.

Geoff

--- "Schult, Pascal" <[EMAIL PROTECTED]>
wrote:
 

hello all,

i have a problem to connect to my mysql database. i
tried the hole day to get a connection but it does
not work. I read about 5 tutorials to get the MySQL
Connector/J installed, but no result.
Could anybody give me a hint?
I'm using Cocoon 2.1.4 with Tomcat 4.1.29 on Windows
2000 with MySQL 4.0.15.
Error message:

WARN    (2004-03-01) 16:25.47:650   [core.manager]
(/cocoon/samples/dev/query)
http8080-Processor4/ResourceLimitingJdbcDataSource:
Could not return connection
java.sql.SQLException: No suitable driver
        at
   

java.sql.DriverManager.getConnection(DriverManager.java:532)
 

	at

   

java.sql.DriverManager.getConnection(DriverManager.java:171)
 

-----------------------

my configuration:

in web.xml:
...
<servlet>
   <servlet-name>Cocoon</servlet-name>
   <display-name>Cocoon</display-name>
   <description>Cocoon</description>
  

   

<servlet-class>org.apache.cocoon.servlet.CocoonServlet</servlet-class>
 

  
   
   <init-param> 
   	<param-name>load-class</param-name>   
   
<param-value>com.mysql.jdbc.Driver</param-value>
	<!--
<param-value>org.gjt.mm.mysql.Driver</param-value>
-->
   </init-param>
...

in cocoon.xconf:
...
<datasources>
	<jdbc name="mysqlpool">
	
<dburl>jdbc:mysql://localhost:3306/cocoondb</dburl>
		<user>root</user>
		<password></password>
	</jdbc>  
...

---------------------
I tried to put the
mysql-connector-java-3.0.11-stable-bin.jar (or the
mysql-connector-java-3.1.1-alpha-bin.jar) into
"C:\tomcat_4.1.29\webapps\cocoon\WEB-INF\lib\" but
that did not work.
Than i put the foldersystem "com\mysql\jdbc" into
"C:\tomcat_4.1.29\webapps\cocoon\WEB-INF\classes\"
and after that i tried the old 'Mark Matthews'
driver namer "org\gjt\mm\mysql".
Nothing worked....


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