import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
+import java.sql.Timestamp;
import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import net.jaekl.cfb.db.Column;
assert(data.length == table.getNumColumns());
for (int col = 0; col < data.length; ++col) {
- ps.setObject(col + 1, data[col]);
+ Object obj = data[col];
+ if (obj instanceof java.util.Date) {
+ Date date = (Date)obj;
+ Timestamp ts = new Timestamp(date.getTime());
+ ps.setTimestamp(col + 1, ts);
+ }
+ else {
+ ps.setObject(col + 1, data[col]);
+ }
pendingValues++;
}
ps.addBatch();