Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Hibernate One to Many Mapping without foreign key  RSS feed

Prashant Techie
Posts: 3
  • 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">
<one to many class = "Position">
<loader query-ref = "positionquery" >

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


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.

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!