Lost on JDBC driver and classpath

[MkIII_Supra]

Okay... so I am attempting to take an application called Datavision out for a test drive as a possible replacement for Crystal Reports (which even under Windows can't seem to connect to an SQLite database). And I am being prompted for the following items:

Driver Class Name:
Connection Info:
Database Name:
User Name:
Password:

Of those items I have or know for certain the following:

Database Name: <-- I know the db name since I created it.
User Name: <-- there is no user name
Password: <-- there is no password

In the ever helpful INSTALL file I find this gem:

Edit the file datavision.sh (Unix) or datavision.bat (Windows). For each
JDBC driver you wish to use, add the path to that JDBC driver to the
CLASSPATH.

Fine and dandy for people that understand or know where this stuff is let alone how it works. I am pretty much lost and confused now. Any ideas?

[lagdawg]

I don't know what specific driver you are using to connect but I can give you a couple examples that may help you figure out what you need.

I use the Oracle Thin JDBC driver. It comes packaged in:
ojdbc14.jar - CLASS_PATH would need to point to the directory containing this.

Inside the ojdbc14.jar package there is a specific class for the oracle driver and that in this case is:
oracle.jdbc.driver.OracleDriver - This is Driver Class name.

Then you need a connection url in order to connect to the database using the appropriate jdbc driver which would date the form of:
jdbc:mysql://<hostname>[<:3306>]/<dbname> - MySQL example
jdbcracle:thin:@<server>[<:1521>]/<dbname> - Oracle driver example

You will need to figure out exactly which jdbc driver you are using. Then you will need a specific connection url and Driver class name / path in the package.

Hope this helps you find your solution.

[lagdawg]

Okay after looking at SQLLite it looks like this is what you need:
Driver Class Name: org.sqlite.JDBC
Connection Info: jdbc:sqlite:<database_file>

Also make sure that the path to the package:
sqlitejdbc-v056.jar is included in the CLASS_PATH