aspose file tools*
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
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
 
 
subject: java.sql.SQLException: The total number of locks exceeds the lock table size