CODEWITHSUNDEEP
javasqleclipsestored-proceduresjooq
Ahmad
Ahmad

Reputation: 427

jooq configuration input parameter on call sp

we had used code-generator in jooq 3.2 to call stored procedure in oracle 11g. We created needed classes correctly but to call sp in Eclipse need Configuration parameter. So now I don't know how to create Configuration parameter? I googled a lot and didn't reach any thing. Thanks in advance.

name of stored procedure is oracle 11g -> City_Select

in Eclipse ->

ir.samin.omid.Routines R = new ir.samin.omid.Routines();
R.city_Select( configuration,123);

Upvotes: 1

Views: 737

Answers (1)

Lukas Eder
Lukas Eder

Reputation: 220932

jOOQ's Configuration lifecycle is described in this page of the manual. Often, however, you do not need direct access to the Configuration object itself, as you will be operating on DSLContext, which wraps Configuration, e.g.

DSLContext ctx = DSL.using(connection, dialect);
ctx.select(...);

If you do need a Configuration reference, e.g. for calling stored procedures, you can either extract it from such a DSLContext:

Configuration configuration = ctx.configuration();

... or create your own:

Configuration configuration = new DefaultConfiguration().set(...).set(...);

Upvotes: 1

Related Questions