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.
