April 10, 2001
Contact john_mammen@yahoo.com 
with bugs, comments or anything else.
------------
Installation
------------
Just unzip the jdbcbench.zip to any directory and 
IMPORTANT: Read the readme.txt file which is this file...Read all the information below.

Requirement
-----------
JDK 1.3 (tested under this). Tested under Windows NT, but should work under other platforms also.

Running JDBCBench 
-----------------
NOTE: Before you run the jdbcbench, you must initialize the database by changing the jdbcbench.bat or jdbcbench2.bat...see Notes about jdbcbench.bat for more details.
----------------------------------------------------------------------------------------
Just put all the class files into one directory and run the batch file called
jdbcbench.bat or jdbcbench2.bat (Change these files before you run them as per your driver installation)

jdbcbench.bat takes 5 parameters,

1st parameter is a number which is tpc (transactions per client)
2nd parameter is a number which is numberofclients
3rd parameter is the name of dababase (eg. northwind)
4rd parameter is username of database (user must have select, insert, update, drop previlages)
5th parameter is password of database

eg. jdbcbench 100 30 northwind sa sa
eg. jdbcbench 100 30 northwind sa

Notes about the jdbcbench.bat
-----------------------------
This specifies the classpath of your drivers...change them as per your installation also change the driver and url of the database as per your drivers

How to initialize the database
------------------------------
If you would like to initialize the database with the tables for testing, just put -init after the url parameter. This should work for MS SQL7.0, for other database you have to create the following tables:
        
	CREATE TABLE branches (Bid INT NOT NULL, PRIMARY KEY(Bid), Bbalance INT, filler CHAR(88))
           
	CREATE TABLE tellers (Tid INT NOT NULL, PRIMARY KEY(Tid), Bid INT, Tbalance INT, filler CHAR(84))
           
	CREATE TABLE accounts (Aid INT NOT NULL, PRIMARY KEY(Aid), Bid INT,Abalance INT, filler CHAR(84))
            
	CREATE TABLE history (Tid INT, Bid INT, Aid INT, delta  INT, time TIMESTAMP, filler CHAR(22))
            
-----------------------
April 10, 2001
Contact john_mammen@yahoo.com 
with bugs, comments or anything else.
 