Hi Lukas, Please find my below comments. On Thursday, February 6, 2014 11:24:34 PM UTC+5:30, Lukas Eder wrote: > > Hi Shyam, > > Yes stored procedures are supported by jOOQ's code generator. See the > relevant sections of the manual: > - http://www.jooq.org/doc/3.2/manual/sql-execution/stored-procedures/ > I have gone through this section several times, here we are passing IN parameter and fetching OUT parameter, it a kind-of-black-box. We do not know what are actual logic inside the stored procedure. Is there any way using our jOOQ, convert that logic into equivalent java code i.e. DSL API way? i.e. without writing it all again manually. i.e auto convert the logic into java using DSL API.
- http://www.jooq.org/doc/3.2/manual/code-generation/codegen-procedures/ > Same as above. > > Cheers > Lukas > > > 2014-02-06 11:38 GMT+01:00 Sha <[email protected] <javascript:>>: > >> Hi Lukas, >> I have gone through user guide. I feel like asking one question i.e. >> " Is there any feature/tool in jOOQ convert the stored procedure into >> equivalent java class ?" >> >> To make my question clear below it the example : >> >> I have table something like >> >> CREATE TABLE [tbl_Students]( >> [Studentid] [int] IDENTITY(1,1) NOT NULL, >> [Firstname] [nvarchar](200) NOT NULL, >> [Lastname] [nvarchar](200) NULL, >> [Email] [nvarchar](100) NULL >> ) ON [PRIMARY] >> >> And a stored procedure which retruns student first name + " " + lastname >> given the studentId. As shown below >> >> PROCEDURE [dbo].[GetstudentnameInOutputVariable] >> ( >> @studentid INT, --Input parameter , >> Studentid of the student >> @studentname VARCHAR(200) OUT -- Out parameter >> declared with the help of OUT keyword >> ) >> AS >> BEGIN >> SELECT @studentname= Firstname+' '+Lastname FROM >> tbl_Students WHERE studentid=@studentid >> END >> >> To convert the above procedure into java class , is there any tool >> available in jOOQ ? or any other process in jOOQ ? >> >> Regards, >> ~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] <javascript:>. >> 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.
