This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate generating queries with duplicate columns

 
Amey Dhoke
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am facing a issue with the query generated by hibernate to load from database.

SELECT this_.id AS id25_1_,
this_.name AS name25_1_,
offices2_.legal_entity_id AS legal3_3_,
offices2_.id AS id3_,
offices2_.id AS id27_0_,

offices2_.name AS name27_0_,
offices2_.legal_entity_id AS legal3_27_0_
FROM cm.legal_entities this_
LEFT OUTER JOIN cm.offices offices2_ ON this_.id = offices2_.legal_entity_id;

Why is hibernate generating query with duplicate reference to offices2_.id ?

My hbm file for legal_entities table is -



And hbm for office is -




Thanks in advance,
Amey
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No idea I'm afraid. Does it cause a problem?
 
Amey Dhoke
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

This is not causing any problem, just that I am curious to know.

Looks like the way hibernate code works is, it adds columns from the joined table and it adds the same columns again if type join is LEFT_OUTER_JOIN. (The logic is in selectFragment() method of OneToManyPersister class)
Looks like it is a bug but im not sure if there is any other purpose behind this logic.

Any idea ?


Thanks,
Amey
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic