Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: java.sql.SQLException: [SQL7008] TEST in MYLIB not valid for operation.

    Please help:

    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.

    Please advise.

    Thanks

  2. #2
    Join Date
    Feb 2008
    Posts
    2

    File not valid for operation

    if the System i (iSeries, i5, AS400) file has no member, you will get the same error. Try adding a memeber to the file in the iSeries.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •