Hello,
In the past, I always added a JDBC sampler for each single SQL statement - that worked without problems. But now I have a SQL script with dozens of SQL statements (one line per SQL statement always ending with a semicolon) which I want to run in JMeter. It is quite time consuming to set up JMeter with a JDBC sampler for each SQL statement. So, is there a way to "feed" a JDBC sampler with an external file, holding different SQL statements? I could find one posting in this mailling list, discussing this issue using CSV data set configs: http://jmeter.512774.n5.nabble.com/How-to-run-SQL-log-against-database-td525660.html However, I am not sure, whether this is the right solution and additionally I could not manage to get it working. If this is the right solution to my problem, can someone share with me how to connect the csv file with the JDBC sampler? What should be file format of the csv file and what do I have to configure in the csv data set config and JDBC sampler? Any help is much appreciated. Thanks, wywo
