package postgres;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author Christopher Deckers
 */
public class MultiInsertTest {

    private static final String DB = "XXX";
    private static final String USER = "YYY";
    private static final String PASSWORD = "ZZZ";

    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName(org.postgresql.Driver.class.getName());
        String connectionString = "jdbc:postgresql://localhost:5432/" + DB + "?reWriteBatchedInserts=true";
        Connection conn = DriverManager.getConnection(connectionString, USER, PASSWORD);
        conn.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
        String createTable = "CREATE TABLE IF NOT EXISTS T_AbCd (" +
              "  T_AbCd_ID           NUMERIC (10)        NOT NULL," +
              "  SomeDate           DATE                NOT NULL," +
              "  OwnCurrency_ID      NUMERIC (10)            NULL," +
              "  ASmallInt           SMALLINT            NOT NULL," +
              "  CONSTRAINT PK_T_AbCd2 PRIMARY KEY (T_AbCd_ID)" +
              ")";
        Statement st = conn.createStatement();
        st.executeUpdate(createTable);
        try {
            conn.setAutoCommit(false);
            String insert = "INSERT INTO T_AbCd (T_AbCd_ID, SomeDate, ASmallInt) VALUES (?, ?, 0)";
            PreparedStatement pst = conn.prepareStatement(insert, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
            pst.setLong(1, 24202712L);
            pst.setDate(2, new java.sql.Date(2014-1900, 3-1, 21));
            pst.addBatch();
            pst.setLong(1, 24202713L);
            pst.setDate(2, new java.sql.Date(2014-1900, 3-1, 22));
            pst.addBatch();
            pst.executeBatch();
            conn.commit();
            conn.setAutoCommit(true);
        } catch(SQLException e) {
            e.printStackTrace();
            SQLException nextException = e.getNextException();
            if(nextException != null) {
                System.err.println("Next Exception:");
                nextException.printStackTrace();
            }
        } finally {
            conn.setAutoCommit(true);
            String dropTable = "DROP TABLE T_AbCd";
            st.executeUpdate(dropTable);
        }
        st.close();
        conn.close();
    }

}
