PostgresqlDialect.java

package ome.util;

import java.util.Map;

import ome.model.units.UNITS;

import org.hibernate.Hibernate;
import org.hibernate.dialect.function.SQLFunctionTemplate;

/**
 * select i from Image i where i.id in (:ids)
 * becomes
 * select i from Image i where i.id in (select id from temp_ids());
 */
public class PostgresqlDialect extends org.hibernate.dialect.PostgreSQLDialect {

    public PostgresqlDialect() {
        super();
        registerFunction("temp_ids_cursor",
                new SQLFunctionTemplate(Hibernate.LONG, "select id from table(temp_ids_cursor(?1))"));

        for (Map.Entry<String, Integer> entry : UNITS.listSqlTypes().entrySet()) {
            registerColumnType(entry.getValue(), entry.getKey());
        }

    }

}