Hi Shyam, I'm sorry, this mail must've have escaped my attention
2014-01-23 Sha <[email protected]> > Yes Lukas, > rewriting the SQL procedures into JOOQ is my POC. > > As its a complex procedure I wrote in a different way > > 1) All fetching logic in JOOQ. ( select abc from employee ; -- here goes > all the complex logic which is written in JOOQ). > 2) the update logic in SQL as show in below > > String updateQuery = "update employee" + > " set computed_value = "+ abc; > int status = connection.createStatement().executeUpdate(updateQuery); > System.out.println(" status : " + status); > > Unfortunately in first part , it fails at ctx.decode().when( .....); > > My code is as below > > DSLContext ctx = DSL.using(connection, SQLDialect.SQLSERVER2008); > Result<Record1<BigDecimal>> rec = ctx.select( > ((DSL)ctx).decode().when(...) ).from(uoijt); > > Error is -- Exception in thread "main" java.lang.ClassCastException: > org.jooq.impl.DefaultDSLContext cannot be cast to org.jooq.impl.DSL > > Even when i change ctx.decode() // It wont find decode() method. > And it does not even work for ((DefaultDSLContext)ctx).decode();//// It > wont find decode() method > You should use DSL.decode(). deocde is a static method in the DSL class. You cannot cast a DSLContext to DSL Cheers Lukas -- 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.
