table/column alias with hibernate

[Divan Mostert]

I am hoping that someone can be of help to me as the Hibernate guys are NOT very keen on helping.

So here goes:

When I generate the property element, I use the column attribute foe the actual valid column name and the name attribute to store the original name that corresponds to my application. Now this work 100%

However, when I have a list with a one-to-many inside, I assumed that the table attribute would have the same functionality, but it doesn't. The insert seems to work ok, but when it generates the select statement, it uses the incorrect name attribute of the list.

Can anybody help???

[Gerardo Tasistro]

Can you post the code?

[Divan Mostert]

Thanks for the quick reply..

Here is my mapping code:

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
  "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="biz.c24.io.xmltest.schema.example.v0.v0.v0" auto-import="false">
   <class lazy="false" name="biz.c24.io.xmltest.schema.example.v0.v0.v0.LineitemImpl">
      <id unsaved-value="null" name="idKey">
         <generator class="native"/>
      </id>
      <property name="_io_aux" 
                    length="8000" 
                    access="biz.c24.io.api.presentation.AuxilaryAccessor" 
                    type="text"/>
      <property name="_substitutionClass" 
                    length="8000" 
                    access="biz.c24.io.api.presentation.SubstitutionAccessor" 
                    type="java.lang.String"/>
      <property name="description" 
                    column="description" 
                    access="biz.c24.io.api.presentation.PropertyAccessor" 
                    type="java.lang.String"/>
      <property name="per-unit-ounces" 
                    scale="18" 
                    column="perunitounces" 
                    access="biz.c24.io.api.presentation.PropertyAccessor" 
                    precision="38" 
                    type="java.math.BigDecimal"/>
      <property name="price" 
                    column="price" 
                    access="biz.c24.io.api.presentation.PropertyAccessor" 
                    type="java.lang.Double"/>
      <property name="quantity" 
                    scale="0" 
                    column="quantity" 
                    access="biz.c24.io.api.presentation.PropertyAccessor" 
                    precision="38" type="java.lang.Integer"/>
   </class>
</hibernate-mapping>
 
 
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
  "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="biz.c24.io.xmltest.schema.example.v0.v0.v0" auto-import="false">
   <class lazy="false" name="biz.c24.io.xmltest.schema.example.v0.v0.v0.PurchaseorderLocalImpl">
      <id unsaved-value="null" name="idKey">
         <generator class="native"/>
      </id>
      <property name="_io_aux" 
            length="8000" 
            access="biz.c24.io.api.presentation.AuxilaryAccessor" 
            type="text"/>
      <property name="_substitutionClass" 
            length="8000" 
            access="biz.c24.io.api.presentation.SubstitutionAccessor" 
            type="java.lang.String"/>
      <many-to-one column="customer" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                class="biz.c24.io.xmltest.schema.example.v0.v0.v0.CustomerImpl" 
                name="customer"/>
      <property name="date" 
                column="date" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                type="java.lang.String"/>
      <list access="biz.c24.io.api.presentation.CollectionAccessor" 
                lazy="false" 
                table="lineitem" 
                name="line-item">
         <key>
            <column name="purchaseorder_lineitem_id"/>
         </key>
         <list-index column="_index"/>
         <one-to-many class="biz.c24.io.xmltest.schema.example.v0.v0.v0.LineitemImpl"/>
      </list>
      <many-to-one column="shipper" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                class="biz.c24.io.xmltest.schema.example.v0.v0.v0.ShipperImpl" 
                name="shipper"/>
      <property name="empty" 
                column="empty" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                type="java.lang.String"/>
      <property name="trim" 
                column="trim" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                type="java.lang.String"/>
      <property name="ok-ok" 
                column="okok" 
                access="biz.c24.io.api.presentation.PropertyAccessor" 
                type="java.lang.Boolean"/>
   </class>
</hibernate-mapping>

[code tags added - Paul Sturrock]
[ January 24, 2006: Message edited by: Paul Sturrock ]

[Divan Mostert]

Does anyone have an idea???