Julius Dichter (c) 2003

To Run the SQLRunner

> java DBRunner -cp SQLRunner.ZIP <user name> <password>  <sql query>

for example

> java DBRunner -cp .;SQLRunner.ZIP;oracle.zip  john  secret "select * from Part"

Note you need to quote the query words.


This is also assuming that you have the oracle database driver in your classpath. I assume you do
because in an earlier assignment, you ran a simple java database connection program.

Note: You need the oracle.zip file in the current directory as well. You should have already done 
an example with that in the Oracle practice lab earlier in the semester. The oracle.zip file is available 
as a link on my CS450 page.

----------------------------------------------------------------------------------------------------

Be sure the query is quoted. You may use no parameters at all, but be
sure you set them with the "set" buttons on the GUI

Example 

> java DBRunner -cp .;SQLRunner.ZIP;oracle.zip  <user name>

You will need to type in your password and query

I assume you are using the UB Oracle DBMS, and provide the URL as a default.
That can also be changed from the GUI.