You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Labudu Gopanna <La...@cybage.com> on 2006/12/08 07:17:57 UTC
How to use callable statements for JDBC request?.
Hi all,
How to use callable statements for JDBC request?
Please help me; I want to use the same for sending parameters at run
time if possible
From
Gopal
"Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment."
www.cybage.com
Re: How to use callable statements for JDBC request?.
Posted by sebb <se...@gmail.com>.
What are the results?
Are you sure that the PostgreSQL JDBC driver supports callable statements?
On 08/12/06, Labudu Gopanna <La...@cybage.com> wrote:
> Thanks for reply,
> Hi Sebb,
> Thanks for reply,
> I have tried with fixed parameter values first.
> But results are the same. I am using PostgreQSL database it is working
> fine for select and update statements.
>
>
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Friday, December 08, 2006 5:14 PM
> To: JMeter Users List
> Subject: Re: How to use callable statements for JDBC request?.
>
> Googling suggests that the format is
>
> {call procedurename(param1,...)}
>
> Try this with fixed parameter values first.
> Or ideally with a procedure that does not need parameters, then try
> with one that needs parameters.
>
> You can then try replacing some parameters with JMeter variable
> references,
> for example:
>
> {call procedurename('${TEXT}',...)}
>
> where TEXT is a JMeter variable containing some text to be sent to the
> procedure.
>
> Note that the variable reference needs to be enclosed in quotes so
> that it is passed as a string to the stored procedure.
>
> I don't know Oracle, so I may have got the quote character wrong -
> perhaps it should be " rather than '.
>
>
>
> On 08/12/06, Labudu Gopanna <La...@cybage.com> wrote:
> > Hi all,
> >
> > How to use callable statements for JDBC request?
> >
> > Please help me; I want to use the same for sending parameters at run
> > time if possible
> >
> >
> >
> > From
> >
> > Gopal
> >
> >
> > "Legal Disclaimer: This electronic message and all contents contain
> information from Cybage Software Private Limited which may be
> privileged, confidential, or otherwise protected from disclosure. The
> information is intended to be for the addressee(s) only. If you are not
> an addressee, any disclosure, copy, distribution, or use of the contents
> of this message is strictly prohibited. If you have received this
> electronic message in error please notify the sender by reply e-mail to
> and destroy the original message and all copies. Cybage has taken every
> reasonable precaution to minimize the risk of malicious content in the
> mail, but is not liable for any damage you may sustain as a result of
> any malicious content in this e-mail. You should carry out your own
> malicious content checks before opening the e-mail or attachment."
> > www.cybage.com
> >
> >
> >
> >
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: How to use callable statements for JDBC request?.
Posted by Labudu Gopanna <La...@cybage.com>.
Thanks for reply,
Hi Sebb,
Thanks for reply,
I have tried with fixed parameter values first.
But results are the same. I am using PostgreQSL database it is working
fine for select and update statements.
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Friday, December 08, 2006 5:14 PM
To: JMeter Users List
Subject: Re: How to use callable statements for JDBC request?.
Googling suggests that the format is
{call procedurename(param1,...)}
Try this with fixed parameter values first.
Or ideally with a procedure that does not need parameters, then try
with one that needs parameters.
You can then try replacing some parameters with JMeter variable
references,
for example:
{call procedurename('${TEXT}',...)}
where TEXT is a JMeter variable containing some text to be sent to the
procedure.
Note that the variable reference needs to be enclosed in quotes so
that it is passed as a string to the stored procedure.
I don't know Oracle, so I may have got the quote character wrong -
perhaps it should be " rather than '.
On 08/12/06, Labudu Gopanna <La...@cybage.com> wrote:
> Hi all,
>
> How to use callable statements for JDBC request?
>
> Please help me; I want to use the same for sending parameters at run
> time if possible
>
>
>
> From
>
> Gopal
>
>
> "Legal Disclaimer: This electronic message and all contents contain
information from Cybage Software Private Limited which may be
privileged, confidential, or otherwise protected from disclosure. The
information is intended to be for the addressee(s) only. If you are not
an addressee, any disclosure, copy, distribution, or use of the contents
of this message is strictly prohibited. If you have received this
electronic message in error please notify the sender by reply e-mail to
and destroy the original message and all copies. Cybage has taken every
reasonable precaution to minimize the risk of malicious content in the
mail, but is not liable for any damage you may sustain as a result of
any malicious content in this e-mail. You should carry out your own
malicious content checks before opening the e-mail or attachment."
> www.cybage.com
>
>
>
>
---------------------------------------------------------------------
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
Re: How to use callable statements for JDBC request?.
Posted by sebb <se...@gmail.com>.
Googling suggests that the format is
{call procedurename(param1,...)}
Try this with fixed parameter values first.
Or ideally with a procedure that does not need parameters, then try
with one that needs parameters.
You can then try replacing some parameters with JMeter variable references,
for example:
{call procedurename('${TEXT}',...)}
where TEXT is a JMeter variable containing some text to be sent to the
procedure.
Note that the variable reference needs to be enclosed in quotes so
that it is passed as a string to the stored procedure.
I don't know Oracle, so I may have got the quote character wrong -
perhaps it should be " rather than '.
On 08/12/06, Labudu Gopanna <La...@cybage.com> wrote:
> Hi all,
>
> How to use callable statements for JDBC request?
>
> Please help me; I want to use the same for sending parameters at run
> time if possible
>
>
>
> From
>
> Gopal
>
>
> "Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment."
> www.cybage.com
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org