Just a quick follow up: I also had the same problem with GMT time e.g 'z', instead of a offset - it didn't seem limited just to -05:00.
Thanks for the quick response, Keith On Tue, Oct 25, 2011 at 2:15 AM, Thomas Mueller < [email protected]> wrote: > Hi, > > I can reproduce this problem. I guess the only workaround is to _not_ use > timezone offsets (-05:00) at the moment. This bug will be fixed in the next > release. > > Regards, > Thomas > > > On Tuesday, October 25, 2011, Keith Donald wrote: > >> 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.p >> >> -- > 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.
