How to call an Oracle function from Hibernate with a return parameter?

by

Hibernate Session provides a doWork() method that gives you direct access to java.sql.Connection. You can then create and use java.sql.CallableStatement to execute your function:

session.doWork(new Work() {
  public void execute(Connection connection) throws SQLException {
    CallableStatement call = connection.prepareCall("{ ? = call MYSCHEMA.MYFUNC(?,?) }");
    call.registerOutParameter( 1, Types.INTEGER ); // or whatever it is
    call.setLong(2, id);
    call.setLong(3, transId);
    call.execute();
    int result = call.getInt(1); // propagate this back to enclosing class
  }
});

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  3. Hibernate could not fetch the SequenceInformation from the database
  4. Need to reset the value of sequence in Oracle
  5. Hibernate sequence on oracle, @GeneratedValue(strategy = GenerationType.AUTO)
  6. Hibernate Criteria for Dates
  7. Connection cannot be cast to oracle.jdbc.OracleConnection
  8. Hibernate native query – char(3) column
  9. Is java.sql.Timestamp timezone specific?
  10. Hibernate Annotations – Which is better, field or property access?
  11. How to connect to Oracle using Service Name instead of SID
  12. What are the differences between the different saving methods in Hibernate?
  13. How do I use annotations to define different types of relationships in Hibernate 4 and Spring?
  14. Ignore fields from Java object dynamically while sending as JSON from Spring MVC
  15. Hibernate – @ElementCollection – Strange delete/insert behavior
  16. session.connection() deprecated on Hibernate?
  17. JPA SQL Server No Dialect mapping for JDBC type: -9
  18. Hibernate Mapping Package
  19. How to set a default entity property value with Hibernate
  20. Multiple fetches with EAGER type in Hibernate with JPA
  21. Java JDBC – How to connect to Oracle using tnsnames.ora
  22. Mapping array with Hibernate
  23. Manually call Spring Annotation Validation
  24. @BatchSize a smart or stupid use?
  25. Connection timeout for DriverManager getConnection
  26. Spring Data JPA and Exists query
  27. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  28. Error creating bean with name ‘entityManagerFactory
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Autowired Repository is Null in Custom Constraint Validator

Leave a Comment