Thank you for your quick reply. Lukas, I think JOOQ does not handle many complex scenarios like this. I personally feel that JOOQ should make enable to handle complex scenarios. Otherwise it is difficult to win the hearts of developer community to look as an option for some critical application development. Its really disappointing.
~Shyam On Friday, January 31, 2014 11:22:52 PM UTC+5:30, Lukas Eder wrote: > > Hi Shyam, > > Please consider the previous question you've asked on that subject: > > https://groups.google.com/forum/#!searchin/jooq-user/update$20from$20shyam/jooq-user/T7MC5HXeDjQ/apvEI9OZAcEJ > > Cheers > Lukas > > > 2014-01-31 Sha <[email protected] <javascript:>>: > >> Hi Lukas, >> >> I have following scenario where i am getting error. >> >> *The original SQL code snippet * >> >> update #NODE_TEMP set already_exists = 1 >> * from #NODE_TEMP nt* >> join book_plane bp on nt.plane_id = bp.plane_id >> join book_detail bd >> on nt.hc1_item_id = bd.hc1_leaf_id >> >> *My written JOOQ equalent is * >> >> Table nt= NODE_TEMP.as("nt"); >> ctx.update(nt).set(nt.field("already_exists"), 1) >> *.from(nt) //Error* >> .join(bp) >> .on( bp.PLANE_ID.eq(nt.field("PLANE_ID")) ) >> .join(bd) >> .on( >> (nt.field("hc1_item_id").eq(bd.HC1_LEAF_ID).and( >> nt.field("HC3_ITEM_ID").eq(bd.HC3_LEAF_ID)))) >> >> *Error* >> The method from(Table) is undefined for the type UpdateSetMoreStep >> >> >> How to write the equalent JOOQ code for the above shown SQL piece of code. >> i.e how to use joins in update statement of JOOQ. >> >> What is the way out ? >> >> Thank you. >> ~Shyam >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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/groups/opt_out.
