I am sorry if it took a long time for me to reply here, cause too busy in our development, but actually I have solved this issue just right after I posted my previous reply and did actually what you have suggested on this thread and it worked. Thanks for giving attention on this matter I really appreciate it. I am actually planning if I could have time sooner to prepare my things, I want to contribute to this project cause I really see its essential value on web and database development using java. I will have a better computer next year by January and hopefully will have all setup ready by then, I really hope I can join your community actively.
Thanks again lukas! On Thursday, December 6, 2012 8:12:57 PM UTC+8, Vine wrote: > > 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. > >
