Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?

by

Have you looked at the Hibernate @SQLInsert Annotation?

@Entity
@Table(name="story_count")
@SQLInsert(sql="INSERT INTO story_count(id, view_count) VALUES (?, ?)
 ON DUPLICATE KEY UPDATE view_count = view_count + 1" )
public class StoryCount

More Related Contents:

  1. Enum in Hibernate, persisting as an enum
  2. JPA JoinColumn vs mappedBy
  3. Hibernate Annotations – Which is better, field or property access?
  4. What’s the difference between JPA and Hibernate? [closed]
  5. What is the solution for the N+1 issue in JPA and Hibernate?
  6. Hibernate 5 :- org.hibernate.MappingException: Unknown entity
  7. Bypass GeneratedValue in Hibernate (merge data not in db?)
  8. How should equals and hashcode be implemented when using JPA and Hibernate
  9. Using Hibernate’s ScrollableResults to slowly read 90 million records
  10. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  11. Hibernate – @ElementCollection – Strange delete/insert behavior
  12. session.connection() deprecated on Hibernate?
  13. Automatic reserved word escaping for Hibernate tables and columns
  14. Location of hibernate.cfg.xml in project?
  15. What’s the use of session.flush() in Hibernate
  16. @GeneratedValue polymorphic abstract superclass over MySQL
  17. Spring, Hibernate, Blob lazy loading
  18. How can I use MySQL assign operator(:=) in hibernate native query?
  19. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  20. Hibernate Criteria Query to get specific columns
  21. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  22. Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
  23. Specifying an Index (Non-Unique Key) Using JPA
  24. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  25. How does Hibernate detect dirty state of an entity object?
  26. Hibernate throws strange error: Class is not mapped
  27. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  28. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  29. Hibernate @PostLoad never gets invoked
  30. HQL recursion, how do I do this?

Leave a Comment