Author: bpoussin Date: 2010-06-02 21:12:32 +0200 (Wed, 02 Jun 2010) New Revision: 90 Url: http://nuiton.org/repositories/revision/wikitty/90 Log: force setObject type for java.util.Date (needed for postgresql) Modified: trunk/wikitty-jdbc-impl/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java Modified: trunk/wikitty-jdbc-impl/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java =================================================================== --- trunk/wikitty-jdbc-impl/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java 2010-06-02 18:57:04 UTC (rev 89) +++ trunk/wikitty-jdbc-impl/src/main/java/org/nuiton/wikitty/jdbc/WikittyJDBCUtil.java 2010-06-02 19:12:32 UTC (rev 90) @@ -24,6 +24,8 @@ import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; +import java.sql.Types; +import java.util.Date; import java.util.Hashtable; import java.util.Properties; @@ -305,7 +307,13 @@ static public void doQuery(Connection connection, String query, Object ... args) throws SQLException { PreparedStatement sta = connection.prepareStatement(query); for (int i=0; i<args.length; i++) { - sta.setObject(i + 1, args[i]); + if (args[i] instanceof Date) { + // force for java.util.Date to TIMESTAMP, because some driver + // (Postgresql) don't support it naturaly + sta.setObject(i + 1, args[i], Types.TIMESTAMP); + } else { + sta.setObject(i + 1, args[i]); + } } sta.execute(); }