Hi Lukas,
I am doing a simple POC using JOOQ for my project.
I have a scenario like below.
created a student table in SQLServer DB
inserted records
write a simple stored proc , given a student_Id , which will return Student
name.
Now using a Code Generator of JOOQ , i generated a code.
I wrote a simple Java class where me trying to execute , providing the
in-paramenter.
as below
public static void main(String[] args) {
Getstudentnameinoutputvariable procedure = new
Getstudentnameinoutputvariable();
// All IN and IN OUT parameters generate setters
procedure.setStudentid(1);
procedure.execute();
System.out.println("Result :" + procedure.getStudentname())
}
but when it executes procedure.execute(); throws a null pointer exception.
I dont know how to execute a Stored Proc (SP) from JOOQ java class.
I checked JOOQ user guide.
the sample reads as below
procedure.execute(configuration);
i dont understand where the instance of "configuration" came from ?
I my scenarios where can i get one?
Please provide me a complete sample to execute a stored proc from Java
class using JOOQ.
Thank you.
~Sha
--
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.
