wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: The total number of locks exceeds the lock table size
 
Similar Threads
How to crate Multiple ArrayList from one ArrayList
Math.Round
loading a csv file
What does a "one to many" relationship mean
Terminal login in slackware OS