ThruZero - Resources

Articles

· SQL Tutorial [w3schools.com]
· Difference between inner and outer join [stackoverflow.com]
· The Effective Use of Joins in Select Statements [onjava.com]
· The Master Key to Oracle's Data Dictionary [oreillynet.com]
SELECT table_name FROM ALL_TABLES;
SELECT table_name FROM USER_TABLES;
SELECT table_name FROM DBA_TABLES;
· Gapminder - Sample Datasets [gapminder.org]
· SQL RegEx Documentation [docs.oracle.com]

PostgreSQL

Derby

Hibernate

· Hibernate Home [hibernate.org]
· Hibernate Guidelines [owasp.org]
· Hibernate Mapping Cheat Sheet [ndpsoftware.com]
· Understanding Lazy Fetching [javalobby.org]
· Open Session in View [community.jboss.org]
A common issue in a typical web-application is the rendering of the view, after the main logic of the action has been completed, and therefore, the Hibernate Session has already been closed and the database transaction has ended. If you access detached objects that have been loaded in the Session inside your JSP (or any other view rendering mechanism), you might hit an unloaded collection or a proxy that isn't initialized. The exception you get is: LazyInitializationException: Session has been closed (or a very similar message).
· Hibernate simplifies inheritance mapping [ibm.com]
One table per subclass vs One Table per class hierarchy (using a discriminator)