Hibernate Community • View topic - Help needed on query where one table has no class equivalent

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Help needed on query where one table has no class equivalent

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

minos5000

Post subject: Help needed on query where one table has no class equivalent

Posted: Tue Aug 31, 2010 4:09 am

Newbie

Joined: Thu May 06, 2010 5:58 am
Posts: 1

Hi,

I'm new to hibernate and now have the task to make the following variable transient:

Code:

   @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.EAGER)
   @Fetch(value=FetchMode.JOIN)
   @javax.persistence.MapKey(name="adressNr")
   @JoinTable(name="VS_Partner_Adr",  joinColumns={@JoinColumn(name="Partner_nr")}, inverseJoinColumns={@JoinColumn(name="Adress_nr")})
   private Map<String, Adress> adressMap = new HashMap<String, Adress>();

My question is, how do I do a join in an oql statement when this no class representation of one of the two tables, in this case "VS_Partner_Adr".
Is something like the query below possible and if so, how?

Code:

"select " + Adresse.class.getName() + " as adresse inner join " + " VS_PARTNER_ADR as padr on padr.adresse_nr = adresse.adressenr where padr.partner_nr = '10029100'"

Thanks,
Minos

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum