0 Replies Latest reply on Oct 5, 2004 9:10 AM by jason.donovan

    ejb-ql strange behavior

    jason.donovan Newbie

      I'm dealing with a performance problem, so i logged all the executed sql, and i found a strange behavior, in one get operation, jboss does several updates, which i can't retrieve in any code.

      My first question is,
      - is this a normal action.
      And second
      - How can i resolve this, or trace the source thatÂ’s doing this action.


      Executing SQL: SELECT ACCOUNT FROM T_STRUCTURE_FOR_ACCOUNT WHERE ACCOUNT=?
      Executing SQL: SELECT PERSON_NUMBER, OBLIGATORY_DATA_TYPE, A2_NUMBER_REFERENCE, ADVANCE_NBR, RECEIPT_ALLOCATION, REVALUABLE, THIRD, TYPE FROM T_STRUCTURE_FOR_ACCOUNT WHERE (ACCOUNT=?)
      Executing SQL: SELECT FRENCH_DESCRIPTION, DUTCH_DESCRIPTION FROM TE_ACTIVITY WHERE (ACTIVITY_CODE=?)
      Executing SQL: SELECT FRENCH_DESCRIPTION, DUTCH_DESCRIPTION FROM TE_MISSION WHERE (MISSION=?)
      Executing SQL: SELECT FOLDER_NBR, CREATION_DATE, CLOSURE_DATE, FACTURATION_AMOUNT, FACTURATION_DATE, FACTURATION_COMMENTS, RECALL_DATE, RECALL_COMMENTS, ACCOUNTING_YEAR, VISUM_YEAR, STATUS, THIRD, NAME, REIMBURSEMENT_CODE, ACTIVITY, MISSION, FINANCIAL_CENTER FROM T_FOLDER WHERE (FOLDER_ID=?)
      Executing SQL: SELECT JUSTIFICATION_DOCUMENTS_DATE, JOURNAL_STATUS, JOURNAL_VALIDATION_DATE, JOURNAL_EXACT_DATE, LAST_JOURNAL_OF_MONTH FROM T_JOURNAL WHERE (JOURNAL_NUMBER=? AND JOURNAL_DATE=? AND FINANCIAL_CENTER=?)
      Executing SQL: UPDATE T_FOLDER SET CREATION_DATE=? WHERE FOLDER_ID=?
      Rows affected = 1
      Executing SQL: UPDATE T_JOURNAL SET JUSTIFICATION_DOCUMENTS_DATE=?, JOURNAL_VALIDATION_DATE=?, JOURNAL_EXACT_DATE=? WHERE JOURNAL_NUMBER=? AND JOURNAL_DATE=? AND FINANCIAL_CENTER=?
      Rows affected = 1
      Executing SQL: SELECT FINANCIAL_CENTER_NUMBER FROM TE_FINANCIAL_CENTER WHERE FINANCIAL_CENTER_NUMBER=?
      Executing SQL: SELECT INACTIVATION_DATE, LANGUAGE, VERIFIER FROM TE_FINANCIAL_CENTER WHERE (FINANCIAL_CENTER_NUMBER=?)
      Executing SQL: SELECT MECANO, NAME, FIRST_NAME, ACTIVE FROM T_VERIFIER WHERE (VERIFIER_ID=?)
      Executing SQL: UPDATE T_FINANCIAL_TRANSACTION SET JOURNAL_DATE=? WHERE FINANCIAL_TRANSACTION_ID=?
      Rows affected = 1
      Executing SQL: SELECT ACCOUNT FROM T_STRUCTURE_FOR_ACCOUNT WHERE ACCOUNT=?
      Executing SQL: UPDATE T_FOLDER SET CREATION_DATE=? WHERE FOLDER_ID=?
      Rows affected = 1
      Executing SQL: UPDATE T_JOURNAL SET JUSTIFICATION_DOCUMENTS_DATE=?, JOURNAL_VALIDATION_DATE=?, JOURNAL_EXACT_DATE=? WHERE JOURNAL_NUMBER=? AND JOURNAL_DATE=? AND FINANCIAL_CENTER=?
      Rows affected = 1
      Executing SQL: SELECT FINANCIAL_CENTER_NUMBER FROM TE_FINANCIAL_CENTER WHERE FINANCIAL_CENTER_NUMBER=?
      Executing SQL: UPDATE T_FINANCIAL_TRANSACTION SET JOURNAL_DATE=? WHERE FINANCIAL_TRANSACTION_ID=?
      Rows affected = 1