Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009
    Posts
    16

    Unanswered: exception during insert query

    After executing a series of insert statements, one insert statement will fail
    giving the following exception: Operation not allowed for reason code "1" on table <table_name>

    Can anyone suggest reasons what might cause this?

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What's the complete error message, including the DB2 message code?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Apr 2009
    Posts
    16
    com.ibm.db2.jcc.c.hh: Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.



    com.ibm.db2.jcc.c.SqlException: Error for batch element #0: Operation not allowed for reason code "1" on table <table_name>
    at com.ibm.db2.jcc.c.ig.d(ig.java(Compiled Code))
    at com.ibm.db2.jcc.a.kb.l(kb.java(Compiled Code))
    at com.ibm.db2.jcc.a.kb.a(kb.java(Compiled Code))
    at com.ibm.db2.jcc.a.w.a(w.java(Inlined Compiled Code))
    at com.ibm.db2.jcc.a.ec.b(ec.java(Compiled Code))
    at com.ibm.db2.jcc.c.jg.db(jg.java(Inlined Compiled Code))
    at com.ibm.db2.jcc.c.jg.b(jg.java(Compiled Code))
    at com.ibm.db2.jcc.c.jg.a(jg.java:2818)

Posting Permissions

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