Re: Table locking Issue MySQL on Tiger...
Re: Table locking Issue MySQL on Tiger...
- Subject: Re: Table locking Issue MySQL on Tiger...
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 5 May 2005 08:06:05 -0400
Nathan, you are very brave using MySQL 5.0.4 which is not General
Release yet ;-) If there is no compelling reason to use 5.0.4 (such as
stored procedures), then I think you will definitely solve your problem
by switching to the GA of 4.0 or 4.1. On the other hand you could try
altering your 5.0.4 tables to use InnoDB engine which does row locks
rather than the complete table locks that MyISAM does for a single row
read.
Regards,
-Kieran
________________________________________________________________
Blog: http://webobjects.webhop.org/
On May 5, 2005, at 1:39 AM, Nathan Walker wrote:
I am using MySQL 5.0.4 with WebObjects 5.2.4 on Tiger and since the
upgrade, I have an issue with Table Locking in MySQL. I get this error
if I try to access the table:
Next exception:SQL State:HY000 -- error code: 1099 -- msg: Table
'Invmstr' was locked with a READ lock and can't be updated
I'm not sure if the issue is related to the JDBC driver on Tiger which
I'm using 'mysql-connector-java-3.1.7-bin.jar'......or if it is related
to the MySQL or if it's related to EOF on Tiger ??
I had been developing this application for a couple months now and have
never run into this issue until I did the upgrade. Anybody ever run
into this table locking issue with MySQL ?? The tables engines are
MyISAM..........
Can anybody shed any light about this ?
thx,
nathan
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden