RE: JDBC Request question

2005-03-14 Thread K, Sandeep Reddy
2005 12:45 AM To: jmeter-user@jakarta.apache.org Subject: JDBC Request question > Hi, > > I was wondering if I could get some help with JDBC requests. > What I am trying to do is perform a Select statement to the database > but in the select statement, I need to pass

Re: JDBC Request question

2005-03-13 Thread Jayashree K
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

Re: JDBC Request question

2005-03-12 Thread sebb
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

Re: JDBC Request question

2005-03-11 Thread Peter Lin
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

Re: JDBC Request question

2005-03-11 Thread Mike Buzzetti
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

Re: JDBC Request question

2005-03-11 Thread Craig S. Wilson
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

RE: JDBC Request question

2005-03-11 Thread Gino Gargiulo
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, > > >

Re: JDBC Request question

2005-03-11 Thread Peter Lin
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

JDBC Request question

2005-03-11 Thread Gino Gargiulo
> Hi, > > I was wondering if I could get some help with JDBC requests. > What I am trying to do is perform a Select statement to the database > but in the select statement, I need to pass in a variable and a field > to search for. I created the variable and try ${UserName} into the >

RE: JDBC request question (withdraw the question)

2004-11-15 Thread Liao, Avian
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

Re: JDBC request question

2004-11-15 Thread Peter Lin
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

JDBC request question

2004-11-15 Thread Liao, Avian
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 Jmeter seems still run the program. I check the log file, there it points out that my thread database is done. But how the program still shows the r