jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gino Gargiulo" <Gino.Gargi...@alea.ca>
Subject RE: JDBC Request question
Date Fri, 11 Mar 2005 19:20:15 GMT
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?


-----Original Message-----
From: Peter Lin [mailto:woolfel@gmail.com] 
Sent: Friday, March 11, 2005 11:19 AM
To: JMeter 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
<Gino.Gargiulo@alea.ca> wrote:
> 
> >       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 SQL statement but I get back the following error
> >
> >        ORA-06550:line1,column 588: PL/SQL:ORA-00984: column not 
> > allowed here ORA-065550:line 1, column 463:PL/SQL SQL Statement 
> > ignored
> >
> >       Is this at all possible?  Is there any samples of scripts that

> > send a JDBC request with variables in the SQL statement?
> >
> >       Any help is greatly appreciated
> >
> >
> >
> >       Regards,
> >
> >       Gino
> 
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message