How can I use MySQL assign operator(:=) in hibernate native query?

by

Note that HHH-2697 is now fixed for Hibernate 4.1.3 You can now escape with backslash:

SELECT k.`news_master_id` AS id, @row \:= @row + 1 AS rownum 
    FROM keyword_news_list k 
    JOIN (SELECT @row \:= 0) r 
    WHERE k.`keyword_news_id` = :kid
ORDER BY k.`news_master_id` ASC

More Related Contents:

  1. Hibernate 5 :- org.hibernate.MappingException: Unknown entity
  2. Using Hibernate’s ScrollableResults to slowly read 90 million records
  3. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  4. Unable to get spring boot to automatically create database schema
  5. Hibernate: Automatically creating/updating the db tables based on entity classes
  6. No Dialect mapping for JDBC type: 1111
  7. @GeneratedValue polymorphic abstract superclass over MySQL
  8. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  9. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  10. Spring, Hibernate, Blob lazy loading
  11. Enum in Hibernate, persisting as an enum
  12. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  13. Hibernate Criteria Query to get specific columns
  14. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  15. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  16. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  17. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  18. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  19. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  20. org.hibernate.InstantiationException: No default constructor for entity: : principal.Cliente
  21. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  22. How to setup Hibernate to read/write to different datasources?
  23. Hibernate Criteria API: get n random rows
  24. Unable to get multiple Table entities through Stored procedure using hibernate
  25. Make hibernate backquote all table / column names
  26. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  27. How should equals and hashcode be implemented when using JPA and Hibernate
  28. Can add extra field(s) to @ManyToMany Hibernate extra table?
  29. @BatchSize a smart or stupid use?
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment