Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    2

    Unanswered: Db2 7.2 - Aix - Delete

    Hi,

    We are experiencing a strange issue with DB2 on AIX. Our JAVA application which is running in WebSphere Application Server, is trying to delete a couple of records from a table and then insert new rows into the same table. Our application is using the VisualAge Persistence Builder to manage all database connectivity and transactions.

    For some reason, the delete SQL statements is not even sent to the database server. The insert statements are being sent and executed.

    Now, to add some more to the confusion, this only happens in one environment. We have the same application, running on another WAS and DB2 (same versions) and perform both the delete and insert successfuly.

    I wonder if anyone has run into something like this and could shed some light on this enigma.

    Thanks in advance,

    -Eyal

  2. #2
    Join Date
    Apr 2002
    Posts
    18
    As it seems to be an environmental problem, the only thing I can think of is to check that DELETE privileges have been granted

  3. #3
    Join Date
    Mar 2002
    Posts
    17
    We had similar problem and it turned out to be the way the delete was being done.

    ResultSet rs = stmt.executeQuery(select);

    instead of

    ResultSet rs = stmt.executeUpdate();

    Check if you're doing the same thing

  4. #4
    Join Date
    May 2002
    Posts
    2
    Thanks Musa,

    Your hint really helped. Indeed for some reason the VisualAge PersistenceBulder was sending executeQuery instead of executingUpdate. I had to change the way we constructed the QuerySpec and that solved the problem.

    Thank you very much.

    -Eyal

Posting Permissions

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