Find Jobs
Hire Freelancers

Convert a tradtional sql to HQL syntax.

$2-4 USD / hour

Completed
Posted almost 9 years ago

$2-4 USD / hour

Dear Ladies and Gentlemen, Could you please help me to convert the following traditnal sql to HQL: It has to be a working syntax when using in java EntityManager [login to view URL](...) clause. select [login to view URL] as root_name , [login to view URL] as down1_name , [login to view URL] as down2_name , [login to view URL] as down3_name from categories as root left outer join categories as down1 on [login to view URL] = [login to view URL] left outer join categories as down2 on [login to view URL] = [login to view URL] left outer join categories as down3 on [login to view URL] = [login to view URL] where [login to view URL] is null order by root_name , down1_name , down2_name , down3_name Thanks Sam
Project ID: 7887238

About the project

12 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I may be right or wrong - would have to test it on my own, but its not worth 2$, so Ill just try to post the raw one. You can reward me if I was correct / helped:) select [login to view URL], [login to view URL], [login to view URL], [login to view URL] from category c left join [login to view URL] as c1 left join [login to view URL] as c2 left join [login to view URL] as c3 where [login to view URL] is null order by [login to view URL], [login to view URL], [login to view URL], [login to view URL]; then your Entity objects should be as follows: (draft): @Entity public class Category { ... @ManyToOne @JoinColumn(name="parentid", nullable=true) private Category parent; @OneToMany(mappedBy="parent") private List<Category> children; private String name; ... }
$2 USD in 1 day
0.0 (0 reviews)
0.0
0.0
12 freelancers are bidding on average $4 USD/hour for this job
User Avatar
Hello i am hibernate expert please hire me for this project.................................................................................
$4 USD in 3 days
4.6 (12 reviews)
4.4
4.4
User Avatar
Hi, I am Senior Java Developer and working JPA/Hibernate frameworks. Thank you for your consideration and looking forward working with you. Regards, Shameem
$5 USD in 4 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I am interested in this project as it is exactly within our scope of expertise I have very good experience in development of applications, websites and web portals. I am very anxious to develop a relationship with you and I would be grateful for any opportunity to enable me to earn your confidence in our services. I can personally assure you that your business is very meaningful to me and will receive the highest degree of attention and that your confidence in me will not be misplaced. Your requirement can be fixed by criterions or join with comma without using JOIN keyword.
$3 USD in 10 days
4.7 (2 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
$3 USD in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
Ainda não foi fornecida uma proposta
$11 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My past experience on JPA and HQL makes me the apt developer for the project. I would start by creating the prototype and share the same with you.
$3 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I do J2EE/Hibernate development in my day Job. Contact me and i would send the converted version. Thanks.
$5 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am working with JPA to build projects, maybe i will help, support and explain for you :) Thanks so much
$2 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working as java developer for past 2 year. I have been working upon Spring/Hibernate framework for past 2 year.
$5 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Prospect, Australia
5.0
73
Payment method verified
Member since Sep 26, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.