Hi Sha, Configuration is a very central type in jOOQ. Much of it is explained in this section of the manual: http://www.jooq.org/doc/3.2/manual/sql-building/dsl-context/
You can either rely on extracting the Configuration from a DSLContext object through http://www.jooq.org/javadoc/latest/org/jooq/DSLContext.html#configuration() Or, you create your own org.jooq.impl.DefaultConfiguration: http://www.jooq.org/javadoc/latest/org/jooq/impl/DefaultConfiguration.html Hope this helps, Lukas 2014/1/16 Sha <[email protected]> > 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. > -- 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.
