get your SP working from a standard Java client first.
regards
deepak
On Tue, Sep 22, 2009 at 10:54 AM, rpaliath wrote:
>
> Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
> r785646) and hitting all kind of errors. I have been using some posts to
> try
> various combin
I am able to execute this SP from a Java client as well as from an oracle
client.
rpaliath wrote:
>
> Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
> r785646) and hitting all kind of errors. I have been using some posts to
> try various combinations:
>
> SQL Query -
well then replicate the values into your Jmeter.
for e.g.
In your java client is this "CALL
..GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)"
what you specify in the query for callable statement?
Is "Parameter Types - OUT ..bank_holiday_cur_type"
what you specify in your type?-- shouldnt this be an intege
Any SQL your JDBC driver allows should work in JMeter.
-Mike
On Tue, 2004-08-10 at 09:52, Rita danger wrote:
> Hi I'm new to jmeter
> Can you call a stored procedure in Jmeter
> thank you
> RD
>
> _
> Want to block unwanted pop-ups?
yes, I did it for both Oracle and SQL Server.
Oracle example
BEGIN run_get_availability(); END;
SQL Server example
exec run_get_availability
Craig
-Original Message-
From: Rita danger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 9:53 AM
To: [EMAIL PROTECTED]
Subject: call
ease advise
RD
From: [EMAIL PROTECTED]
Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure
Date: Tue, 10 Aug 2004 10:00:29 -0400
yes, I did it for both Oracle and SQL Server.
Oracle example
BEGIN run_get_availability(
Can you run the ab_test select statement in a JDBC request successfully?
Craig
-Original Message-
From: Rita danger [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 7:40 AM
To: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure
Hi
Still having problems trying to run a
Hi Craig,
Yes the 'Select ab_seq.nextval from dual;' works in the JDBC request?
But it does not seem to call the procedure
Thanks
RD
From: [EMAIL PROTECTED]
Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure
Da
12, 2004 9:45 AM
To: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure
Hi Craig,
Yes the 'Select ab_seq.nextval from dual;' works in the JDBC request?
But it does not seem to call the procedure
Thanks
RD
>From: [EMAIL PROTECTED]
>Reply-To: "JMeter Users List&quo
t; Thanks
> RD
>
> >From: [EMAIL PROTECTED]
> >Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: calling a stored procedure
> >Date: Thu, 12 Aug 2004 09:30:49 -0400
> >
> >Can you run the a
]>
To: [EMAIL PROTECTED]
Subject: RE: calling a stored procedure
Date: Thu, 12 Aug 2004 09:30:49 -0400
Can you run the ab_test select statement in a JDBC request successfully?
Craig
-Original Message-
From: Rita danger [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 7:40 AM
To:
elect 10 threads I get an out of memory error
> message? Any idea ?
>
> Thanks
> RD
>
>
> >From: [EMAIL PROTECTED]
> >Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: calling a stored proce
hursday, August 12, 2004 8:29 AM
To: JMeter Users List
Subject: RE: calling a stored procedure
When you up the number of threads, remove the 'view tree results'
listener.
-Mike
On Thu, 2004-08-12 at 10:05, Rita danger wrote:
> Hi
>
> I have another question !!!
> I am carr
Hi Mike,
I've tried that and the sequence stays the same - no increment
I've also tried removing the 'view tree results' and no change.
RD
From: Michael Stover <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: JMeter Users List <[EMAIL PROTECTED]>
Subject: RE:
14 matches
Mail list logo