Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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:
- insert into t2 (id, date) values (cast(? as int), cast(? as timestamp)) -- (CAST(?1 AS INTEGER), CAST(?2 AS TIMESTAMP)) [22018-187]
- at org.jooq.impl.Utils.translate(Utils.java:1645)
- at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:661)
- at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:356)
- at org.jooq.impl.AbstractDelegatingQuery.execute(AbstractDelegatingQuery.java:133)
- at com.squareup.JooqTest.App.run(App.java:43)
- at com.squareup.JooqTest.App.main(App.java:20)
- Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "TIMESTAMP '2015-11-12 13:43:12.0' (T2: DATE INT)"; SQL statement:
- insert into t2 (id, date) values (cast(? as int), cast(? as timestamp)) -- (CAST(?1 AS INTEGER), CAST(?2 AS TIMESTAMP)) [22018-187]
- at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
- at org.h2.message.DbException.get(DbException.java:179)
- at org.h2.message.DbException.get(DbException.java:155)
- at org.h2.table.Column.convert(Column.java:153)
- at org.h2.command.dml.Insert.insertRows(Insert.java:143)
- at org.h2.command.dml.Insert.update(Insert.java:114)
- at org.h2.command.CommandContainer.update(CommandContainer.java:78)
- at org.h2.command.Command.executeUpdate(Command.java:254)
- at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:198)
- at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
- at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:410)
- at org.jooq.impl.AbstractDMLQuery.execute(AbstractDMLQuery.java:276)
- at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:342)
- ... 3 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement