November 2017
Intermediate to advanced
542 pages
14h 24m
English
Be aware that BasicLookupStrategy is intended to be compatible with all databases by strictly sticking with standard ANSI SQL syntax, notably left [outer] joins. Some older databases (notably, Oracle8i) did not support this join syntax, so ensure that you verify that the syntax and structure of SQL is compatible with your particular database!
There are also most certainly more efficient database-dependent methods of performing hierarchical queries using non-standard SQL, for example, Oracle's CONNECT BY statement and the Common Table Expression (CTE) capability of many other databases, including PostgreSQL and Microsoft SQL Server.
Much as you learned in the example in Chapter 4, JDBC-Based Authentication ...
Read now
Unlock full access