I'm a beginner with hibernate. I have a void function in PostgreSQL with 10 arguments (it's a "create or update" function) and I want to use it in my application.
I read that doing a Native Query is the simplest way.
So I wrote this code:
Session session = HibernateUtil.getSessionFactory().openSession();
session.beginTransaction();
String a = "SELECT fun('text', 'text', 12345678987, 'text', 'text', 50, 37500, 133456788, 'text', 2);
session.createNativeQuery(a);
session.getTransaction().commit();
session.close();
The application starts without any errors, but when I check the database I don't have new record.
Can someone explain what is wrong? Should I do something else with the function?
When I check database I don't have new rekord
Ofc you don't, you are doing a SELECT, so you're not doing anything in your database.
Also in order to execute your query you don't need to open any transaction since you are not inserting/updating/deleting anything, and you need to do the following to get the result:
session.createNativeQuery(a).getResultList() if you expect multiple results from this query
session.createNativeQuery(a).getSingleResult() if you expect only one result.
session.createNativeQuery(a).executeUpdate() if you're actually inserting/updating/deleting something, in that case you will need the transaction like you did in your code.