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