I’m posting this because of a question raised against this older post on how to configure the
%CLASSPATH% to find the
ojdbc6.jar file. This is the lab file I use in my Database 1 class to expose students to the moving parts of writing Java programs against the Oracle database. That’s why I choose to use a
CLOB data type, which requires Oracle’s
DBMS_LOB package and wrapping stored procedures.
If you want the same content for MySQL, here’s the link. The full program in either blog entry is available by clicking on the fold/unfold Java Source Code Program widget at the bottom of the respective posts.