Recent content by Viperan

well in My Database Agents, there is a task to update a user info and the user infos are spreaded to four different tables. Inorder to update these infos. The query must be done in seperated execution time, based on what info does the user inserted. thus these tables must be locked so that...

Thanks. It works... daniel-

I agree. BTW, here is the Error Log that I got : Logger:: logging DatabaseAccessor:: SQLException: Can not issue INSERT/UPDATE/DELETE with executeQuery() Logger:: logging DatabaseAccessor:: SQLState: S1009 Logger:: logging DatabaseAccessor:: Query: UNLOCK TABLES Logger:: logging...

I think you're right. I tried to search into the mysqldump file for all my Databases and I couldn't find a Lock table inside of it. I have another question though. Have you ever tried to lock tables from JDBC. If so can you Unlock it? thanks daniel-

I try to restart the mysqld couple of times, no luck so far. I am sure that lock mechanism must be stored as a temporary table that also stored in the database table somewhere... BTW, do you know any command to Unlock tables (besides UNLOCK TABLES;)that executable from JDBC connector. I have...

The problem is that the UNLOCK TABLES command doesn't really work when executed from JDBC! Plus, the tables that hold the list of the locked tables in the database got copied when I dump the database into txt file. The last thing that I want to do is to open that txt file and tried to examine...

I try to Lock and unlock certain tables from my database test using JConnector (mysql jdbc lattest version) and I found out that the unlock command is not actually works. Now my database is occupied by these locked tables. How do I see a list of Locked tables in mysql and How do I get rid of...