Hi Lukas, As you know the basic purpose of my POC is to develop a unit testing suits for stored procedures. And jOOQ is excellent to develop/fulfil Integration test suites .
So after some googling I found *tSQLt utility* of SQLServer which supports unit testing for stored procedures. Here is a sample you can have a look http://tsqlt.org/after-running-the-examples-smss/ i.e. *2. Write your own new test *section. In the above link there is one stored procedure named as "*tSQLt.Run".* Using our jOOQ code generator I generated an equalient jOOQ routine(s). Then the jOOQ generated *Run routine *executed using java class in the Eclipse editor. *Then the Eclipse console output is * Exception in thread "main" org.jooq.exception.DataAccessException: SQL [{ call [tSQLt].[Run](?) }]; Test Case Summary: 2 test case(s) executed, 1 succeeded, 1 failed, 0 errored. at org.jooq.impl.Utils.translate(Utils.java:1223) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:495) at org.jooq.impl.AbstractRoutine.executeCallableStatement(AbstractRoutine.java:307) at org.jooq.impl.AbstractRoutine.execute(AbstractRoutine.java:227) at org.jooq.impl.AbstractRoutine.execute(AbstractRoutine.java:216) at org.jooq.samples.SampleSP.main(SampleSP.java:39) Caused by: java.sql.SQLException: Test Case Summary: 2 test case(s) executed, 1 succeeded, 1 failed, 0 errored. *When i executed on the DB below is the console output * [TryItOut].[test this causes a failure] failed: (Failure) This is what a failure looks like +----------------------+ |Test Execution Summary| +----------------------+ |No|Test Case Name |Result | +--+---------------------------------------+-------+ |1 |[TryItOut].[test this one passes] |Success| |2 |[TryItOut].[test this causes a failure]|Failure| ----------------------------------------------------------------------------- Msg 50000, Level 16, State 10, Line 1 Test Case Summary: 2 test case(s) executed, 1 succeeded, 1 failed, 0 errored. ----------------------------------------------------------------------------- *I have below question for you :* *1) Why there an exception ? How to fix it ? Any idea ?* *2) If I want to redirect the output of DB console on the java editor console , how to do that ? Any Clue please advice me.* 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]. For more options, visit https://groups.google.com/groups/opt_out.
