I am trying to use native sql to populate my composite-id.
bp.id.customerTkn does not work so I would like to know what would ;-)

thanks
vlad

Hibernate version:
2.1.6

Mapping documents:
<hibernate-mapping package="com.intgas.cw.beans.db">
<class name="BillingPackage" table="billing_package">
<composite-id class="BillingPackagePK" name="id">
<key-property column="customer_tkn" name="customerTkn" type="java.lang.Integer" />
<key-property column="billing_pkg_tkn" name="billingPkgTkn" type="java.lang.Integer" />
</composite-id>

<sql-query name="IgcDirectBillingPackage">
<return alias="bp" class="com.intgas.cw.beans.db.BillingPackage"/>
SELECT customer_tkn as {bp.id.customerTkn},
billing_pkg_tkn
FROM billing_package
WHERE customer_tkn = 167233
</sql-query>
</class>
</hibernate>

i figured out that mapping iss actually automatic and that i was misusing {} ;-)