Hello, For database client programmes, stored procedures are a "black box", exposing only their procedure signatures. Some databases may expose minimal additional meta information pieces, such as Oracle's ALL_DEPENDENCIES dictionary view, where you can see that there is *some* relation between a procedure and a table.
Most databases also expose procedure source code. A very sophisticated code generator could of course parse and re-compile that source code and its transitive dependencies, although such information would not be 100% reliable. In that sense, no, jOOQ and jOOQ-generated artefacts do not make use of such information. Cheers Lukas 2013/1/2 Xybrek <[email protected]> > I just tried jooq code generation for a quite big enterprise database. > Quite neat. However at what extend code generation look at Stored > procedures? Does it know which tables are being updated or accessed, such > that I can see such relationship in java? > >
