cdmlib-model/src/main/java/eu/etaxonomy/cdm/hibernate/BigDecimalUserType.java

   1 /**
   2  *
   3  */
   4 package eu.etaxonomy.cdm.hibernate;
   5
   6 import java.io.Serializable;
   7 import java.math.BigDecimal;
   8 import java.sql.PreparedStatement;
   9 import java.sql.ResultSet;
  10 import java.sql.SQLException;
  11 import java.sql.Types;
  12
  13 import org.hibernate.HibernateException;
  14 import org.hibernate.engine.spi.SessionImplementor;
  15 import org.hibernate.type.StandardBasicTypes;
  16 import org.hibernate.usertype.UserType;
  17
  18 /**
  19  * This software is public domain and carries NO WARRANTY.
  20  *
  21  * Patches, bug reports and feature requests welcome:
  22  *
  23  * https://bitbucket.org/ratkins/bigdecimalusertype/
  24  */
  25 public class BigDecimalUserType implements UserType {
  26
  27         private static final int[] SQL_TYPES = new int[] {Types.DECIMAL, Types.INTEGER};
  28
  29         @Override
  30         public Object assemble(Serializable arg0, Object arg1) throws HibernateException {
  31                 return deepCopy(arg0);
  32         }
  33
  34         @Override
  35         public Object deepCopy(Object arg0) throws HibernateException {
  36                 return arg0;
  37         }
  38
  39         @Override
  40         public Serializable disassemble(Object arg0) throws HibernateException {
  41                 return (Serializable) arg0;
  42         }
  43
  44         @Override
  45         public boolean equals(Object arg0, Object arg1) throws HibernateException {
  46                 return arg0.equals(arg1);
  47         }
  48
  49         @Override
  50         public int hashCode(Object arg0) throws HibernateException {
  51                 return arg0.hashCode();
  52         }
  53
  54         @Override
  55         public boolean isMutable() {
  56                 return false;
  57         }
  58
  59         @Override
  60         public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner) throws HibernateException, SQLException {
  61                 BigDecimal bigDecimal = (BigDecimal) StandardBasicTypes.BIG_DECIMAL.nullSafeGet(rs, names, session, owner);
  62
  63 //              BigDecimal bigDecimal = rs.getBigDecimal(names[0]);
  64                 if (bigDecimal == null) {
  65                         return null;
  66                 }
  67                 return bigDecimal.setScale(rs.getInt(names[1]), BigDecimal.ROUND_HALF_UP);
  68         }
  69
  70
  71         @Override
  72         public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session) throws HibernateException, SQLException {
  73                 if (value == null) {
  74                         StandardBasicTypes.BIG_DECIMAL.nullSafeSet(st, null, index, session);
  75                         StandardBasicTypes.INTEGER.nullSafeSet(st, null, index, session);
  76
  77 //                      st.setNull(index, Types.DECIMAL);
  78 //                      st.setNull(index + 1, Types.INTEGER);
  79                 } else {
  80                         BigDecimal bdec = (BigDecimal)value;
  81 //                      st.setBigDecimal(index, bdec);
  82 //                      st.setInt(index + 1, bdec.scale());
  83                         StandardBasicTypes.BIG_DECIMAL.nullSafeSet(st, bdec, index, session);
  84                         StandardBasicTypes.INTEGER.nullSafeSet(st, bdec.scale(), index + 1, session);
  85                 }
  86         }
  87
  88
  89         @Override
  90         public Object replace(Object arg0, Object arg1, Object arg2) throws HibernateException {
  91                 return arg0;
  92         }
  93
  94         @Override
  95         public Class<?> returnedClass() {
  96                 return BigDecimal.class;
  97         }
  98
  99         @Override
 100         public int[] sqlTypes() {
 101                 return SQL_TYPES;
 102         }
 103
 104
 105
 106 }