Results 1 to 2 of 2

Thread: CursorHold=1

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    Unanswered: CursorHold=1

    Hi all.

    I'm using WebSphere 6.0 and DB2 under Windows, XADataSource(COM.ibm.db2.jdbc.DB2XADataSource from db2java.zip).
    I've been trying to keep cursors open before commit (doing nested loops), but the recomended configuration (cursorhold=1) doesn't work for me.
    Can anyone experienced this issue before?

    >db2level
    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08024" with
    level identifier "03050106".
    Informational tokens are "DB2 v8.1.11.973", "s060120", "WR21365", and FixPak
    "11".

    Thanks.

  2. #2
    Join Date
    Dec 2008
    Posts
    2
    One interesting thing. If I change to ConnectionPoolDataSOurce(not XA), it works fine.

Posting Permissions

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