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);
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(...);