Results 1 to 2 of 2
- 10-29-2009, 04:24 PM #1
Member
- Join Date
- Oct 2009
- Posts
- 2
- Rep Power
- 0
Hibernate Join Query - Should be easy
I am pretty new at using hibernate and need some help.
I want to perform the bellow query in hibernate but can't seem to get the syntax correct. I am using a Postgres database.
This query works when I run directly on the database:
I have attached my hibernate configJava Code:SELECT x, y FROM submissions AS s JOIN submissions_new AS sn ON (s.id = sn.submission_id) JOIN submissions_edited_voyages AS ev ON (sn.editor_edited_voyage_id = ev.id) JOIN voyages AS v ON (ev.voyage_iid = v.iid) WHERE s.id = 1793231;
Thanks for the help!!!
- 10-29-2009, 05:48 PM #2
Senior Member
- Join Date
- Aug 2009
- Posts
- 2,388
- Rep Power
- 6
Similar Threads
-
Help query with hibernate
By wonderbiker in forum JDBCReplies: 0Last Post: 04-14-2009, 11:12 AM -
Regarding Join
By adeeb in forum JDBCReplies: 1Last Post: 06-24-2008, 07:57 PM -
How to use join() method
By Java Tip in forum java.langReplies: 0Last Post: 04-09-2008, 06:33 PM -
Hibernate sql query
By taicode in forum JDBCReplies: 0Last Post: 03-25-2008, 04:17 PM -
Hibernate order by query thru java solution urgently reqd
By altaf in forum JDBCReplies: 0Last Post: 03-12-2008, 02:23 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks