I loaded the MySQL provided connector version 3.1 in the James SAR, edited the config.xml datasources to use this driver and all worked well.
MySQL Connector/J 3.1 from: http://dev.mysql.com/downloads/connector/j/3.1.html Documentation describes that the driver should be: 'com.mysql.jdbc.Driver' It also states that the 'org.gjt.mm.mysql.Driver' class name is usable to remain backwards-compatible with MM.MySQL. I had to change to the com.mysql... To get it to work. The calling syntax remains unchanged: jdbc:mysql://[host][,failoverhost...][:port]/[database][?propertyName1][=pro pertyValue1][&propertyName2][=propertyValue2]... Default for the Host and Port is '127.0.0.1' and '3306' respectively. Regards, Tony Freeman TEAMXL 678.344.2305 Office 509.693.2598 eFax [EMAIL PROTECTED] -----Original Message----- From: Noel J. Bergman [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 11:55 PM To: James Users List Subject: RE: Using MySQL 4.1.11 > I just realized the driver used by james does not originate with MySQL AB. > I found the "Giant JAVA Tree" The author was hired by MySQL AB, and now works for them. Connector/J is the new version of that code. The code we ship was the last non-GPL version before MySQL decided to charge non-GPL users for the drivers. We cannot ship their new driver without virally infecting JAMES. At some point soon, I expect that we will bundle Derby with JAMES as our default database, and won't include any third party JDBC drivers at all. In the meantime, as an end-user, you have the right to download and install the GPL driver from MySQL. You will have to change the driver class in config.xml to com.mysql.whateveritisthatIdon'trecalloffhand. --- Noel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
