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

    Unanswered: incorrect query result

    Hi, I am using db2 version 5, win2k, iPlanet web server6.0 and servletexec4.2 nsapi. We are using jsp to connect to the DB2 databases. When the number of users is small, there is no problem. While when it is large, database returns other user's result !!! Please enlight.

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Have you try to install the fixpacks for DB2 v5. On IBM support web page there is Fixpack 17.

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Grofaty ... When you recommend FP17, is it because of a known problem or is it a general comment ?

    Thanks

    Sathyaram

    Originally posted by grofaty
    Hi,

    Have you try to install the fixpacks for DB2 v5. On IBM support web page there is Fixpack 17.

    Hope this helps,
    Grofaty
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jul 2003
    Location
    China
    Posts
    9

    Re: incorrect query result

    I doubt it's maybe a problem of session in jsp or java.
    we have an application that use servlet+Oracle/DB2 and we have encounted the same wrong result sometimes,and it do occur when
    there are many users having connected.

    if possible,I suggest you change another database to see whether the
    problem will occur.

    Originally posted by qinmingh
    Hi, I am using db2 version 5, win2k, iPlanet web server6.0 and servletexec4.2 nsapi. We are using jsp to connect to the DB2 databases. When the number of users is small, there is no problem. While when it is large, database returns other user's result !!! Please enlight.

Posting Permissions

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