Hibernate Community • View topic - MySQL on duplicate key update and EntityManager

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

MySQL on duplicate key update and EntityManager

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kakoni

Post subject: MySQL on duplicate key update and EntityManager

Posted: Thu May 22, 2008 5:31 am

Newbie

Joined: Tue Nov 27, 2007 5:29 am
Posts: 9

I'm trying out this;

Code:

entityManager.createNativeQuery("insert into resource_hits (portal_id, hour, resource, hits) values (:portalId,:hour,:resource,:hits) on duplicate key update hits=hits+:hits");

This gets translated to;
Hibernate: insert into resource_hits (hits, resource, hour, portal_id) values (?, ?, ?, ?)

Wonder why that duplicate key part is thrown out?

Top

kakoni

Post subject:

Posted: Thu May 22, 2008 5:48 am