About the author

Related Articles


  1. 1


    __________ HibernateSessionFactory.xml ___________________________
        <property name="hibernateProperties">
                <!-- <prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop> -->
                <prop key="hibernate.dialect">com.test.model.PostgreSQLDialectArray</prop>              
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
                <prop key="hibernate.generate_statistics">false</prop>
                <prop key="hibernate.connection.pool_size">10</prop>
                <prop key="hibernate.archive.autodetection">class</prop>
                <prop key="hibernate.hbm2ddl.auto">create</prop>                
                <prop key="cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
        ______________ PostgreSQLDialectArray.java _______________________
    package com.test.model;
    import java.sql.Types;
    public class PostgreSQLDialectArray extends org.hibernate.dialect.PostgreSQL82Dialect{
        public PostgreSQLDialectArray() {
            System.out.println("Register Hibernate Type ... ");
            registerHibernateType(Types.ARRAY, "array");
            System.out.println("Register Column Type ... ");
            registerColumnType(Types.ARRAY, "integer[]");
    _____________ CustomArrayType.java ______________________________
    package com.test.model;
    import java.io.Serializable;
    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Types;
    import java.sql.Array;
    import org.hibernate.*;
    import org.hibernate.engine.spi.SessionImplementor;
    import org.hibernate.usertype.UserType;
     public class CustomArrayType implements UserType
         protected static final int  SQLTYPE = java.sql.Types.ARRAY;
         private int[] toPrimitive(Integer[] array){
             int[] a = new int[array.length];
             for(int i = 0 ; i < array.length ; i++)
                 a[i] = array[i];
             return a;
         private Integer[] toObject(int[] array){
             Integer[] a = new Integer[array.length];
             for(int i = 0 ; i < array.length ; i++)
                 a[i] = array[i];
             return a;
         public Object nullSafeGet(final ResultSet rs, final String[] names, SessionImplementor session, final Object owner) throws HibernateException, SQLException {
             Array array = rs.getArray(names[0]);
             Integer[] javaArray = (Integer[]) array.getArray();
             return toPrimitive(javaArray);
         public void nullSafeSet(final PreparedStatement statement, final Object object, final int i, SessionImplementor session) throws HibernateException, SQLException {
             System.out.println("test null safe set...");
             Connection connection = statement.getConnection();
             int[] castObject = (int[]) object;
             Integer[] integers = toObject(castObject);
             Array array = connection.createArrayOf("integer", integers);
             statement.setArray(i, array);
             System.out.println("test null safe set...");
         public Object assemble(final Serializable cached, final Object owner) throws HibernateException {
             return cached;
         public Object deepCopy(final Object o) throws HibernateException {
             return o == null ? null : ((int[]) o).clone();
         public Serializable disassemble(final Object o) throws HibernateException {
             return (Serializable) o;
         public boolean equals(final Object x, final Object y) throws HibernateException {
             return x == null ? y == null : x.equals(y);
         public int hashCode(final Object o) throws HibernateException {
             return o == null ? 0 : o.hashCode();
         public boolean isMutable() {
             return false;
         public Object replace(final Object original, final Object target, final Object owner) throws HibernateException {
             return original;
         public Class<int[]> returnedClass() {
             return int[].class;
         public int[] sqlTypes() {
             return new int[] { SQLTYPE };
    ____________ MyClass.java ___________________________
    package com.test.model;
    import static javax.persistence.GenerationType.IDENTITY;
    import java.io.Serializable;
    import java.sql.Time;
    import java.sql.Timestamp;
    import java.sql.Types;
    import java.util.Date;
    import java.util.List;
    import java.util.Set;
    import javax.persistence.CascadeType;
    import javax.persistence.Column;
    import javax.persistence.Entity;
    import javax.persistence.EnumType;
    import javax.persistence.Enumerated;
    import javax.persistence.FetchType;
    import javax.persistence.GeneratedValue;
    import javax.persistence.Id;
    import javax.persistence.JoinColumn;
    import javax.persistence.JoinTable;
    import javax.persistence.ManyToMany;
    import javax.persistence.ManyToOne;
    import javax.persistence.OneToMany;
    import javax.persistence.Table;
    import org.hibernate.annotations.Type;
    @Table(name = "MyClass")
    public class MyClass implements Serializable {
        private static final long serialVersionUID = -2520209406925143850L;
        @GeneratedValue(strategy = IDENTITY)
        private Long id;
        @Type(type = "com.test.model.CustomArrayType")
        @Column(name = "arrayDay", nullable = true)
        private int[] arrayDay;           
        public Long getId() {
        return id;
        public void setId(Long id) {
        this.id = id;
        public int[] getArrayDay() {
            return arrayDay;
        public void setArrayDay(int[] arrayDay) {
            this.arrayDay = arrayDay;
    ______________ ArrayTypeTests.java ___________________________
    package com.test;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.BeansException;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.ApplicationContextAware;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    import com.test.model.MyClass;
    import com.test.service.MyClassService;
    @ContextConfiguration(locations = { "classpath:application-context.xml" })
    public class ArrayTypeTests implements ApplicationContextAware {
        private MyClassService myClassService;
        public static ApplicationContext ctx;
        public void test_() {
           System.out.println("Test junit");
        public void test_arrayDays() {
        System.out.println("n - Start test_array - ");
        MyClass myClass = myClassService.getMyClassById(1L);
        if (myClass != null) {
            int[] array = myClass.getArrayDay();
            System.out.println("n valor1:" + array[0]);
            System.out.println("n valor2:" + array[1]);
            System.out.println("nn test_array OK ");
        } else {
            System.out.println("n ERROR");
        System.out.println("n - End test_array - ");
        public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {
        ctx = applicationContext;
  2. 2


    Beside your solution in Edit 3, it works perfect when you don’t use connection-pooling like dbcp or c3p0. – You are working with dbcp.

    A possible solution, when using c3p0 would be to use proxool. With this, there shouldn’t be any problems, because proxool can handle createArrayOf().

    Another would be this:

        C3P0ProxyConnection connection = (C3P0ProxyConnection) _statement.getConnection();
        Method method = Connection.class.getMethod("createArrayOf", new Class[] { String.class, Object[].class });
        Array array = (Array) connection.rawConnectionOperation(
            method, C3P0ProxyConnection.RAW_CONNECTION, new Object[] {"integer", intArray});
        _statement.setArray(_i, array);

    You need to get the underlying function from the jdbc-class. Therefor get it with getMethod and use it with reflection.


Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2017 SolutionMmyself.com