I encountered this scenario when I use SQL Server but not in MySQL. It seems that SQL Server driver doesnt know how to convert DayToSecond to JavaObject. But its weird, it is working in mysql database. I am using JDCBTemplate as sql executor for jooq returned sql. I use JOOQ primarily as SQL Builder and not executor. Any assistance would be very much appreciated!
org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [select [scr ].[SCR_RQST_ID], max([sah].[SHA_DATETIME_CREATE]) [iHistDateMax], max([srn].[CREATE_DATE]) [iNoteDat eMax] from [service_client_req] [scr] left outer join [service_action_history] [sah] on [sah].[SHA_W ORK_ID] = [scr].[SCR_RQST_ID] left outer join [service_req_notes] [srn] on [srn].[WORK_ORDER_ID] = [ scr].[SCR_RQST_ID] where [scr].[SCR_RQST_STAUS] not in (?, ?, ?) group by [scr].[SCR_RQST_ID] having ((case when max([sah].[SHA_DATETIME_CREATE]) > max([srn].[CREATE_DATE]) then max([sah].[SHA_DATETIM E_CREATE]) else max([srn].[CREATE_DATE]) end is null or datediff(ms, case when max([sah].[SHA_DATETI ME_CREATE]) > max([srn].[CREATE_DATE]) then max([sah].[SHA_DATETIME_CREATE]) else max([srn].[CREATE_ DATE]) end, ?) > ? or datediff(ms, case when max([sah].[SHA_DATETIME_CREATE]) > max([srn].[CREATE_DA TE]) then max([sah].[SHA_DATETIME_CREATE]) else max([srn].[CREATE_DATE]) end, ?) < ?) and ((max([sah ].[SHA_DATETIME_CREATE]) is null and max([srn].[CREATE_DATE]) is null) or max([sah].[SHA_DATETIME_CR > EATE]) < ? or max([srn].[CREATE_DATE]) < ?))]; Unable to convert between > org.jooq.types.DayToSecond > and JAVA_OBJECT.; nested exception is java.sql.SQLException: Unable to convert between org.jooq.type s.DayToSecond and JAVA_OBJECT.
