[odb-users] Initial load with join

Boris Kolpackov boris at codesynthesis.com
Fri Oct 31 03:38:10 EDT 2014

Hi Paul,

Stath, Paul <PStath at Axxcelera.com> writes:

> I assume this "object loading view" would result in a new VIEW in the
> database schema that is contains an INNER JOIN with the related tables
> with appropriate join conditions for the relationships.

No, ODB views are not mapped to database views. Quoting from Chapter 10
in the ODB manual:

"Many relational databases also define the concept of views. Note, however,
that ODB views are not mapped to database views. Rather, by default, an ODB
view is mapped to an SQL SELECT query. However, if desired, it is easy to
create an ODB view that is based on a database view."

In this particular case you will have a single SELECT statement with
two JOIN's (one for JobSheet and the other for Address) which will load
all three objects at once.


More information about the odb-users mailing list