Advertisement
Guest User

Untitled

a guest
Nov 12th, 2015
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. Exception in thread "main" org.jooq.exception.DataAccessException: SQL [insert into t2 (id, date) values (cast(? as int), cast(? as timestamp))]; Data conversion error converting "TIMESTAMP '2015-11-12 13:43:12.0' (T2: DATE INT)"; SQL statement:
  2. insert into t2 (id, date) values (cast(? as int), cast(? as timestamp)) -- (CAST(?1 AS INTEGER), CAST(?2 AS TIMESTAMP)) [22018-187]
  3. at org.jooq.impl.Utils.translate(Utils.java:1645)
  4. at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:661)
  5. at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356)
  6. at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
  7. at com.squareup.JooqTest.App.run(App.java:43)
  8. at com.squareup.JooqTest.App.main(App.java:20)
  9. Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "TIMESTAMP '2015-11-12 13:43:12.0' (T2: DATE INT)"; SQL statement:
  10. insert into t2 (id, date) values (cast(? as int), cast(? as timestamp)) -- (CAST(?1 AS INTEGER), CAST(?2 AS TIMESTAMP)) [22018-187]
  11. at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
  12. at org.h2.message.DbException.get(DbException.java:179)
  13. at org.h2.message.DbException.get(DbException.java:155)
  14. at org.h2.table.Column.convert(Column.java:153)
  15. at org.h2.command.dml.Insert.insertRows(Insert.java:143)
  16. at org.h2.command.dml.Insert.update(Insert.java:114)
  17. at org.h2.command.CommandContainer.update(CommandContainer.java:78)
  18. at org.h2.command.Command.executeUpdate(Command.java:254)
  19. at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198)
  20. at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
  21. at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:410)
  22. at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:276)
  23. at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:342)
  24. ... 3 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement