I have my new computer setup. I am planning to contribute to JOOQ's development. I have window 7, I am using myeclipse blue 10.7 w/c is indigo based. According to the official site, I need to have egit plugin and maven plugin from sonatype, and so thats it? Will I expect some issues or any other settings needed?
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. > >
