CODEWITHSUNDEEP
sqlhibernatedb2sql-insertdb2-400
Yaoming
Yaoming

Reputation: 79

Insert works in SQL Client but not in my code (SQL7008)

I am trying to perform insert/update statements in a DB2-AS400 database. I use the jt400 driver, version 9.5 for java 8 in order to be able to connect and dialog with my DB.

In my app, I can perform selects just fine but when I try to insert or update I get the following SQL Error:

[SQL7008] Table not valid for operation.

I have done some research and it seems that it would be a journaling problem on the DB side and not in my code.

What I would like to understand is why am I able to perform insert/update using my SQL Client (DBeaver) on the same table with the exact same user ?

Upvotes: 1

Views: 656

Answers (1)

radsectors
radsectors

Reputation: 53

You might try disabling transaction isolation by adding transaction isolation=none to your connection string:

jdbc:as400://systemname;naming=sql;errors=full;transaction isolation=none;date format=iso

Ref: SQL7008 Error - Workaround?

Upvotes: 1

Related Questions