Hi All,
I need some help using JMeter as Functional testing and compare JMeter
results with DB results.
I think one of the solutions is using BeanShell Assertion to acquiring the
DB result into Jmeter variable or csv and then compare it with result from
webservice (for example ).
but i have problem with it .. nothing doing ..
i test the beanshell script with "bsh-2.0b4.jar" but with no error doing
nothing ..
the simple script is:
--------------------------------------------------------
import java.io.File;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
//import org.hsqldb.jdbcDriver;
import oracle.jdbc.driver.OracleConnection;
import oracle.jdbc.pool.OracleDataSource;
out_file = "C:/Program Files/Java/jre6/data/table.csv";
db_url = "jdbc:oracle:thin:@
(description=(address=(host=~~)(protocol=~~)(port=~~))(connect_data=(SERVER=DEDICATED)(sid=ORA8)))";
driver = "oracle.jdbc.driver.OracleDriver";
user = "~~";
password = "~~";
sql_statement = "select * from AA;";
//sql_statement = "select TABLE_NAME from SYSTEM_TABLES ;";
try {
Class.forName(driver);
Connection con = DriverManager.getConnection(db_url,user,password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql_statement);
File out = new File(out_file);
FileWriter o = new FileWriter(out);
meta = rs.getMetaData();
cols = meta.getColumnCount();
i = 1;
buf = "";
while (i <= cols){
if ( i > 1 ) {
buf = buf + ",";
}
buf = buf + meta.getColumnLabel(i);
i = i + 1;
}
o.write(buf+ "\n");
buf = "----------";
o.write(buf+ "\n");
while (rs.next()) {
ii = 1;
buf = "";
while (ii <= cols){
if ( ii > 1 ) {
buf = buf + ",";
}
col_name_get = meta.getColumnLabel(ii);
buf = buf + rs.getString(col_name_get);
ii = ii + 1;
}
o.write(buf + "\n");
}
stmt.close();
con.close();
o.close();
} catch ( e ) {
e.printStackTrace();
}
---------------------------------------------
What should i do ??
And how can i store the returned values in an array to compare it easily ?
one another question is about "Compare Assertion" element and "Comparison
Assertion Visualizer" in Jmeter.. what is it for? and how can i use it? any
manual or help ?
Thanks for reading:)
Regards,
Ali Navab
>
