wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Hibernate One to Many Mapping without foreign key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate One to Many Mapping without foreign key " Watch "Hibernate One to Many Mapping without foreign key " New topic
Author

Hibernate One to Many Mapping without foreign key

Prashant Techie
Greenhorn

Joined: Sep 29, 2012
Posts: 3
Dear all,

I have a Security Class (ISIN, ID, Account, Price, Exchange) and a Position class (ID, Tick Size, Buy/Sell, Market Price, Account, Exchange).
There is no definite foreign key between Security and Position except what I want is One Security to Many Position relation ship based on Account, Exchange.
So I have created two classes, Added Set<Position> to Security Class and in hibernate mapping I am giving below details:
<Set name="Positions" lazy="false">
<[color=blue]key
/>
<one to many class = "Position">
<loader query-ref = "positionquery" >
</set>[/color]

and query is like:
<sql query name = "positionquery">
<loadcollection alias ="pos" role="security.positions">
[color=darkred]cdata
select pos.* from Positions where pos.id = ?

</sqlquery>[/color]

Could you tell me how should I write the query such that instead of id it will consider account and exchange? or am I supposed to give a key ? or basically any better way of doing this.

Cheers,
Prashant
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate One to Many Mapping without foreign key