jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Riji K <kriji...@gmail.com>
Subject Re: JDBC request with table name as a variable?
Date Wed, 07 Dec 2016 06:40:03 GMT
Hi,

When a value is passed from CSV it is considered as string. After getting
the value from CSV write a beanshell and convert it to a table name. Or use
a beanshell program to retrieve the table count values.

Thanks,
Riji

On Dec 7, 2016 07:48, "o haya" <ohaya@yahoo.com.invalid> wrote:

> Hi,
>
> I want to implement at test plan where I am executing "select" statements
> but against different table names, where the set of table names is in a CSV
> file.
>
> Say I have a CSV file:
>
> table1
> table2
> table3
>
> and I run the test plan, then this causes the following:
>
> select count(*) from table1
>
> then the next iteration in the loop does:
>
> select count(*) from table2
>
> then the next iteration in the loop does:
>
> select count(*) from table3
>
> then the next iteration in the loop does:
>
> select count(*) from table1
>
> etc.
>
> If the CSV file has:
>
> table10
> table11
> table12
> table13
>
> Then I run the test plan it will do:
>
> select count(*) from table10
>
> then the next iteration in the loop does:
>
> select count(*) from table11
>
> then the next iteration in the loop does:
>
> select count(*) from table12
>
> then the next iteration in the loop does:
>
> select count(*) from table13
>
> then the next iteration in the loop does:
>
> select count(*) from table10
>
> etc.
>
> I tried using
>
> select count(*) from ${tablename}
>
> but that appears to become:
>
> select count(*) from "table1"
>
> rather than:
>
> select count(*) from table1
>
> Is there a way to do what I'm trying to do with Jmeter?
>
> Thanks,
> Jim
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message