Skip to main content
Last updated August 02, 2011 14:25, by windli
Feedicon  

DBTester Wiki

This is a small tool to allow java developers to test different sql queries on database. With the abilities run different sqls with different variable bindings for some times, especially binding a list to in clause parameter. DBAs have their powerful sqlpus tools. But they are not run same as the java developers do. This tool can output the execution times, and/or output the results. This will help java developers on tuning the sql performance.

Usage: 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.

You can also output the execution plans with this application.

This is a run.properties example:

 #stringparameter=String:value
 #longparameter=Long:value
 #doubleparameter=Double:value
 #dateparameter=Date:value
 #listparameter=Type:List:yyyy-MM-dd HH:mm:ss ,type can:String,Long,Double,Date
 #_times_=1
 #_output_=
 #_executor_=com.teesoft.dbtester.OracleExecutor
 #_explain_format_=  one of TYPICAL BASIC ALL SERIAL ADVANCED, refer to DBMS_XPLAN.DISPLAY 
 StartDate=Date:2011-07-21 13:00:00
 EndDate=Date:2011-07-23 13:00:00
 LastRowNum=Long:3
 StartRowNum=Long:0
 DNo=Long:1
 DNos=Long:List:10,20
 #_output_=test_output
 _times_=1
 _executor_=com.teesoft.dbtester.OracleExecutor
 
 
Close
loading
Please Confirm
Close