I was able to connect now to the repository of jooq in my eclipse GIT. I will try to check some bugs and fix them.
On Saturday, January 19, 2013 1:00:50 PM UTC+8, Vine wrote: > > 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. >> >>
