Mercurial > hg > monetdb-java

comparison tests/JDBC_API_Tester.java @ 820:4c35009cd59c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
In ResultSet.getObject() method added support for retrieving TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object and TIME WITH TIME ZONE as java.time.OffsetTime object. Also methods ResultSetMetaData.getColumnClassName() and ParameterMetaData.getParameterClassName() now return java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 14 Dec 2023 14:58:21 +0100 (16 months ago)
parents 4117aa40a6b9
children b2cbe866d020
comparison
equal deleted inserted replaced
819:726a1d7b168c 820:4c35009cd59c
3069 .append(rs.getTimestamp("ts", c)).append(" | ") 3069 .append(rs.getTimestamp("ts", c)).append(" | ")
3070 .append(rs.getTimestamp("tsz", c)).append(" | ") 3070 .append(rs.getTimestamp("tsz", c)).append(" | ")
3071 .append(rs.getTime("t", c)).append(" | ") 3071 .append(rs.getTime("t", c)).append(" | ")
3072 .append(rs.getTime("tz", c)).append("\n"); 3072 .append(rs.getTime("tz", c)).append("\n");
3073 3073
3074 sb.append("getObject:\n")
3075 .append(rs.getObject("ts")).append(" | ")
3076 .append(rs.getObject("tsz")).append(" | ")
3077 .append(rs.getObject("t")).append(" | ")
3078 .append(rs.getObject("tz")).append("\n");
3079
3074 SQLWarning w = rs.getWarnings(); 3080 SQLWarning w = rs.getWarnings();
3075 while (w != null) { 3081 while (w != null) {
3076 sb.append(w.getMessage()).append("\n"); 3082 sb.append(w.getMessage()).append("\n");
3077 w = w.getNextWarning(); 3083 w = w.getNextWarning();
3078 } 3084 }
3107 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" + 3113 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" +
3108 "America/Los_Angeles:\n" + 3114 "America/Los_Angeles:\n" +
3109 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" + 3115 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" +
3110 "Africa/Windhoek:\n" + 3116 "Africa/Windhoek:\n" +
3111 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" + 3117 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" +
3118 "getObject:\n" +
3119 "1970-01-01 00:00:00.0 | 1970-01-01T01:00+01:00 | 00:00:00 | 01:00+01:00\n" +
3112 "retrieved row (String):\n" + 3120 "retrieved row (String):\n" +
3113 // old output "1970-01-01 00:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 00:00:00 | 01:00:00+01:00\n" + 3121 // old output "1970-01-01 00:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 00:00:00 | 01:00:00+01:00\n" +
3114 "1970-01-01 00:00:00.000000 | 00:00:00 | \n" + 3122 "1970-01-01 00:00:00.000000 | 00:00:00 | \n" +
3115 "default (UTC):\n" + 3123 "default (UTC):\n" +
3116 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" + 3124 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" +
3117 "America/Los_Angeles:\n" + 3125 "America/Los_Angeles:\n" +
3118 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" + 3126 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" +
3119 "Africa/Windhoek:\n" + 3127 "Africa/Windhoek:\n" +
3120 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" + 3128 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" +
3129 "getObject:\n" +
3130 "1970-01-01 00:00:00.0 | 1970-01-01T01:00+01:00 | 00:00:00 | 01:00+01:00\n" +
3121 "retrieved row (String):\n" + 3131 "retrieved row (String):\n" +
3122 // old output "1969-12-31 16:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 16:00:00 | 01:00:00+01:00\n" + 3132 // old output "1969-12-31 16:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 16:00:00 | 01:00:00+01:00\n" +
3123 "1969-12-31 16:00:00.000000 | 16:00:00 | \n" + 3133 "1969-12-31 16:00:00.000000 | 16:00:00 | \n" +
3124 "default (UTC):\n" + 3134 "default (UTC):\n" +
3125 "1969-12-31 16:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 16:00:00.000+0000 | 00:00:00.000+0000\n" + 3135 "1969-12-31 16:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 16:00:00.000+0000 | 00:00:00.000+0000\n" +
3126 "America/Los_Angeles:\n" + 3136 "America/Los_Angeles:\n" +
3127 "1970-01-01 00:00:00.0 | 1970-01-01 00:00:00.0 | 00:00:00 | 00:00:00\n" + 3137 "1970-01-01 00:00:00.0 | 1970-01-01 00:00:00.0 | 00:00:00 | 00:00:00\n" +
3128 "Africa/Windhoek:\n" + 3138 "Africa/Windhoek:\n" +
3129 "1969-12-31 14:00:00.0 | 1970-01-01 00:00:00.0 | 14:00:00 | 00:00:00\n" + 3139 "1969-12-31 14:00:00.0 | 1970-01-01 00:00:00.0 | 14:00:00 | 00:00:00\n" +
3140 "getObject:\n" +
3141 "1969-12-31 16:00:00.0 | 1970-01-01T01:00+01:00 | 16:00:00 | 01:00+01:00\n" +
3130 "retrieved row (String):\n" + 3142 "retrieved row (String):\n" +
3131 // old output "1970-01-01 00:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 00:00:00 | 01:00:00+01:00\n" + 3143 // old output "1970-01-01 00:00:00.000000 | 1970-01-01 01:00:00.000000+01:00 | 00:00:00 | 01:00:00+01:00\n" +
3132 "1970-01-01 00:00:00.000000 | 00:00:00 | \n" + 3144 "1970-01-01 00:00:00.000000 | 00:00:00 | \n" +
3133 "default (UTC):\n" + 3145 "default (UTC):\n" +
3134 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" + 3146 "1970-01-01 00:00:00.000+0000 | 1970-01-01 00:00:00.000+0000 | 00:00:00.000+0000 | 00:00:00.000+0000\n" +
3135 "America/Los_Angeles:\n" + 3147 "America/Los_Angeles:\n" +
3136 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" + 3148 "1970-01-01 08:00:00.0 | 1970-01-01 00:00:00.0 | 08:00:00 | 00:00:00\n" +
3137 "Africa/Windhoek:\n" + 3149 "Africa/Windhoek:\n" +
3138 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" + 3150 "1969-12-31 22:00:00.0 | 1970-01-01 00:00:00.0 | 22:00:00 | 00:00:00\n" +
3151 "getObject:\n" +
3152 "1970-01-01 00:00:00.0 | 1970-01-01T01:00+01:00 | 00:00:00 | 01:00+01:00\n" +
3139 "0. true true\n"); 3153 "0. true true\n");
3140 } 3154 }
3141 3155
3142 private void Test_PStypes() { 3156 private void Test_PStypes() {
3143 sb.setLength(0); // clear the output log buffer 3157 sb.setLength(0); // clear the output log buffer