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.
