You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Peter Reid <Pe...@telecom.co.nz> on 2009/10/28 05:13:16 UTC
Oracle Stored Procedure output parameters
Hi,
I am having difficulty calling an Oracle stored procedure to populate User Defined Variables from the output parameters
The configuration is
Callable Statement:
call messaging_intf.get_message (?,'Y',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameter Values:
${STREAM},${SESSION_CTX},${MESSAGE_FOUND},${TRANSACTION_ID},${APPLICATION},${CUSTOMER},${CORRELATION_ID},${MESSAGE_ID},${USER},${LOB},${TIMESTAMP},${MESSAGE_PAYLOAD},${DEPENDENCY_CHECK_KEY},${SEQUENCE_NUMBER},${MESSAGE_KEY},${SESSION_CTX}
Parameter Types:
VARCHAR,VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT INTEGER,OUT INTEGER,OUT VARCHAR
Variable Names:
I understand this field is only for select type queries and have left it blank
The call against the database is successful and I can see the output parameter values in a Simple Data Writer log.
However, I have used a Debug Sampler to show the User Defined Variables are not set
<sample rc="200" rm="OK">
<responseData class="java.lang.String">-1 updates.
Output variables by position:
[3] Y
[4]
[5] Jmeter
[6] 1
[7]
[8]
[9] 1
[10] Chorus
[11]
[12] <updateProblemByValue>test</updateProblemByValue>
[13]
[14]
[15] 5
[16] 11
</responseData>
<samplerData class="java.lang.String">[Callable Statement] call messaging_intf.get_message (?,'Y',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
B2B,,,,,,,,,,,,,,,
VARCHAR,VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT VARCHAR,OUT
VARCHAR,OUT INTEGER,OUT INTEGER,OUT VARCHAR</samplerData>
</sample>
<sample rc="" rm="">
<responseData class="java.lang.String">JMeterVariables:
APPLICATION=
CORRELATION_ID=
CUSTOMER=
DEPENDENCY_CHECK_KEY=
JMeterThread.last_sample_ok=true
JMeterThread.pack=org.apache.jmeter.threads.SamplePackage@f1c2e0
LOB=
MESSAGE_FOUND=
MESSAGE_ID=
MESSAGE_KEY=
MESSAGE_PAYLOAD=
SEQUENCE_NUMBER=
SESSION_CTX=
START.HMS=162436
START.MS=1256700276212
START.YMD=20091028
STREAM=B2B
TESTSTART.MS=1256701885040
TIMESTAMP=
TRANSACTION_ID=
USER=
persistor=org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl@31172d
</responseData>
<samplerData class="java.lang.String">JMeterVariables
Is what I am trying to do possible?
I am using
JMeter 2.3.4 r785646
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
Regards
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Oracle Stored Procedure output parameters
Posted by Deepak Shetty <sh...@gmail.com>.
Hi
I dont think it will work . Only the values returned in a ResultSet are
returned into variable names as far as I know. I dont see any way you could
do this other than writing a BSH postprocessor that reads the SampleResult
and parses the response string
regards
deepak
On Wed, Oct 28, 2009 at 3:46 AM, sebb <se...@gmail.com> wrote:
> On 28/10/2009, Peter Reid <Pe...@telecom.co.nz> wrote:
> >
> > Hi,
> >
> > I am having difficulty calling an Oracle stored procedure to populate
> User Defined Variables from the output parameters
> >
> > The configuration is
> <...>
>
> >
> > Variable Names:
> > I understand this field is only for select type queries and have left it
> blank
> >
>
> I suggest you try entering variable names and see what happens.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
RE: TestBean Plugin Sample
Posted by Ghania Ferrag <gh...@vantrix.com>.
Maybe it could be that, I'll try later to add another property that will have one digit in name and retest. I'll post after the result of that.
Thanks again for your response,
Regards,
Ghania
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Wednesday, November 04, 2009 2:01 PM
To: JMeter Users List
Subject: Re: TestBean Plugin Sample
Perhaps the JavaBean naming convention does not allow digits in names?
On 04/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> It's working now, the only thing I did is to rename the property from method2Invoke to methodToInvoke, and rebuild all, and then the Gui is displaying properly !!!!
> Really don't know what cause that but most important it is working,
>
> Thanks for your help,
>
> Regards,
>
>
> Ghania
>
>
> -----Original Message-----
> From: Ghania Ferrag [mailto:ghania.ferrag@vantrix.com]
> Sent: Wednesday, November 04, 2009 9:26 AM
> To: JMeter Users List
>
> Subject: RE: TestBean Plugin Sample
>
> Hi Sebb,
>
> Yes I did make sure all getter/setters method names agree with the properties names. But Still have the same problem, even my property Group is not displayed in the GUI.. I wonder if there is something to do with the TestBean interface.
>
> Any idea ?
>
> Thanks again for your response,
>
> Regards,
> Ghania
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Tuesday, November 03, 2009 1:24 PM
> To: JMeter Users List
> Subject: Re: TestBean Plugin Sample
>
> On 02/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> > Hi Every One,
> >
> > I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
> > In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
> > urlService.displayName=URL address
> > urlService.shortDescription=Remote server to connect to
> > method2Invoke.displayName=Method Name
> >
> > And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
> >
> > Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
>
> This is because of the way that JavaBeans work. You need to ensure
> that the get/set method names agree with the property names.
>
> > Thanks in advance for your responses,
> >
> > My Best Regards,
> >
> > Ghania
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
>
> ---------------------------------------------------------------------
> 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: TestBean Plugin Sample
Posted by sebb <se...@gmail.com>.
Perhaps the JavaBean naming convention does not allow digits in names?
On 04/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> It's working now, the only thing I did is to rename the property from method2Invoke to methodToInvoke, and rebuild all, and then the Gui is displaying properly !!!!
> Really don't know what cause that but most important it is working,
>
> Thanks for your help,
>
> Regards,
>
>
> Ghania
>
>
> -----Original Message-----
> From: Ghania Ferrag [mailto:ghania.ferrag@vantrix.com]
> Sent: Wednesday, November 04, 2009 9:26 AM
> To: JMeter Users List
>
> Subject: RE: TestBean Plugin Sample
>
> Hi Sebb,
>
> Yes I did make sure all getter/setters method names agree with the properties names. But Still have the same problem, even my property Group is not displayed in the GUI.. I wonder if there is something to do with the TestBean interface.
>
> Any idea ?
>
> Thanks again for your response,
>
> Regards,
> Ghania
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Tuesday, November 03, 2009 1:24 PM
> To: JMeter Users List
> Subject: Re: TestBean Plugin Sample
>
> On 02/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> > Hi Every One,
> >
> > I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
> > In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
> > urlService.displayName=URL address
> > urlService.shortDescription=Remote server to connect to
> > method2Invoke.displayName=Method Name
> >
> > And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
> >
> > Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
>
> This is because of the way that JavaBeans work. You need to ensure
> that the get/set method names agree with the property names.
>
> > Thanks in advance for your responses,
> >
> > My Best Regards,
> >
> > Ghania
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
>
> ---------------------------------------------------------------------
> 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: TestBean Plugin Sample
Posted by Ghania Ferrag <gh...@vantrix.com>.
It's working now, the only thing I did is to rename the property from method2Invoke to methodToInvoke, and rebuild all, and then the Gui is displaying properly !!!!
Really don't know what cause that but most important it is working,
Thanks for your help,
Regards,
Ghania
-----Original Message-----
From: Ghania Ferrag [mailto:ghania.ferrag@vantrix.com]
Sent: Wednesday, November 04, 2009 9:26 AM
To: JMeter Users List
Subject: RE: TestBean Plugin Sample
Hi Sebb,
Yes I did make sure all getter/setters method names agree with the properties names. But Still have the same problem, even my property Group is not displayed in the GUI.. I wonder if there is something to do with the TestBean interface.
Any idea ?
Thanks again for your response,
Regards,
Ghania
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Tuesday, November 03, 2009 1:24 PM
To: JMeter Users List
Subject: Re: TestBean Plugin Sample
On 02/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> Hi Every One,
>
> I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
> In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
> urlService.displayName=URL address
> urlService.shortDescription=Remote server to connect to
> method2Invoke.displayName=Method Name
>
> And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
>
> Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
This is because of the way that JavaBeans work. You need to ensure
that the get/set method names agree with the property names.
> Thanks in advance for your responses,
>
> My Best Regards,
>
> Ghania
>
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: TestBean Plugin Sample
Posted by Ghania Ferrag <gh...@vantrix.com>.
Hi Sebb,
Yes I did make sure all getter/setters method names agree with the properties names. But Still have the same problem, even my property Group is not displayed in the GUI.. I wonder if there is something to do with the TestBean interface.
Any idea ?
Thanks again for your response,
Regards,
Ghania
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Tuesday, November 03, 2009 1:24 PM
To: JMeter Users List
Subject: Re: TestBean Plugin Sample
On 02/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> Hi Every One,
>
> I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
> In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
> urlService.displayName=URL address
> urlService.shortDescription=Remote server to connect to
> method2Invoke.displayName=Method Name
>
> And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
>
> Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
This is because of the way that JavaBeans work. You need to ensure
that the get/set method names agree with the property names.
> Thanks in advance for your responses,
>
> My Best Regards,
>
> Ghania
>
>
>
>
> ---------------------------------------------------------------------
> 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: TestBean Plugin Sample
Posted by sebb <se...@gmail.com>.
On 02/11/2009, Ghania Ferrag <gh...@vantrix.com> wrote:
> Hi Every One,
>
> I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
> In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
> urlService.displayName=URL address
> urlService.shortDescription=Remote server to connect to
> method2Invoke.displayName=Method Name
>
> And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
>
> Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
This is because of the way that JavaBeans work. You need to ensure
that the get/set method names agree with the property names.
> Thanks in advance for your responses,
>
> My Best Regards,
>
> Ghania
>
>
>
>
> ---------------------------------------------------------------------
> 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
TestBean Plugin Sample
Posted by Ghania Ferrag <gh...@vantrix.com>.
Hi Every One,
I created a new sampler following the Making a TestBean Plugin for Jmeter in How to write a plugin in Jmeter document, and when I run my project in Eclipse, the new Sampler is there but the Sampler Gui don't show the name of the properties as I entered them in my NewInvokerSamplerResources.properties here is an example :
In my NewInvokerSamplerResources.properties file I have(just copied some lines from my property file) :
urlService.displayName=URL address
urlService.shortDescription=Remote server to connect to
method2Invoke.displayName=Method Name
And in the Gui of the new Sampler instead of displaying Method Name, it displays method2Invoke, which is also the property of my HttpInvokerSampler class
Anything is missing ? why the labels in the Gui of the new added sampler don't much what I have in the property file ?
Thanks in advance for your responses,
My Best Regards,
Ghania
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: Oracle Stored Procedure output parameters
Posted by Peter Reid <Pe...@telecom.co.nz>.
I tried that and there are no variables created or populated
Regards
Peter Reid
Integration Services Consultant
Telecom Solutions Centre
Integration Services Catalogue
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Wednesday, 28 October 2009 11:47 p.m.
To: JMeter Users List
Subject: Re: Oracle Stored Procedure output parameters
On 28/10/2009, Peter Reid <Pe...@telecom.co.nz> wrote:
>
> Hi,
>
> I am having difficulty calling an Oracle stored procedure to populate User Defined Variables from the output parameters
>
> The configuration is
<...>
>
> Variable Names:
> I understand this field is only for select type queries and have left it blank
>
I suggest you try entering variable names and see what happens.
---------------------------------------------------------------------
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: Oracle Stored Procedure output parameters
Posted by sebb <se...@gmail.com>.
On 28/10/2009, Peter Reid <Pe...@telecom.co.nz> wrote:
>
> Hi,
>
> I am having difficulty calling an Oracle stored procedure to populate User Defined Variables from the output parameters
>
> The configuration is
<...>
>
> Variable Names:
> I understand this field is only for select type queries and have left it blank
>
I suggest you try entering variable names and see what happens.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org