What are the pros and cons of using [Criteria][1] or [HQL][2]? The Criteria API is a nice object-oriented way to express queries in Hibernate, but sometimes Criteria Queries are more difficult to understand/build than HQL. 

When do you use Criteria and when HQL? What do you prefer in which use cases? Or is it just a matter of taste?


  [1]: http://docs.jboss.org/hibernate/orm/4.1/manual/en-US/html/ch17.html
  [2]: http://docs.jboss.org/hibernate/orm/4.1/manual/en-US/html/ch16.html

JPA and Hibernate - Criteria vs. JPQL or HQL

I have 2 classes in a one-to-many relationship and a HQL query that is a bit strange. Even if I have read some questions already posted, it does not seem clear to me.

    Class Department{
       @OneToMany(fetch=FetchType.EAGER, mappedBy=&quot;department&quot;)
       Set&lt;Employee&gt; employees;
    }
    Class Employee{
       @ManyToOne
       @JoinColumn(name=&quot;id_department&quot;)
       Department department;
    }

When I use the following query I get duplicates Department objects: 

`session.createQuery(&quot;select dep from Department as dep left join dep.employees&quot;);`

Thus, I have to use distinct:

`session.createQuery(&quot;select distinct dep from Department as dep left join dep.employees&quot;);`

Is this behaviour an expected one? I consider this unusual, as comparing it with SQL.

One-To-Many relationship gets duplicate objects without using &quot;distinct&quot;. Why?

I have the HQL where I trying to get artifacts that have no classification (when active is 0)

    artifacts = Artifact.findAll(&quot;FROM Artifact WHERE id NOT IN ( SELECT artifact_id FROM Classification WHERE active = 1) AND document_id = :docid&quot;,[docid:document.id], [max:limit, offset:startIndex]);
    							
Whenever I run I get the error



    java.lang.IllegalStateException: No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode 
     \-[IDENT] IdentNode: &#39;artifact_id&#39; {originalText=artifact_id}
   
Classificaiton definition:

    class Classification {
    
        public static final String USER_DEFAULT = &quot;USER&quot;
        public static final String USER_SYSTEM = &quot;SYSTEM&quot;
    
        TaxonomyNode node
        String artifactId 
        Boolean active
        String createdBy
        String updatedBy
        Date dateCreated
        Date lastUpdated
       
    
        static constraints = {
            node nullable:false, blank:false
            artifactId nullable:false, blank:false, unique: [&#39;node&#39;]
            active nullable: false, blank: false
            createdBy nullable:false, blank:false
            updatedBy nullable:false, blank:false
        }
    
        static mapping = {
            id generator:&#39;sequence&#39;, params:[sequence:&#39;classification_seq&#39;]
            artifactId index: &#39;classify_by_artifact_node&#39;
            node index: &#39;classify_by_artifact_node&#39;
            active defaultValue: &quot;1&quot;
        }
    }
You can refer to previous problems I faced to understand what exactly I am trying to do [Quest 1][1] and [Quest 2][2]


  [1]: https://stackoverflow.com/questions/26469285/sql-to-hql-query-grails
  [2]: https://stackoverflow.com/questions/26467420/how-to-check-null-or-not-valid-in-hql-query

No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL

I need to combine 2 tables using hql, both are having common column, but `table1` common column is `integer` and `table2` common column is `String`

For example,
    
    select a.id as id,a.name as name,b.address as address 
    from Personal as a,Home as b 
    where a.id=b.studid


Here `a.id` is an `integer` while `b.stduid` is a `string`, but Data of both columns is the same.

How can I get the result of the query using hql query?

How do I write hql query with cast?

In Hibernate 3, is there a way to do the equivalent of the following MySQL limit in HQL?

    select * from a_table order by a_table_column desc limit 0, 20;

I don&#39;t want to use setMaxResults if possible. This definitely was possible in the older version of Hibernate/HQL, but it seems to have disappeared.


How do you do a limit query in JPQL or HQL?

Please help me understand where to use a regular JOIN and where a JOIN FETCH. For example, if we have these two queries

    FROM Employee emp
    JOIN emp.department dep
and

    FROM Employee emp
    JOIN FETCH emp.department dep

Is there any difference between them? If yes, which one to use when?

What is the difference between JOIN and JOIN FETCH when using JPA and Hibernate

I have written a query to delete some objects in my interface extending `JPaRepository`, but when I execute the query it throws an exception! 
Can anyone explain it for me?

Query:

    public interface LimitRepository extends JpaRepository&lt;CLimit, Long&gt; {
  
      @Query(&quot;delete from CLimit l where l.trader.id =:#{#trader.id}&quot;)
      void deleteLimitsByTrader(@Param(&quot;trader&quot;) CTrader trader);

    }

I got this error, can anyne Please, explain this for me, and thank you all  :)

Exception:

      org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [delete from com.query.domain.CLimit l where l.trader.id =:__$synthetic$__1]
          at org.hibernate.hql.internal.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:318)
          at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:369)
          at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
          at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
          at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
          at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
          at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:364)
          at com.sun.proxy.$Proxy98.getSingleResult(Unknown Source)
          at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:206)
          at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:78)
          at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:102)
          at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:92)
          at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:482)
          at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:460)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
          at com.sun.proxy.$Proxy88.deleteLimitsByTrader(Unknown Source)
          at com.query.service.impl.LimitServiceImpl.deleteLimitsByTrader(LimitServiceImpl.java:138)
          at com.query.controller.UserController.deleteUser(UserController.java:96)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
          at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
          at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
          at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:814)
          at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:737)
          at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
          at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
          at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
          at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
          at org.springframework.web.servlet.FrameworkServlet.doDelete(FrameworkServlet.java:893)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:656)
          at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
          at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:133)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
          at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)
          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
          at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
          at java.lang.Thread.run(Thread.java:745)

