Disregard all of the following... I just realized the driver used by james does not originate with MySQL AB. I found the "Giant JAVA Tree" and will relook at Noels question...
Regards, Tony Freeman TEAMXL 678.344.2305 Office 509.693.2598 eFax [EMAIL PROTECTED] -----Original Message----- From: Tony Freeman @ TeamXL [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 11:30 PM To: 'James Users List' Subject: RE: Using MySQL 4.1.11 >From the MySQL site, I found the following: A) MySQL Connector/J is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database. B) MySQL Connector/MXJ is an MBean that allows seamlessly embedding the MySQL database server within the J2EE environment. I am not overly JAVA enabled but I believe the connector to use is the JDBC (A). To that end, I found the following on the site: ******* "MySQL Connector/J is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database. It lets developers working with the Java programming language easily build programs and applets that interact with MySQL and connect all corporate data, even in a heterogeneous environment. MySQL Connector/J is a Type IV JDBC driver and has a complete JDBC feature set that supports the capabilities of MySQL. The latest production version of the driver is now 50-100 percent faster in most situations than the previous version. It also creates fewer transient objects than before, leading to better performance and even more stability. The driver now also supports "streaming" result sets, which allows users to retrieve large numbers of rows without using a large memory buffer. With newly added large-packet protocol support, the driver can send rows and BLOBs up to 2 gigabytes in size. New features from the JDBC-3.0 API in the latest production version of MySQL Connector/J include getGeneratedKeys which allows users to retrieve auto-increment fields in a non-database-specific way. Auto-increment fields now work with object-relational mapping tools, as well as Enterprise Java Beans (EJB) servers with Container Managed Persistence (CMP) that support JDBC-3.0. The development version is being refactored to support new features in conjunction with version 4.1 of the MySQL database server, including server-side prepared statements and improved handling of multiple simultaneous character sets, including Unicode in the UCS2 and UTF8 encodings. Downloads, Licensing, and Support Two versions of MySQL Connector/J are available for download: * MySQL Connector/J 3.0 is the production-ready version of the driver, and is available under the GPL. * MySQL Connector/J 3.1 is the production-ready version of the driver, and is available under the GPL (recommended). Interoperability MySQL Connector/J is known to work with the following database tools and application servers: * Apache's Jakarta Projects (Tomcat, Turbine, Velocity, etc.) - MySQL Connector/J works with all of these tools, and in most cases is the JDBC driver used in the example applications provided. * JBoss The JBoss Open Source J2EE Application server. MySQL Connector/J works with both BMP and CMP beans in this environment . * BEA WebLogic - MySQL Connector/J works with both BMP and CMP beans as well as servlets and JSPs on this commercial J2EE platform. * IBM VisualAge for Java - VisualAge is a Java development environment. * IBM WebSphere Application Server 4.0 - MySQL Connector/J works with this commercial J2EE platform. BMP, servlets, and JSPs are supported. * Forte for Java and its open source counterpart, NetBeans - A world-class, professional IDE. The NetBeans IDE is a platform plus modules that includes components such as an editor, tools for working with source code (Java, C++, and others), version control, and a lot more. * TableGen - TableGen automatically generates classes to represent tables within a database. It is released under the GPL." ******** What I didn't find was any notes describing prior release compatability with MySQL v4.1...I can find information describing the compatability of the current release connector as follows: ******** MySQL Connector/J supports Java-2 JVMs, including JDK-1.2.x, JDK-1.3.x, JDK-1.4.x and JDK-1.5.x, and requires JDK-1.4.x or newer to compile (but not run). MySQL Connector/J does not support JDK-1.1.x or JDK-1.0.x ******** I can find this jar in the work/james*/sar-inf/lib folder of my development box: mm.mysql-2.0.14.jar (this is the connector, right) I have no idea of the number or compatability of releases between 2.0.14 and 3.1 of the connector and a brief search of the MySQL site provides no information. Assuming the James developers and other supporters suggest that I upgrade the connector, please expect further requests for help. The good news is I am comfortable trying just about anything on my development box...the bad news is I am comfortable trying about anything on my development box! 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 5:09 PM To: James Users List; [EMAIL PROTECTED] Subject: RE: Using MySQL 4.1.11 > I have just upgraded to MySQL 4.1.11 and am now having a problem > starting James as a service. > I am using James 2.2.1-RC1 and was using an older version of MySQL > without problems. This is a development box. > <driver>org.gjt.mm.mysql.Driver</driver> Does that old driver still work with 4.1, or do you need to replace it with a current driver? --- Noel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
