You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by "Schult, Pascal" <pa...@grundvers.de> on 2004/03/01 17:24:49 UTC
mysql -> No suitable driver
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....
Any help?
Thanx, Pascal
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: mysql -> No suitable driver
Posted by Anna Bikkina <an...@pinksheets.com>.
In cocoon.xconf did you add <driver>org.mmit... </driver> tag in your database
connection tags.
Also it requires a driver that supports jdbc type 3. Check it out.
Anna.
On Monday 01 March 2004 11:24 am, Schult, Pascal wrote:
> ad about 5 tutorials to get the MySQL Connector/J installed, but no result.
> Could anybody give me a hint?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: mysql -> No suitable driver
Posted by Geoff Howard <co...@leverageweb.com>.
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" <pa...@grundvers.de>
>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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: mysql -> No suitable driver
Posted by yangontha Maung <th...@yahoo.com>.
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.
Buf probably, you may need to define the CLASSPATH and
add the path and filename of .jar file to CLASSPATH.
rgds,
--- "Schult, Pascal" <pa...@grundvers.de>
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....
>
> Any help?
>
> Thanx, Pascal
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail:
> users-help@cocoon.apache.org
>
__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org