hi,
i have user-defined type in oracle db:
create or replace
TYPE "OBJ_NOSILAC_OSIGURANJA" AS OBJECT (
INSURANCE_HOLDER CHAR(1),
INSURANCE_HOLDER_FIRSTNAME VARCHAR2(30),
INSURANCE_HOLDER_LASTNAME VARCHAR2(30),
INSURANCE_HOLDER_P_NUMBER VARCHAR2(13),
INSURANCE_HOLDER_INSURANCE VARCHAR2(11),
MEMBER FUNCTION get_INSURANCE_HOLDER RETURN CHAR,
MEMBER FUNCTION get_INSURANCE_HOLDER_FIRSTNAME RETURN VARCHAR2,
MEMBER FUNCTION get_INSURANCE_HOLDER_LASTNAME RETURN VARCHAR2,
MEMBER FUNCTION get_INSURANCE_HOLDER_P_NUMBER RETURN VARCHAR2,
MEMBER FUNCTION get_INSURANCE_HOLDER_INSURANCE RETURN VARCHAR2
) instantiable not final;
also, i have table that use that type:
CREATE TABLE "DENTIST"."PATIENT_DETAIL"
( "ID_PATIENT" NUMBER(*,0) NOT NULL ENABLE,
"INSURANCE_HOLDER" "DENTIST"."OBJ_NOSILAC_OSIGURANJA" ,......)
in my procest, i used JPA with eclipselink 2.5.0 and have entity java class:
@Entity
@Table(name="patient_detail")
public class Patient {
private Integer id_patient;
....
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
public Integer getId_patient() {
return id_patient;
}
public void setId_patient(Integer id_patient) {
this.id_patient = id_patient;
}
i don't know how to use field in my class with user-defined type in oracle db?