randy roy ha scritto: > Stefano, > > I have a fairly old version of mySQL 4.0.18. But until now, I haven't > had any problems with it. > > My connector in the JAMES lib is: mm.mysql-2.0.14.jar
So first of all download connector/j 5.0.7 and try again: mm.mylsql-2.0.14 has been tested against mysql 3 the last time. Any newer mysql really needs a newer connector. Are you using JAMES Server 2.3.1 or something older? If older you should really upgrade. > I have never been certain about the correct way to set up the config for > mySQL (ini files vs. cnf files and different places you can optionally > put them etc.) In mySQL 4 version, they have a my.ini that has to be in > /WINNT directory. Then they have an optional my.cnf file that must be > in c:\. It appears the directory requirements have changed in later > releases, and they have everything in the install dir. But I'm still on > the old way. At this point, I have a tiny my.ini in c:/WINNT: > > [mysqld] > basedir=c:/mysql > datadir=c:/mysql/data > set-variable = max_allowed_packet=16M > [WinMySQLAdmin] > Server=C:/mysql/bin/mysqld-nt.exe > > (I remember some problem where I had to set the max_allowed_packet size > here. But it's been too long to remember why.) You probably increased it to support bigger messages in db: mysql protocol is a bit limited and it will try to transfer a single field content in a single packet. Stefano --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