JpaRepository Not supported for DML operations [delete query]

Is there a way to create a Distinct query in HQL.  Either by using the &quot;distinct&quot; keyword or some other method.  I am not sure if distinct is a valid keywork for HQL, but I am looking for the HQL equivalent of the SQL keyword &quot;distinct&quot;.

How do you create a Distinct query in HQL

What is the difference between an `INNER JOIN` and `LEFT SEMI JOIN`? 

In the scenario below, why am I getting two different results? 

The `INNER JOIN` result set is a lot larger. Can someone explain? I am trying to get the names within `table_1` that only appear in `table_2`.

    SELECT name
    FROM table_1 a
        INNER JOIN table_2 b ON a.name=b.name

    SELECT name
    FROM table_1 a
        LEFT SEMI JOIN table_2 b ON (a.name=b.name)

Difference between INNER JOIN and LEFT SEMI JOIN

I have the following parametrised JPA, or Hibernate, query:

    SELECT entity FROM Entity entity WHERE name IN (?)

I want to pass the parameter as an ArrayList&amp;lt;String&gt;, is this possible? Hibernate current tells me, that

    java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.String

Is this possible at all?

**ANSWER**: Collections as parameters only work with named parameters like &quot;`:name`&quot;, not with JDBC style parameters like &quot;`?`&quot;.

IN-clause in HQL or Java Persistence Query Language

Assuming that I want to write the following HQL query:

    FROM Cat c WHERE c.id IN (1,2,3)

what is the proper way of writing this as a parametrized query, e.g.

    FROM Cat c WHERE c.id IN (?)



Proper way of writing a HQL in ( ... ) query

I&#39;d like to use Hibernate&#39;s criteria api to formulate a particular query that joins two entities. Let&#39;s say I have two entities, Pet and Owner with a owner having many pets, but crucially that association is not mapped in the Java annotations or xml.

With hql, I could select owners that have a pet called &#39;fido&#39; by specifying the join in the query (rather than adding a set of pets to the owner class).

Can the same be done using hibernate criteria? If so how?

Thanks,
J

Hibernate criteria: Joining table without a mapped association

When I write a HQL query

    Query q = session.createQuery(&quot;SELECT cat from Cat as cat ORDER BY cat.mother.kind.value&quot;);
    return q.list();

Everything is fine. However, when I write a Criteria

    Criteria c = session.createCriteria(Cat.class);
    c.addOrder(Order.asc(&quot;mother.kind.value&quot;));
    return c.list();

I get an exception `org.hibernate.QueryException: could not resolve property: kind.value of: my.sample.data.entities.Cat`

If I want to use Criteria and Order, how should I express my &quot;order by&quot;?

ORDER BY using Criteria API

I am trying following hql query to execute

    SELECT count(*) 
      FROM BillDetails as bd
     WHERE bd.billProductSet.product.id = 1002
       AND bd.client.id                 = 1

