This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes java.sql.SQLException: The total number of locks exceeds the lock table size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: The total number of locks exceeds the lock table size" Watch "java.sql.SQLException: The total number of locks exceeds the lock table size" New topic
Author

java.sql.SQLException: The total number of locks exceeds the lock table size

purushotham podaralla
Greenhorn

Joined: Sep 12, 2007
Posts: 29
Hi,

i am getting the below error.

java.sql.SQLException: The total number of locks exceeds the lock table size.

The same query what it is generating at the time of the above error is.

INSERT INTO xxx (date,id,F1,F2,F3,F4,F5,F6,F7,F11,F12, COUNT) SELECT date,id,F1,F2,F3,F4,F5,F6,F7,round(avg(F11),2) F11,round(avg(F12),2) F12,COUNT(*) COUNT FROM yyy WHERE date >= ? AND date <= ? AND id = ? GROUP BY date,F1,F2,F3, F4,F5,F6,F7.

when executing the select query of insert on select. i am getting 0 rows as shown below.

mysql> select count(*) from yyy WHERE date >= '2010-08-12' AND date <= '2010-08-13' AND ID = 11;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.10 sec)

Please let me know how to resolve this issue.

Thanks in Advance.

Regards,
Purushotham
 
Don't get me started about those stupid light bulbs.
 
subject: java.sql.SQLException: The total number of locks exceeds the lock table size
 
Similar Threads
What does a "one to many" relationship mean
loading a csv file
Terminal login in slackware OS
How to crate Multiple ArrayList from one ArrayList
Math.Round