You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Gino Gargiulo <Gi...@alea.ca> on 2005/03/11 20:14:39 UTC
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 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
Re: JDBC Request question
Posted by Peter Lin <wo...@gmail.com>.
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 <Gi...@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
Re: HTTP Request to get a non-Text file
Posted by "Craig S. Wilson" <cr...@wavefront.net>.
sebb wrote:
> On Fri, 11 Mar 2005 14:49:35 -0600, Craig S. Wilson <cr...@wavefront.net> wrote:
>>Can I use an HTTP request to retrieve a binary file from a web server?
> Yes - for example it can fetch images.
Does anyone happen to have a method to pull a audio & video stream from
a server and 'play' it in real-time?
Thanks,
--
---------------------------------------
Craig S. Wilson craig@wavefront.net
WaveFront Communications, Inc.
1677 Lake Valentine Road
Arden Hills MN 55112-2840
1.651.638.9594 1.612.865.8794
===============================
Note: If you send me HTML-mail, it will
probably end up in my SPAM bucket.
---------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: HTTP Request to get a non-Text file
Posted by sebb <se...@gmail.com>.
On Fri, 11 Mar 2005 14:49:35 -0600, Craig S. Wilson <cr...@wavefront.net> wrote:
>
> Can I use an HTTP request to retrieve a binary file from a web server?
Yes - for example it can fetch images.
> If the file is retrieved, what happens to the data?
Nothing much, unless you opt to save it using Functional mode or you
add a Save Responses to File Post-Processor.
The latter would be more suitable for binary files.
> --
>
> ---------------------------------------
> Craig S. Wilson craig@wavefront.net
> WaveFront Communications, Inc.
> 1677 Lake Valentine Road
> Arden Hills MN 55112-2840
> 1.651.638.9594 1.612.865.8794
> ===============================
> Note: If you send me HTML-mail, it will
> probably end up in my SPAM bucket.
> ---------------------------------------
>
> ---------------------------------------------------------------------
> 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
HTTP Request to get a non-Text file
Posted by "Craig S. Wilson" <cr...@wavefront.net>.
Can I use an HTTP request to retrieve a binary file from a web server?
If the file is retrieved, what happens to the data?
--
---------------------------------------
Craig S. Wilson craig@wavefront.net
WaveFront Communications, Inc.
1677 Lake Valentine Road
Arden Hills MN 55112-2840
1.651.638.9594 1.612.865.8794
===============================
Note: If you send me HTML-mail, it will
probably end up in my SPAM bucket.
---------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org