Revision: 6383 http://sourceforge.net/p/jump-pilot/code/6383 Author: michaudm Date: 2020-08-20 06:59:27 +0000 (Thu, 20 Aug 2020) Log Message: ----------- Read dates as Date from database, update postgresql and sqlite jdbc drivers
Modified Paths: -------------- core/trunk/ChangeLog core/trunk/pom.xml core/trunk/src/com/vividsolutions/jump/datastore/jdbc/ValueConverterFactory.java Added Paths: ----------- core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar Removed Paths: ------------- core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.20.0.jar Modified: core/trunk/ChangeLog =================================================================== --- core/trunk/ChangeLog 2020-08-18 21:02:19 UTC (rev 6382) +++ core/trunk/ChangeLog 2020-08-20 06:59:27 UTC (rev 6383) @@ -4,6 +4,9 @@ # 3. be concise but convey the change in a way that ordinary users understand #<-------------------------------- 80 chars ----------------------------------># +2020-08-20 mmichaud <m.michael.mich...@orange.fr> + * Fix regression : read dates from database as java.util.Date, not String + * update postgresql and sqlite jdbc drivers 2020-08-17 Giuseppe Aruta * Added new tools in SextanteGIS : Deleted: core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.20.0.jar =================================================================== (Binary files differ) Added: core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar =================================================================== (Binary files differ) Index: core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar =================================================================== --- core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar 2020-08-18 21:02:19 UTC (rev 6382) +++ core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar 2020-08-20 06:59:27 UTC (rev 6383) Property changes on: core/trunk/lib/plus/dbdatastore/sqlite-jdbc-3.32.3.2.jar ___________________________________________________________________ Added: svn:mime-type ## -0,0 +1 ## +application/octet-stream \ No newline at end of property Modified: core/trunk/pom.xml =================================================================== --- core/trunk/pom.xml 2020-08-18 21:02:19 UTC (rev 6382) +++ core/trunk/pom.xml 2020-08-20 06:59:27 UTC (rev 6383) @@ -918,7 +918,7 @@ <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> - <version>9.4.1208.jre6</version> + <version>42.2.14</version> <scope>compile</scope> </dependency> <dependency> Modified: core/trunk/src/com/vividsolutions/jump/datastore/jdbc/ValueConverterFactory.java =================================================================== --- core/trunk/src/com/vividsolutions/jump/datastore/jdbc/ValueConverterFactory.java 2020-08-18 21:02:19 UTC (rev 6382) +++ core/trunk/src/com/vividsolutions/jump/datastore/jdbc/ValueConverterFactory.java 2020-08-20 06:59:27 UTC (rev 6383) @@ -118,10 +118,10 @@ public AttributeType getType() { return AttributeType.DATE; } public Object getValue(ResultSet rs, int columnIndex) throws SQLException { // always return string for dates and let FlexibleFeature convert later during runtime - return rs.getString(columnIndex); + //return rs.getString(columnIndex); // Object ret = null; // try { -// ret = rs.getTimestamp(columnIndex); + return rs.getTimestamp(columnIndex); // if (rs.wasNull()) return null; // } catch (Exception e) { // // try to read date from string, as some SpatialDatabases like SQLite _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel