2 Replies Latest reply on Jun 29, 2005 10:26 AM by Leo

    Query SQL after CMP set method can´t read the updated value

    Leo Newbie

      Hi,

      I have a CMP that updates a field by calling a setXYZ method.

      After call the CMP setXYZ method, I try to read the database via a normal SQL Statment, like that:

      myCmp.setXYX("bla bla");
      executeQuery("Select XYZ from Table Where PK=1");

      Why the executeQuery method does not get the new "bla bla" value?

      I using:
      JDBCConnection TRANSACTION_READ_COMMITED

      and in JBoss.xml:
      <commit-option>B</commit-option>