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/ - http://www.jooq.org/doc/3.2/manual/code-generation/codegen-procedures/
Cheers Lukas 2014-02-06 11:38 GMT+01:00 Sha <[email protected]>: > 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]. > 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.