But it is showing 

    org.hibernate.QueryException: illegal attempt to dereference collection 
    [billdetail0_.bill_no.billProductSet] with element property reference [product] 
    [select count(*) from iland.hbm.BillDetails as bd where bd.billProductSet.product.id=1001 and bd.client.id=1]
    	at org.hibernate.hql.ast.tree.DotNode$1.buildIllegalCollectionDereferenceException(DotNode.java:68)
    	at org.hibernate.hql.ast.tree.DotNode.checkLhsIsNotCollection(DotNode.java:558)



org.hibernate.QueryException: illegal attempt to dereference collection

I have been reading some anwers, but i&#39;m still confused. &#191;Why? because the differences that you have mentioned do not relate with the performance. they are related with easy use.(Objetc(criteria) and SQL(hql)). But I would like to know if &quot;criteria&quot; is slower than hql for some reason.

I read this in another anwers

&quot;There is a difference in terms of performance between HQL and criteriaQuery, everytime you fire a query using criteriaQuery, it creates a new alias for the table name which does not reflect in the last queried cache for any DB. This leads to an overhead of compiling the generated SQL, taking more time to execute.&quot; by Varun Mehta.

This is very close BUT! i read in another website(http://gary-rowe.com/agilestack/tag/hibernate/) This is no longer the case with Hibernate 3.3 and above(please read this: 9) Hibernate is slow because the SQL generated by the Criteria interface is not consistent)

I have done some test trying to find out the differences but both generate qry&#39;s and it doesn&#39;t change the alias to the table.

I&#39;m very confused. If somebody knows the main reason please, could you help us. Thanks


Hibernate Criteria vs HQL: which is faster?

Given the following HQL Query:

    FROM
        Foo
    WHERE
        Id = :id AND
        Bar IN (:barList)

I set `:id` using the Query object&#39;s `setInteger()` method. 

I would like to set `:barList` using a `List` of objects, but looking at the Hibernate documentation and list of methods I cannot see an obvious choice of which to use. Any ideas?

Hibernate HQL Query : How to set a Collection as a named parameter of a Query?

As far as I understand;

- sort by only sorts with in the reducer

- order by orders things globally but shoves everything into one reducers

- cluster by intelligently distributes stuff into reducers by the key hash and make a sort by

So my question is does cluster by guarantee a global order? distribute by puts the same keys into same reducers but what about the adjacent keys? 

The only document I can find on this is [here][1] and from the example it seems like it orders them globally. But from the definition I feel like it doesn&#39;t always do that.


 [1]:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy

Hive cluster by vs order by vs sort by

I am trying to understand the difference between `LEFT JOIN` and `LEFT JOIN FETCH` in Hibernate.

Can anyone explain this?

Thanks

Difference between LEFT JOIN and LEFT JOIN FETCH in Hibernate?

I have below code in my DAO:  

    String sql = &quot;SELECT COUNT(*) FROM CustomerData &quot; +
                 &quot;WHERE custId = :custId AND deptId = :deptId&quot;;
    Query query = session.createQuery(sql);
    query.setParameter(&quot;custId&quot;, custId);
    query.setParameter(&quot;deptId&quot;, deptId);
    long count = (long) query.uniqueResult(); // ERROR THROWN HERE
    
Hibernate throws  below exception at the marked line:
    
&gt; org.hibernate.NonUniqueResultException: query did not return a unique result: 
        
   I am not sure whats happening as `count(*)` will always return only one row. 

Also when i run this query on db directly, it return result as 1. So whats the issue?

org.hibernate.NonUniqueResultException: query did not return a unique result: 2?

This has been asked once before but the solution did not solve the issue. I am creating a JUnit test:

     @Test
        @Transactional
        @Modifying
        public void updateMaterialInventory() throws Exception{
    
            // Initialize the database
            materialRepository.saveAndFlush(material);
    
            long id =  material.getId();
            materialRepository.updateMaterialInventory(id,UPDATED_INVENTORY_COUNT);
    
            assertEquals(material.getInventory_count(), UPDATED_INVENTORY_COUNT, 0);
        }

The query the above test is calling is:
   

     @Query(&quot;UPDATE Material m SET m.inventory_count = ?2 WHERE m.id = ?1&quot;)
        void updateMaterialInventory(Long id,int newInventoryAmount);

Error:


    Caused by: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [UPDATE com.htd.domain.Material m SET m.inventory_count = ?2 WHERE m.id = ?1]
    	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:318)
    	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:369)
    	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231)
    	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)
    	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
    	at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
    	... 55 more



All Hql Solutions on Gang of Coders

Total of 20 Hql Solutions