Hi Shyam, 2014/1/22 Sha <[email protected]>
> Thanks a lot Lukas, > Its been very helpful. thank you for your support and time. > Let me try the temporary table creation stuff in SP. > > If I need any advice/suggestion I would consult you. > Sure, that's what we're here for. > All I am trying to do in POC , unit testing of stored procs is possible in > JOOQ? > We tend to run extensive integration tests to check jOOQ for SQL generation and execution correctness. For this, we create a "standard" database on all supported databases and run thousands of queries against it. You should probably do something similar. If you google for "java database integration testing", you'll find a couple of useful resources. If you really want to "unit test" your code, there are some ideas around jOOQ's MockDatabase here: http://blog.jooq.org/2013/02/20/easy-mocking-of-your-database/ 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.
