So you need to save state as 1 and 2. Seems that database need refactoring... yes you are right but if you can't? Here is decision - custom type
package com.types;
import java.io.Serializable;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import org.hibernate.HibernateException;
import org.hibernate.usertype.UserType;
public class OneTwoBooleanType implements UserType{
 
 private final static int DB_TRUE = 1;
 private final static int DB_FALSE = 2;
 
 public Object assemble(Serializable cached, Object owner) throws HibernateException {
  return cached;
 }
 public Object deepCopy(Object value) throws HibernateException {
  return value;
 }
 public Serializable disassemble(Object value) throws HibernateException {
  return (Serializable) value;
 }
 public boolean equals(Object x, Object y) throws HibernateException {
  if(x==null){
   return false;
  }
  return ((Boolean)x).equals(y);
 }
 public int hashCode(Object x) throws HibernateException {
  return x.hashCode();
 }
 public boolean isMutable() {
  return false;
 }
 
 public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws HibernateException, SQLException {
  Number val = (Number) rs.getObject(names[0]);
  if(val==null){
   return false;
  }
  return val.intValue() == DB_TRUE ? true : false;
 }
 public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, SQLException {
  int dbValue;
  if(value==null){
   dbValue = DB_FALSE;
  } else {
   dbValue = (Boolean) value ? DB_TRUE : DB_FALSE;
  }
  st.setInt(index, dbValue);
 }
 public Object replace(Object original, Object target, Object owner) throws HibernateException {
  return original;
 }
 public Class returnedClass() {
  return Boolean.class;
 }
 public int[] sqlTypes() {
  return new int[]{Types.SMALLINT};
 }
}
And It's usage
@Column(name="INTERNAL_STATUS_ID")
@Type(type="com.types.OneTwoBooleanType")
private boolean isVisible;
 
 
No comments:
Post a Comment