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,
