Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version:
Latest of homepage, 2.1.7 I believe
Mapping documents:
Code:
<class
name="com.borderconnect.domain.shipment.sequence.Sequence"
table="shipment_sequence"
>
<id name="id" column="id" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">shipment_sequence_id_seq</param>
</generator>
</id>
<property name="dateCreated" column="date_created" />
<many-to-one name="creator" column="creator_id"
class="com.borderconnect.domain.Person" />
<component name="shipmentType" class="com.borderconnect.domain.shipment.ShipmentType">
<property name="name" column="shipment_type" />
</component>
<bag name="shipments" table="shipment" lazy="true" inverse="true"
cascade="all" order-by="to_number(cargoControlNumber.sequence,'999999999999999999999') asc"
>
<key column="shipment_sequence_id"/>
<one-to-many class="com.borderconnect.domain.shipment.Shipment"/>
</bag>
</class>
Postgres 8
The generated SQL (show_sql=true):Code:
[17:53:00,875]DEBUG SQL:229 - select sequence0_.id as id0_, shipments1_.id as id1_, sequence0_.date_created as date_cre2_0_, sequence0_.creator_id as creator_id0_, sequence0_.shipment_type as shipment4_0_, shipments1_.carrier_code_id as carrier_2_1_, shipments1_.sequence as sequence1_, shipments1_.pars_position as pars_pos4_1_, shipments1_.transaction_number as transact5_1_, shipments1_.service_option_id as service_6_1_, shipments1_.release_office_id as release_7_1_, shipments1_.sub_location_id as sub_loca8_1_, shipments1_.container_number as containe9_1_, shipments1_.current_status_id as current10_1_, shipments1_.driver_id as driver_id1_, shipments1_.shipment_sequence_id as shipmen12_1_, shipments1_.is_purged as is_purged1_, shipments1_.shipment_sequence_id as shipmen12___, shipments1_.id as id__ from shipment_sequence sequence0_ left outer join shipment shipments1_ on sequence0_.id=shipments1_.shipment_sequence_id where (sequence0_.id=? ) order by shipments1_.to_number(cargoControlNumber.sequence, shipments1_.'999999999999999999999') asc
As you can see in the mapping, I'm doing "order-by="to_number(cargoControlNumber.sequence,'999999999999999999999') asc" for the shipments bag. This order by works in postgres just fine. However, Hibernate doesn't understand the use of the function/parameters and generates the following SQL problem:
Code:
order by shipments1_.to_number(cargoControlNumber.sequence, shipments1_.'999999999999999999999') asc
Is there any way to tell Hibernate to generate the proper SQL? Thanks
Login
FAQ
Search
