A simple JDBC example is provided. The program will establish a connection to the Oracle Database, create a table with 2 columns, insert two rows into the table, query the table and then drop it. In the end there will be no persistent changes left behind.

Read the code, and the provided scripts, the script takes only 2 arguments, your userid and password, it hardcodes the database URL and the name of the test table is testtable. While you don't have many options for the database URL you could change the name of the table to be created.

• JDBCExample.java
• jdbctest.sh

A few words about the database URL, we are using the level 4 Java driver therefore the syntax will be jdbc:oracle:thin:@host:listenerport:SID. host - can be the IP address, the listenerport is by default 1521, and the SID is the instance identifier of the Oracle server process, in our case CS610. There are variations of this syntax, I did provide you with the simplest one. Looking at the script file you will observe that we have added the file classes12_01.zip to the classpath. The default name of this file is classes12.zip and resides in directory $ORACLE_HOME/jdbc/lib. This file contains the Java JDBC driver. It is usually a good thing to have the JDBC driver of the Oracle product release you are running the instance on, we will provide you with a new driver soon. The existing file is an older version, and was renamed by somebody within our department, I used it without problem for our little test application.