I'm trying to mapp java.lang.Boolean to Oracle char/varchar2

the details given below

ORACLE Table

Column TYPE
--------------------------
EMP_ID NUMBER(6) PK
EMP_FNAME VARCHAR2(30)
EMP_STATUS VARCHAR2(5)


Hibernate Mapping file

<class name="Employee" table="EMP">
<id name="empId" type="java.lang.Long" column="EMP_ID">
<generator class="increment"/>
</id>
<property name="empName" type="java.lang.String" column="EMP_FNAME"/>
<property name="empStatus" type="java.lang.Boolean" column="EMP_STATUS"/>
</class>

POJO Class

public Employee {

private java.lang.Long empId;
private java.lang.String empName;
private java.lang.Boolean empStatus;

public Employee() {
super();
}

public java.lang.Long getEmpId() {
return this.empId;
}
public void setEmpId(java.lang.Long empId) {
this.empId = empId;
}

public java.lang.String getEmpName() {
return this.empName;
}
public void setEmpName(java.lang.String empName) {
this.empName = empName;
}

public java.lang.Boolean getEmpStatus() {
return this.empStatus;
}
public void setEmpStatus(java.lang.Boolean empStatus) {
this.empStatus = empStatus;
}
}

How do I map java Boolean to Oracle VARCHAR2

Please Help me for this issue...

Hi pulikkottil

Try type ="yes_no"

Hi dharmendra.pandey,

Thanks Dharmendra....