Hi Gino,
I give such parameters in JDBC request like ${query} also the column name
as ${UserId} and pass these values in "User Parameters" and run it and I get
the required query.
-Original Message-
From: Gino Gargiulo [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 12, 2005 12:45 A
I assume that variable name you used is Username (I.e. U capital, both at
defination n declaration end)
Mike Buzzetti <[EMAIL PROTECTED]> wrote:
Gino, I played around with your test plan, and I could not get it to
work with the newest nightly build. Basically the error is that
${Username} is n
Variable/function substitution is simple textual substitution, so if
you want to replace the string test in the following:
select from table where col = 'test'
you need to use
select from table where col = '${Var}'
i.e. the quotes are still needed
- unless you set the variable Var to include t
that's what I was guessing. is username read from a previous query or
some place else?
peter
On Fri, 11 Mar 2005 21:02:32 -0500, Mike Buzzetti
<[EMAIL PROTECTED]> wrote:
> Gino, I played around with your test plan, and I could not get it to
> work with the newest nightly build. Basically the err
Gino, I played around with your test plan, and I could not get it to
work with the newest nightly build. Basically the error is that
${Username} is not getting changed to the value of the username.
I don't know why, but I believe that is the problem. ( I am not 100%
positive since I only looked at
Gino Gargiulo wrote:
The sql is fine, I sent in the same request replacing the ${Username}
with a value 'test' and the statement ran fine.
Are there any samples of this where it is working?
I have user variables and property variables in JDBC SQL statements.
Examples of the SQL I use:
delete from j
eter Users List
Subject: Re: JDBC Request question
I'm guessing the sql statement was bad. can you look at Oracle's network
log and see what the query was.
peter
On Fri, 11 Mar 2005 11:14:39 -0800, Gino Gargiulo
<[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
>
I'm guessing the sql statement was bad. can you look at Oracle's
network log and see what the query was.
peter
On Fri, 11 Mar 2005 11:14:39 -0800, Gino Gargiulo <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > I was wondering if I could get some help with JDBC requests.
> > What I am tr
Sorry, all,
I know why I have this problem, and no need to bother you all now.
AL
-Original Message-
From: Liao, Avian
Sent: Monday, November 15, 2004 5:21 PM
To: Jmeter Question (E-mail)
Subject: JDBC request question
Hi, All,
When I add a JDBC request to my test plan ( I have some
do you see any errors in jmeter.log in the bin directory?
peter
On Mon, 15 Nov 2004 20:21:01 -0500, Liao, Avian <[EMAIL PROTECTED]> wrote:
> Hi, All,
>
> When I add a JDBC request to my test plan ( I have some Select SQL query on
> it), after I click "Run", the result turns out fine, but the J
10 matches
Mail list logo
