IngresDateTestSetup.java

package org.geotools.data.ingres;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Date;

import org.geotools.jdbc.JDBCDateTestSetup;
import org.geotools.jdbc.JDBCTestSetup;

public class IngresDateTestSetup extends JDBCDateTestSetup {


    public IngresDateTestSetup(JDBCTestSetup delegate) {
        super(delegate);
    }

    @Override
    protected void createDateTable() throws Exception {
        Connection con = getDataSource().getConnection();
        con.prepareStatement("CREATE TABLE DATES (D ANSIDATE, DT TIMESTAMP, T TIME)").execute();
        
        PreparedStatement ps = con.prepareStatement("INSERT INTO DATES VALUES (?,?,?)");
        ps.setDate(1, java.sql.Date.valueOf("2009-06-28"));
        //ps.setTimestamp(2, java.sql.Timestamp.valueOf("2009-06-28 15:12:41.0"));
        ps.setTimestamp(2,  new java.sql.Timestamp(new java.text.SimpleDateFormat
        		("HH:mm:ss,dd-yyyy-MM").parse("15:12:41,28-2009-06").getTime()));
        ps.setTime(3, java.sql.Time.valueOf("15:12:41"));
        ps.execute();
        ps.setDate(1, java.sql.Date.valueOf("2009-01-15"));
 //       ps.setTimestamp(2, java.sql.Timestamp.valueOf("2009-01-15 13:10:12.0"));
        ps.setTimestamp(2,  new java.sql.Timestamp(new java.text.SimpleDateFormat
        		("HH:mm:ss,dd-yyyy-MM").parse("13:10:12,15-2009-01").getTime()));
        ps.setTime(3, java.sql.Time.valueOf("13:10:12"));
        ps.execute();
        ps.setDate(1, java.sql.Date.valueOf("2009-09-29"));
 //       ps.setTimestamp(2, java.sql.Timestamp.valueOf("2009-09-29 17:54:23.0"));
        ps.setTimestamp(2,  new java.sql.Timestamp(new java.text.SimpleDateFormat
        		("HH:mm:ss,dd-yyyy-MM").parse("17:54:23,29-2009-09").getTime()));
        ps.setTime(3, java.sql.Time.valueOf("17:54:23"));
        ps.execute();
        ps.close();
        con.close();               
    }

    @Override
    protected void dropDateTable() throws Exception {
        runSafe("DROP TABLE DATES");
    }

}