Lukas - we are using Microsoft latest SQL Server JDBC driver. On Thursday, 6 February 2014 08:49:21 UTC-5, Venkat Sadasivam wrote: > > Hi Lukas: > > Thanks. Please find the sql, sample jdbc and expected result. > > Regards, > Venkat > > On Thursday, 6 February 2014 02:47:49 UTC-5, Lukas Eder wrote: >> >> Hi Venkat, >> >> Thanks for pointing out these things. I think that the Query >> implementations get these things right, but it's quite possible that there >> is some issue with the Routine implementations. Just to be sure, are you >> using SQL Server's own sqljdbc_4.0 JDBC driver, or the Open Source jTDS? >> >> Could you provide me with a minimal T-SQL example procedure to be sure >> we're going to be fixing things as expected? >> >> In the mean time, I have created an issue for this: >> https://github.com/jOOQ/jOOQ/issues/3011 >> >> This has a high chance of still making it into jOOQ 3.3.0 and 3.2.4 >> >> Thanks >> Lukas >> >> >> 2014-02-05 Venkat Sadasivam <[email protected]>: >> >>> 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. >>> >> >>
-- 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.
