Oh the simplest things are often the overlooked. I can't believe... I don't remember where I got this driver but it was extremely old (v1.2c)!
Thanks for the help, -shawn http://www.shawn-wilson.com Hugh Brien wrote: > Try the latest version of the driver > r, > Hugh > ----- Original Message ----- > From: "Shawn A. Wilson" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Thursday, April 11, 2002 8:11 PM > Subject: RE: Help using JDBC realm with MySQL > > > >>Well, I tried adding the relaxAutocommit=true parameter but I still get >>the same message. Arg... this is not making any sense. Do my tables need >>to be of a specific type? I created them without any options so they >>should be MyISAM. >> >>-shawn >> >>http://www.shawn-wilson.com >> >>On Thu, 11 Apr 2002, Dennis Doubleday wrote: >> >> >>>Add the following parameter to your connection URL: relaxAutocommit=true >>> >>>So it should look like: >>> >>>jdbc:mysql://localhost/peopleshare?relaxAutocommit=true&user=hidden&pass >>>word=hidden >>> >>> >>>>-----Original Message----- >>>>From: Shawn A. Wilson [mailto:[EMAIL PROTECTED]] >>>>Sent: Thursday, April 11, 2002 2:33 PM >>>>To: Tomcat Users List >>>>Subject: Re: Help using JDBC realm with MySQL >>>> >>>> >>>>Does nobody know a solution to get around this problem? I >>>>have received no >>>>replies and I desparately need to know how to get around the "Cannot >>>>disable AUTO_COMMIT" error with JDBC realms and MySQL. >>>> >>>> >>> >>>-- >>>To unsubscribe: <mailto:[EMAIL PROTECTED]> >>>For additional commands: <mailto:[EMAIL PROTECTED]> >>>Troubles with the list: <mailto:[EMAIL PROTECTED]> >>> >> >>-- >>To unsubscribe: <mailto:[EMAIL PROTECTED]> >>For additional commands: <mailto:[EMAIL PROTECTED]> >>Troubles with the list: <mailto:[EMAIL PROTECTED]> >> > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>