2 Replies Latest reply on Dec 19, 2001 5:51 AM by Konstantin

    Anybody got JAWS to log queries?

    Konstantin Newbie

      Hi all,

      I try to pinpoint weird problem with CMP bean
      ( actually custom finder bombing with: java.sql.SQLException: ORA-00960: ambiguous column naming in select list )

      And of course I would like to see actual query.

      Setting
      log4j.category.org.jboss.ejb.plugins.jaws.jdbc=DEBUG , Default, Console

      did not help,as well as setting "true" everywhere I found in jboss.jcml & standartjaws.xml


      Here is snipet fro jaws.xml:
      -----

      <ejb-name>GroupCondition</ejb-name>
      <table-name>groupcondition</table-name>

      <cmp-field>
      <field-name>canBuy</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>canSell</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>categoryId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>customerRuleId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>employeeRuleId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>groupId</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>maxCustomer</field-name>
      </cmp-field>
      <cmp-field>
      <field-name>maxEmployee</field-name>
      </cmp-field>


      findByGroupIdSortCategory
      <![CDATA[groupid={0}]]>
      categoryid asc




      ------

      Finder in question: findByGroupIdSortCategory
      ( autogenerated finder findByGroupId works just fine... )

      Any ideas?

      regards,