How to convert Oracle type object to Java object using Hibernate / JPA?

Question

Basically what I'm trying to do is a call to Oracle stored procedure using Hibernate. Procedure takes two IN parameters, creates object of Oracle type User (it has two fields - id and name) and returns it via OUT parameter. My Java call is:

ProcedureCall call = session.createStoredProcedureCall("get_obj");
call.registerParameter(1, Long.class, ParameterMode.IN).bindValue(1L);
call.registerParameter(2, String.class, ParameterMode.IN).bindValue("John");
call.registerParameter(3, User.class, ParameterMode.OUT);

Java class is simple POJO class with same fields, setters and getters. Is there a way to convert Oracle types to Java and vice versa?

Karol Dowbecki · Accepted Answer · 2019-01-07 16:57:03Z

1

As per Using Customized Type Mappings you should create a User class by implementing SQLData interface:

public class User implements SQLData {
  // fields
  // readSQL
  // writeSQL
}

and then use Connection.setTypeMap() to setup the mapping for new User type.

answered Jan 7, 2019 at 16:57

Karol Dowbecki

45.3k9 gold badges83 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bilgehan Over a year ago

is it same in hibernate,for pure jdbc I use it but in hibernate?

Collectives™ on Stack Overflow

How to convert Oracle type object to Java object using Hibernate / JPA?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related