SQL7008 error while updating DB2 for iSeries table

I have a Java web application using Hibernate and DB2 for iSeries , and while updating the table I get the following error: -

SQL7008 error while updating DB2 for iSeries table

+2
source share
2 answers

From making some errors in this error message, I noticed that this happens when you run insert / update in non-transactional mode. The explanation is given here .

This is because the table in which you are trying to update is not, and your update is performed inside a transaction.

As a rule, you should always commit (and roll back if an exception occurs) your transactions. Usually I never set auto commit to true, but in this case I would like to understand if this is really necessary, as indicated in the link above. Can you set the auto-commit to true on your connection to see if this has disappeared?

<property name="hibernate.connection.autocommit" value="true"/>

This link also contains several guides for managing sleep transactions.

+3
source

I found the answer to my question, This happens because CoolBeans is mentioned, because the table I tried to update is not logged.

Add this table to the log, here are the steps

it took care of my problem.

+1
source

Source: https://habr.com/ru/post/1382563/


All Articles