hello,
let my outline my current configuration below...
> > So, is there a way to "feed" a JDBC sampler with an external file, holding
> > different SQL statements?
>
Yes, you can pass a variable directly into the SQL statement itself.
Eg. In the Query edit box, you might have something like:
>
> INSERT INTO `myDB`.`emails` (`email`) VALUES ('${myEmail}');
>
> Where ${myEmail} is a jmeter variable.
>
> >
> > 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.
>
>
Sounds like a good solution to me, there may be others, but this would
certainly work and actually, probably isn't all that hard. You just ahve
to get the CSV Dataset Config to work.
>
> What exactly is it that is causing you trouble?
I have a working JDBC configuration and I can run a single SQL statement
without any problems in a JDBC sampler.
I set up a text-file called "JMeterCSVSQL.txt" which has two SQL statements -
each in a line seperated with a semicolon:
SELECT * FROM DBC.TablesV ORDER BY 1;
SELECT * FROM DBC.TablesV ORDER BY 1, 2, 3;
My CSV data set config has the following settings:
- filename: C:\JMeterCSVSQL.txt
- character set: UTF-8
- variable name: SQLStmt
- delimiter: ;
I did not touch the other settings.
My JDBC sampler has the following settings:
- Variable Name Bound To Pool: DB1 ... this is my working DB-connection
- Query-Type: SELECT statement
- Query: {SQLStmt}
I did not touch the other settings.
Well, this configuration does not work.
I always get the following JDBC Error:
<sample t="33" lt="33" ts="1333788631220" s="false" lb="JDBC Request" rc="HY000
1074" rm="com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver]
[TeraJDBC 13.10.00.29] [Error 1074] [SQLState HY000] Invalid Escape Clause
"{SQLStmt}"" tn="TG_Queries 1-1" dt="text" by="0"/>
I
also tried to change the query to '{SQLStmt}' but that didn't work as well.
The JDBC error then is:
<sample t="35" lt="33" ts="1333788770333" s="false" lb="JDBC Request" rc="42000
3706" rm="com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database]
[TeraJDBC 13.10.00.29] [Error 3706] [SQLState 42000] Syntax error: expected
something between the beginning of the request and the string '{'."
tn="TG_Queries 1-1" dt="text" by="0"/>
My layout of my JMeter file is:
Thread Group
JDBC Connection
CSV Data Set Config
JDBC Request
View Result Set in Table
Summary Report
So, there seem to be some small changes needed; but I am not sure what I have
to change to get it working.
I hope you can give me some more hints on how to solve this issue.
Thanks.
