<div>
hibernate supports both joins and subqueries.<br />
You could start by posting your query that you are trying to convert.
</div>


hibernate supports both joins and subqueries.
You could start by posting your query that you are trying to convert.

<div>
I will share few of sql queries whenever i am trying
</div>


I will share few of sql queries whenever i am trying

<div>
Hi <br />
<br />
Could you please convert this query hql.<br />
sql query:<br />
=========<br />
Select CI_ID,@pv:=CI_parent_CI as parentid from (select CI_ID,CI_parent_CI from master order by CI_ID desc) as master join (select @pv:=236283) tmp where CI_ID=@pv;
</div>


Hi

Could you please convert this query hql.
sql query:
=========
Select CI_ID,@pv:=CI_parent_CI as parentid from (select CI_ID,CI_parent_CI from master order by CI_ID desc) as master join (select @pv:=236283) tmp where CI_ID=@pv;

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am facing difficulties while converting my sql query into hibernate hql query.<br />
IF my sql query is small i mean with out joins and subqueries, i can easily converting that query to hql.<br />
IF my sql query having joins ,subqueries and sql query size big i am not in position to convert that into a hql.<br />
i can use native sql but in my project it is not allowed to use native sqls.<br />
<br />
i am taking much time to convert my sql query to hql query.<br />
Can any one suggest me any ideas,how quickly we can convert our mysql query to hql query.<br />
<br />
Thanks,
</div>
</div>


Hi Experts,

I am facing difficulties while converting my sql query into hibernate hql query.
IF my sql query is small i mean with out joins and subqueries, i can easily converting that query to hql.
IF my sql query having joins ,subqueries and sql query size big i am not in position to convert that into a hql.
i can use native sql but in my project it is not allowed to use native sqls.

i am taking much time to convert my sql query to hql query.
Can any one suggest me any ideas,how quickly we can convert our mysql query to hql query.

Thanks,

I am facing difficulties while converting sql query into hibernate hql query

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.

Java EE

Web Components are a set of standards currently being produced by Google engineers as a W3C specification that allow for the creation of reusable widgets or components in web documents and web applications. The intention behind them is to bring component-based software engineering to the World Wide Web. The components model allows for encapsulation and interoperability of individual HTML elements. Support for Web Components is present in Chrome and Opera and is in Firefox (with a manual configuration change). Microsoft's Internet Explorer has not implemented any Web Components specifications yet. Web Components consist of 4 main elements: Custom Elements, Shadow DOM, HTML Imports and HTML Templates.