I am using Spring HibernateTemplate and need to insert hundreds of records into a mysql database every second.
Not sure what is the most performant way of doing it, but I am trying to see how the multi value mysql inserts do using hibernate.
String query = "insert into user(age, name, birth_date) values(24, 'Joe', '2010-05-19 14:33:14'), (25, 'Joe1', '2010-05-19 14:33:14')"
getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
return session.createSQLQuery(query).executeUpdate();
}
});
But I get this error:
'could not execute native bulk manipulation query.' Please check your query .....
Any idea of I can use a multi value mysql insert using Hibernate? or is my query incorrect?
Any other ways that I can improve the performance? I did try the saveOrUpdateAll() method, and that wasn't good enough!
