When executing stored procedure against SQL Server 2012 we get different behavior between execute and executeUpdate methods.
When raising error from stored procedure execute method doesn't through SQLException whereas executeUpdate method throws as SQLException. As per the Microsoft guidelines when using execute Method is recommended with getMoreResults method invocation to capture complete result. http://blogs.msdn.com/b/jdbcteam/archive/2008/08/01/use-execute-and-getmoreresults-methods-for-those-pesky-complex-sql-queries.aspx Can you provide following option with jOOQ API? 1) Ability to configure jOOQ to either use execute or executeUpdate for stored procedure execution 2) For all the execute method calls getMoreResults method to capture complete data in Java end. Thanks. Venkat -- 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.
