>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]
