Search code examples
exceptionibatismybatis

ibatis exception - Database session disruption

Im using ibatis to persist my data into database. I have an application which frequently updates the database with the values from the application for every few secs. After 5 hours of running ibatis throws this exception :

Database session disruption - org.apache.ibatis.exceptions.PersistenceException and later i see

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'updates_table' doesn't exist.

for 5 hours it was populating the same table and suddenly it throws this exception. I don't know what could be the reason. Can anyone please help me out abt this issue.

Thank you.

Solution

  • If the table is not listed anymore - then look for drop statements in other parts of your code, for example periodic tasks or something.

    Another possible reason might be transaction on DDL statement, which was rolled back.