I had the same problem in Windows 2000 and InnoDB tables, the relaxautocommit worked but the parameter has a leading UNDERSCORE:
jdbc:mysql://localhost/peopleshare?_relaxAutocommit=true&etc... I found it by code inspection. I don't know if it works under Linux, I'm still fighting with access control problems, but it should work. Shawn A. Wilson wrote: >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]> > > > > -- Fabrizio Giudici, Ph.D. - Senior Consultant Java(TM) Architect, Mentor, Senior Writer email [EMAIL PROTECTED] mobile +39 3481506941 - fax +39 (0)2700510536 Member of ADI (Italian Ph.D. Association)
