When SQL has issue we get this from Hibernate: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update The problem is that this error is not very helpful. It doesn’t tell us what SQL statement is causing the problem. The solution is to add the following system properties: This would prevent Hibernate from BATCHING and therefore tell ..
Category : SQL
Home » Archive by category : SQL
From https://stackoverflow.com/questions/12774709/mysql-very-slow-for-alter-table-query MySQL’s ALTER TABLE performance can become a problem with very large tables. MySQL performs most alterations by making an empty table with the desired new structure, inserting all the data from the old table into the new one, and deleting the old table. This can take a very long time, especially if you’re ..
A boolean column can have either of the 3 values: true, false or null (unknown). It is a good idea to ALWAYS define a boolean column as “NOT NULL” thus restricting it to either true or false only. The following query highlights the potential issue with null (unknown) value: mycol != TRUE This statement is ..