I've been receiving intermittent exceptions using DSL.timestampAdd() with
MySQL in Amazon RDS (MySQL 5.6.22).
My function call looks like:
List<Field<?>> params = new LinkedList<>();
Long prodTtlSec = <SOME VALUE>;
params.add(DSL.val(isPermanent ? null :
DSL.timestampAdd(DSL.currentTimestamp(), prodTtlSec, DatePart.SECOND)));
org.jooq.exception.SQLDialectNotSupportedException: Type class
org.jooq.impl.DateAdd is not supported in dialect DEFAULT
at org.jooq.impl.DefaultDataType.getDataType(DefaultDataType.java:757)
~[1.0-20150604.201643-39/:na]
at org.jooq.impl.DefaultDataType.getDataType(DefaultDataType.java:704)
~[1.0-20150604.201643-39/:na]
at org.jooq.impl.DSL.getDataType(DSL.java:13585)
~[1.0-20150604.201643-39/:na] at org.jooq.impl.DSL.val(DSL.java:11979)
~[1.0-20150604.201643-39/:na]
............
Relevant maven dependencies:
jooq 3.6.1
jooq-meta 3.6.1
mysql-connector-java 5.1.35
The stack trace only occurs sometimes in the same execution path. If anyone
has ideas why this might occur sometimes or how to resolve it, I would
really appreciate it.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
