Programming
HR
The Best Way to Call Stored Procedures from Java: With jOOQ
['View All Posts Lukaseder', 'I Made Jooq']
Java, SQL and jOOQ.
A class modelling the call with parameters, and a convenience method that allows for calling the procedure in a single method call. // Generated code public class MyProc extends AbstractRoutine<java.lang.Void> { // [...] private static final long serialVersionUID = 1L; public void setI1(Number value) { setNumber(I1, value); } public void setIo1(Number value) { setNumber(IO1, value); } public void setIo2(Number value) { setNumber(IO2, value); } public void setI2(Number value) { setNumber(I2, value); } public BigDecimal getIo1() { return get(IO1); } public BigDecimal getO1() { return get(O1); } public BigDecimal getO2() { return get(O2); } public BigDecimal getIo2() { return get(IO2); } } public class Routines { // [...] public static MyProc myProc( Configuration configuration , Number i1 ,…