SQL7008错误 - 解决方法？ [英] SQL7008 Error - Workaround?

问题描述

我正在使用JTOpen JDBC驱动程序作为DB2通用数据库。我对SQL的经验很少，简单的语句。

I'm using the JTOpen JDBC driver for a DB2 Universal database. I have very little experience with SQL beyond simple statements.

从这个问题，我看到在尝试在一个非记录表中插入/更新行时抛出了错误（SQL7008）交易（释义）。

From this question, I see that the error I'm getting (SQL7008) is thrown when trying to "insert/update rows in a non-journaled table during a transaction" (paraphrased).

根据项目负责人，我们的数据库不记录，不会很快（不要问我为什么，不是DBA）。但是，我正在开发一个能够一次性执行 commit 项目的项目（而不是每次执行调用时都会自动提交）几乎是必要的（不完全是

According to the project lead, our DB is not journaled and won't be any time soon (don't ask me why, I'm not the DBA). However, I'm working on a project where being able to commit everything in one go (rather than AutoCommit-ing each time an execute is called) is nearly necessary (not totally required, but it would solve a lot of issues down the road).

有没有办法解决erorr SQL7008而不启用Journalling？

Is there any way to work around erorr SQL7008 without enabling Journalling?

推荐答案

在不启用日志功能的情况下解决问题的唯一方法是在连接字符串中禁用事务隔离，如下所示：

The only way to work around it without enabling journaling is to disable transaction isolation in your connection string as follows:

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

可以在 IBM Toolbox for Java JDBC properties 文档。

这篇关于SQL7008错误 - 解决方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！