Java Developers: Make the Database Work for You!

This article accompanies the similarly named article in the Dutch Java Magazine. It provides additional resources, some source code and an invitation to the 4 February Masterclass by Lucas Jellema that presents a detailed study of the topics raised in this article.

The article itself: Click JavaMagazine_LaatDeDatabaseVoorJeWerken_partOne_dec2010.pdf for this article.

Friday February 4th: Masterclass: Leveraging the Oracle Database in Java Applications (by: Lucas Jellema)  http://www.amis.nl/trainingen/oracle-database-in-java-applications

Resources

Source code: Click MCJavaDevLeverageDatabase_Demos.zip to download the sources for the samples.

Database Triggers

http://en.wikipedia.org/wiki/Database_trigger

http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#Using_EclipseLink_JPA_Extensions_for_Returning_Policy

http://docs.jboss.org/hibernate/annotations/3.5/reference/en/html_single/#entity-hibspec (look for @Generated)

Invoking Stored Procedures

http://en.wikibooks.org/wiki/Java_Persistence/Advanced_Topics#Stored_Procedures

http://objectopia.com/2009/06/26/calling-stored-procedures-in-jpa/

http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#Using_EclipseLink_JPA_Extensions_for_Stored_Procedure_Query