I added an entry to cocoon.xconf:
jdbc name=mmis2
pool-controller max=10 min=5/
auto-committrue/auto-commit
dburljdbc:mysql://localhost/mmis2/dburl
useruser/user
passworduser123/password
/jdbc
You may need a port number here for localhost. I
Hi Sergio,
your configuration seems fine. The JDBC driver will (if not specified) use 3306
as the default port. So you do not need to specify this. It seems to me that the
somehow your user does not have enough privileges to connect to the database server.
Did you find anything else in your
My experience with mySql is:- you need to have the good driver, typically in WEB-INF/lib, you need a jdbc connector found in http://dev.mysql.com/downloads/connector/j/3.0.html
; you could have some problem between version of connector and version of Java- in WEB-INF/cocoon.xconf, you have to
Hi,
I am trying to query a mysql database from my cocoon installation. I am
using Cocoon as a webapp of tomcat.
I made the next changes:
I added mysql Driver to web.xml:
init-param
param-nameload-class/param-name
param-value
!-- For parent ComponentManager sample:
Hi,
Your conf looks basically ok. The best way is to see what you get in
mysql logs, if you are lucky it will maybe log a permission problem.
Restart mysql with log feature
mysqladmin shutdown -u root -p
mysqld_safe --log
tail -f /var/lib/mysql/localhost.log
Phil
sergio del amo wrote:
Hi,
I added an entry to cocoon.xconf:
jdbc name=mmis2
pool-controller max=10 min=5/
auto-committrue/auto-commit
dburljdbc:mysql://localhost/mmis2/dburl
useruser/user
passworduser123/password
/jdbc
You may need a port number here for localhost. I have not used mysql,
On Mon, 1 Sep 2003, Marcin Stefaniuk wrote:
Hello!
I have problem with connection to mysql. Sample for hsqldb works ok.
I installed mysql_connector_java_3.0.8-stable.jar from mysql.com in WEB-INF.
I checked that I have excalibur-datasource-1.1.1.jar
I put entry in web.xml:
init-param
Hello!
I have problem with connection to mysql. Sample for hsqldb works ok.
I installed mysql_connector_java_3.0.8-stable.jar from mysql.com in WEB-INF.
I checked that I have excalibur-datasource-1.1.1.jar
I put entry in web.xml:
init-param
param-nameload-class/param-name
Hi,
I have problem with connection to mysql. Sample for hsqldb works ok.
I installed mysql_connector_java_3.0.8-stable.jar from mysql.com in WEB-INF.
I checked that I have excalibur-datasource-1.1.1.jar
this problem has been discussed several times, maybe you'll find
a solution in the