Unanswered: java.sql.SQLException: [SQL7008] TEST in MYLIB not valid for operation.
I am testing a simple CMP using Websphere Studio 5. I set up a simple DB2 table on AS400 which has only a key field. But when I update/insert record into the table using the bean, it gives me the following error message
java.sql.SQLException: [SQL7008] TEST in MYLIB not valid for operation.
at com.ibm.as400.access.JDError.throwSQLException(JDE rror.java:388)
at com.ibm.as400.access.AS400JDBCStatement.commonExec ute(AS400JDBCStatement.java:621)
at com.ibm.as400.access.AS400JDBCPreparedStatement.ex ecuteUpdate(AS400JDBCPreparedStatement.java:948)
The jdbc driver is DB2 UDB for iSeries (Toolbox) jt400.jar.
From the reading throught web, it seems that lack of journaling on the database side might cause the problem.
No idea how to fix it in CMP other than enabling the journaling. Someone suggest to append "translation isolation =none" at the end of the JDBC url. But it seems not the case of CMP.