Eastern but my server is running in pacific. On Mon, Oct 24, 2011 at 11:33 PM, Thomas Mueller < [email protected]> wrote:
> Hi, > > Strange... What timezone do you live in? > > Regards, > Thas > Am 25.10.2011 05:29 schrieb "Keith" <[email protected]>: > >> This was noticed when manually inserting a record using the H2 >> Database Console. Very puzzled by this, but H2 seems unable to parse >> any of the following timestamps: >> >> 2011-10-26 8:00:00-05:00 >> 2011-10-26 7:00:00-05:00 >> 2011-10-26 6:00:00-05:00 >> 2011-10-26 5:00:00-05:00 >> 2011-10-26 4:00:00-05:00 >> 2011-10-26 3:00:00-05:00 >> 2011-10-26 2:00:00-05:00 >> >> Strangely, the following parse fine: >> >> 2011-10-26 9:00:00-05:00 >> 2011-10-26 1:00:00-05:00 >> >> An example stack trace I received for the parse errors is below: >> >> General error: "java.lang.IllegalArgumentException: HOUR_OF_DAY"; SQL >> statement: >> update EventSession set startTime = '2011-10-26 8:30:00-05:00' where >> event = 6 and id = 2 [50000-160] HY000/50000 (Help) >> org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.IllegalArgumentException: HOUR_OF_DAY"; SQL statement: >> update EventSession set startTime = '2011-10-26 8:30:00-05:00' where >> event = 6 and id = 2 [50000-160] >> at org.h2.message.DbException.getJdbcSQLException(DbException.java: >> 329) >> at org.h2.message.DbException.get(DbException.java:158) >> at org.h2.message.DbException.convert(DbException.java:281) >> at org.h2.table.RegularTable.addRow(RegularTable.java:139) >> at org.h2.table.Table.updateRows(Table.java:439) >> at org.h2.command.dml.Update.update(Update.java:128) >> at org.h2.command.CommandContainer.update(CommandContainer.java: >> 73) >> at org.h2.command.Command.executeUpdate(Command.java:219) >> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java: >> 177) >> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152) >> at org.h2.server.web.WebApp.getResult(WebApp.java:1311) >> at org.h2.server.web.WebApp.query(WebApp.java:1001) >> at org.h2.server.web.WebApp.query(WebApp.java:977) >> at org.h2.server.web.WebApp.process(WebApp.java:217) >> at org.h2.server.web.WebApp.processRequest(WebApp.java:164) >> at org.h2.server.web.WebServlet.doGet(WebServlet.java:118) >> at org.h2.server.web.WebServlet.doPost(WebServlet.java:153) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 290) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:312) >> at >> >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java: >> 116) >> at >> >> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java: >> 83) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java: >> 182) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java: >> 202) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java: >> 182) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.oauth.provider.filter.OAuthProviderProcessingFilter.doFilter(OAuthProviderProcessingFilter.java: >> 202) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: >> 113) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java: >> 101) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java: >> 113) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java: >> 54) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java: >> 45) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java: >> 182) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java: >> 105) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java: >> 87) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java: >> 144) >> at org.springframework.security.web.FilterChainProxy >> $VirtualFilterChain.doFilter(FilterChainProxy.java:324) >> at >> >> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java: >> 174) >> at >> >> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java: >> 346) >> at >> >> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java: >> 259) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> >> org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java: >> 77) >> at >> >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: >> 76) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: >> 235) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: >> 206) >> at >> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: >> 233) >> at >> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: >> 191) >> at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: >> 127) >> at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: >> 102) >> at >> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: >> 109) >> at >> org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java: >> 637) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: >> 298) >> at >> >> org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java: >> 886) >> at org.apache.coyote.http11.Http11NioProtocol >> $Http11ConnectionHandler.process(Http11NioProtocol.java:721) >> at org.apache.tomcat.util.net.NioEndpoint >> $SocketProcessor.run(NioEndpoint.java:2256) >> at java.util.concurrent.ThreadPoolExecutor >> $Worker.runTask(ThreadPoolExecutor.java:886) >> at java.util.concurrent.ThreadPoolExecutor >> $Worker.run(ThreadPoolExecutor.java:908) >> at java.lang.Thread.run(Thread.java:619) >> Caused by: java.lang.IllegalArgumentException: HOUR_OF_DAY >> at java.util.GregorianCalendar.computeTime(GregorianCalendar.java: >> 2316) >> at java.util.Calendar.updateTime(Calendar.java:2468) >> at java.util.Calendar.getTimeInMillis(Calendar.java:1087) >> at java.util.Calendar.getTime(Calendar.java:1060) >> at org.h2.util.DateTimeUtils.getTimeTry(DateTimeUtils.java:387) >> at org.h2.util.DateTimeUtils.getMillis(DateTimeUtils.java:343) >> at >> org.h2.util.DateTimeUtils.convertDateValueToTimestamp(DateTimeUtils.java: >> 650) >> at org.h2.value.ValueTimestamp.getTimestamp(ValueTimestamp.java: >> 170) >> at org.h2.store.Data.getValueLen(Data.java:984) >> at org.h2.store.Data.getValueLen(Data.java:866) >> at org.h2.index.PageDataLeaf.getRowLength(PageDataLeaf.java:149) >> at org.h2.index.PageDataLeaf.addRowTry(PageDataLeaf.java:164) >> at org.h2.index.PageDataNode.addRowTry(PageDataNode.java:129) >> at org.h2.index.PageDataIndex.addTry(PageDataIndex.java:166) >> at org.h2.index.PageDataIndex.add(PageDataIndex.java:129) >> at org.h2.table.RegularTable.addRow(RegularTable.java:121) >> ... 69 more >> >> Any ideas? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
