Re: Can somebody go over MySQL Connector/J (mysql-connector-java)?

hi, ludovic: I posted this already at link below; any comments are appreciated: http://www.xwiki.org/xwiki/bin/view/Main/InstallLinuxTomcat XWikiGuest 13/06/2005 23:12:53 Can somebody go over MySQL Connector/J (mysql-connector-java)? In reference to the comment… "If you use a newer mysql version, you need to download the most recent drivers and install them into the tomcat common lib directory as stated in the documents. However you also need to remove the mysql connector file from the extracted xwiki under webapps." ...a couple of points: I just was able to do an install with the packaged driver mysql driver (called mysql-connector-java-3.0.9-stable-bin.jar) on a system which uses MySQL 4.0.20; however, using same driver, using same java install, same tomcat, same config changes, same permissions structure for xwiki user on mysql, same everything except mysql versions, I am able to run xwiki on the system with MySQL 4.0.20, but get nothing but 500 errors with the MySQL 4.1.11. One more thing: I am able to run tomcat manager along with sample programs with no issue on both systems so I can vouch for tomcat's working order. Can somebody go over how to get the proper drivers for this particular version of MySQL? Better, maybe somebody can go over how to install newer drivers from the MySQL: http://www.mysql.com/products/connector/j/ After downloading from the mysql site, I'm able to find files that look like the driver files, but I can't get them to work by simply replacing the packaged mysql-connector-java*.jar file. I'm thinking I need to edit something like server.xml located in CATALINA_HOME/conf/server.xml, but I haven't the foggiest notion if that's even close to being correct. Maybe someone with more knowledge about the mysql-connector-java driver can shed some light on this subject. Thanks, all, for going open source with this project. best, steve