I have a CMP Entity Bean defined lke this in JAWS.XML:
<entity>
<ejb-name>VENDOR_SI_PARAMETER_CHOICEBean</ejb-name>
<table-name>VENDOR_SI_PARAMETER_CHOICE</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>SI_PARAMETER_UID</field-name>
<column-name>SI_PARAMETER_UID</column-name></cmp-field>
<cmp-field>
<field-name>SI_TYPE_UID</field-name>
<column-name>SI_TYPE_UID</column-name></cmp-field>
<cmp-field>
<field-name>VENDOR_UID</field-name>
<column-name>VENDOR_UID</column-name></cmp-field>
<cmp-field>
<field-name>CHOICE_UID</field-name>
<column-name>CHOICE_UID</column-name></cmp-field>
<finder>
<name>findByServiceVendorParameter</name>
<query>SI_TYPE_UID = {0} and VENDOR_UID = {1} and
SI_PARAMETER_UID = {2}</query>
<order>CHOICE_UID</order></finder>
<finder>
<name>findByServiceInstanceParameter</name>
<query>, service_instance_parameter, proxy_account,
service_instance where
service_instance_parameter.SERVICE_INSTANCE_PARAMETER_UID = {0} and
service_instance_parameter.SERVICE_INSTANCE_UID =
service_instance.SERVICE_INSTANCE_UID and
service_instance.PROXY_ACCOUNT_UID=proxy_account.PROXY_ACCOUNT_UID and
proxy_account.VENDOR_UID = vendor_si_parameter_choice.VENDOR_UID and
service_instance_parameter.TYPE_UID =
vendor_si_parameter_choice.SI_PARAMETER_UID and
service_instance.TYPE_UID = vendor_si_parameter_choice.SI_TYPE_UID
</query>
<order>CHOICE_UID</order></finder></entity>
I results in the following output in server.log:
[JAWS] findByServiceInstanceParameter command executing: SELECT
VENDOR_SI_PARAMETER_CHOICE.SI_PARAMETER_UID,SI_TYPE_UID,VENDOR_UID,CHOICE_UID
FROM VENDOR_SI_PARAMETER_CHOICE , service_instance_parameter,
proxy_account, service_instance where
service_instance_parameter.SERVICE_INSTANCE_PARAMETER_UID = ? and
service_instance_parameter.SERVICE_INSTANCE_UID =
service_instance.SERVICE_INSTANCE_UID and
service_instance.PROXY_ACCOUNT_UID=proxy_account.PROXY_ACCOUNT_UID and
proxy_account.VENDOR_UID = vendor_si_parameter_choice.VENDOR_UID and
service_instance_parameter.TYPE_UID =
vendor_si_parameter_choice.SI_PARAMETER_UID and
service_instance.TYPE_UID = vendor_si_parameter_choice.SI_TYPE_UID
ORDER BY CHOICE_UID
[JAWS] Set parameter: idx=1, jdbcType=INTEGER, value=75
[JAWS] java.sql.SQLException: ORA-00918: column ambiguously defined
Seems like each column name between the SELECT and the WHERE needs to be
qualified with the table name, not just the first one. All four columns
are part of the primary key.
I'm using jboss-2.2.1
Thanks, Mark
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
