rdemorais

module.exports = function (sequelize, DataTypes) {
    var AlunoCaso = sequelize.define('AlunoCaso', {
        dtCriacao: {type: DataTypes.DATEONLY, allowNull: false, field: 'dt_cricao'},
        dtAtualizacao: {type: DataTypes.DATEONLY, allowNull: false, field: 'dt_atualizacao'}
    },
    {
        createdAt: 'dtCriacao',
        updatedAt: 'dtAtualizacao',
        timestamps: true,
        tableName: 'tb_syn_aluno_caso'

rdemorais

nohup psql -d mydb -f insert.sql > insert.log 2>&1 &

rdemorais

persistence.xml

<property name="javax.persistence.schema-generation.database.action" value="create"/>
<property name="javax.persistence.schema-generation.scripts.action" value="create"/>
<property name="javax.persistence.schema-generation.scripts.create-target" value="create.ddl"/>
<property name="javax.persistence.jdbc.driver" value="org.postgresql.Driver"/>
<property name="javax.persistence.jdbc.url" value="jdbc:postgresql://localhost:5432/db"/>
      
Java class

rdemorais

package br.com.entregaurbana.test.util;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.hibernate.cfg.AvailableSettings;
import org.hibernate.cfg.Configuration;
import org.hibernate.dialect.Dialect;
import org.hibernate.engine.jdbc.internal.FormatStyle;

rdemorais

/usr/libexec/java_home -V

export JAVA_HOME=`/usr/libexec/java_home -v 1.7.0_75`

java -version

rdemorais

import org.hsqldb.util.DatabaseManagerSwing;

//goes on test method
DatabaseManagerSwing.main(new String[] { "--url", "jdbc:hsqldb:mem:dataSource", "--user", "sa", "--password", "" });