Source code file content
Size: 871 bytes, 1 line
This is a small tool to allow java developers to test different sql queries on database. DBAs have their powerful sqlpus tools. But they are not run same as the java developers do. They have different variable binding, they use different protocol. This tool provide the abilities run different sqls with different variable bindings for some times, output the execution times, and/or output the results. This will help java developers on tuning the sql performance.
java -jar dbtester [folder [run.properties [jdbc.properties]]] [> test.csv]
folder:run all sqls under this folder, current folder if not provided
jdbc.properties : put your jdbc configurations
run.properties : put your general variable bindings, and some global configuration like whether to output the results
You can redirect the output to a csv file, it includes all the sqls execution times.