0 Replies Latest reply on Apr 2, 2003 11:52 PM by Nigel Birch

    What determines the SQL sent to the DB?

    Nigel Birch Newbie

      Hi,

      Using JBoss 2.4.x, with Hypersonic Database on Linux, and IBM JDK1.3.

      When updating the attributes in an existing entity bean, the database (via default.script) appears to have received the following SQL:

      DELETE FROM MyTable WHERE
      attr1=x AND attr2=y,...etc
      INSERT INTO MyTable
      VALUES(a,b,...etc)

      So it looks like it is deleting the row and inserting a new one rather than just updating the existing row. Is this correct behavior?

      Thanks
      NBirch