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.
