Author: kmorin Date: 2009-12-08 08:46:00 +0100 (Tue, 08 Dec 2009) New Revision: 338 Modified: wikengo_core-wikitty/wikengo_core-wikitty-jdbc-impl/src/main/java/org/sharengo/wikitty/jdbc/WikittyStorageJDBC.java Log: - correction in the date fields : now save date and time (not only date) Modified: wikengo_core-wikitty/wikengo_core-wikitty-jdbc-impl/src/main/java/org/sharengo/wikitty/jdbc/WikittyStorageJDBC.java =================================================================== --- wikengo_core-wikitty/wikengo_core-wikitty-jdbc-impl/src/main/java/org/sharengo/wikitty/jdbc/WikittyStorageJDBC.java 2009-11-26 17:16:44 UTC (rev 337) +++ wikengo_core-wikitty/wikengo_core-wikitty-jdbc-impl/src/main/java/org/sharengo/wikitty/jdbc/WikittyStorageJDBC.java 2009-12-08 07:46:00 UTC (rev 338) @@ -22,11 +22,9 @@ import static org.sharengo.wikitty.jdbc.WikittyJDBCUtil.*; import java.math.BigDecimal; -import java.sql.Connection; -import java.sql.ResultSet; -import java.sql.SQLException; -import java.sql.Statement; +import java.sql.*; import java.util.*; +import java.util.Date; import java.util.regex.Matcher; import java.util.regex.Pattern; @@ -236,7 +234,7 @@ COL_DATE_VALUE, wikitty.getId(), ext.getName(), fieldName + "[" + i + "/" + list.size() + "]", - "'" + new java.sql.Date(value.getTime()) + "'")); + "'" + new Timestamp(value.getTime()) + "'")); } break; case NUMERIC: @@ -314,7 +312,7 @@ batch.append(String.format( conf.getProperty(dataInsertQ), COL_DATE_VALUE, wikitty.getId(), ext.getName(), fieldName, - "'" + new java.sql.Date(dateValue.getTime()) + "'")); + "'" + new Timestamp(dateValue.getTime()) + "'")); } else { System.out.println("#####DEBUG####" + type.toDefinition(fieldName)); if (type.isNotNull()) { @@ -609,7 +607,7 @@ value = resultSet.getBoolean(COL_BOOLEAN_VALUE); break; case DATE: - value = resultSet.getDate(COL_DATE_VALUE); + value = new Date(resultSet.getTimestamp(COL_DATE_VALUE).getTime()); break; case NUMERIC: value = resultSet.getBigDecimal(COL_NUMBER_VALUE);