Note: These sample scripts use the JDBC to ODBC driver "sun.jdbc.odbc.JdbcOdbcDriver", with the ODBC driver being "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}". Due to the database drivers used, these sample scripts probably only run on Windows using SUN Java VM.
The "sample.mdb" is a MS Access database that contains only one table called "Revenue" . The table stores the monthly revenue data for three business units - Hardware, Software and Services. It contains four columns as follows:
Column Name | Type |
---|---|
TimeStamp | Date/Time |
Hardware | Number |
Software | Number |
Services | Number |
Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.