File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate One to Many Mapping without foreign key

 
Prashant Techie
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic