You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@jmeter.apache.org by bu...@apache.org on 2012/04/13 12:35:02 UTC

DO NOT REPLY [Bug 53073] New: Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

             Bug #: 53073
           Summary: Allow to assign the OUT result of a JDBC CALLABLE to
                    JMeter variables
           Product: JMeter
           Version: 2.6
          Platform: PC
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: Main
        AssignedTo: issues@jmeter.apache.org
        ReportedBy: rbargezi@infonic.net
    Classification: Unclassified


It currently does not seem possible to store the OUT result variables of a JDBC
CALLABLE statement type in a JMeter variable the way one can store results of a
SELECT. This request asks for the capability to specify a list of variable
names into which the resulting OUT results are stored

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Platform|PC                          |All

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

--- Comment #4 from Roman Bargezi <rb...@infonic.net> 2012-04-24 08:53:02 UTC ---
Hi,

the intent of the code is to store the OUT results in the variables provided to
the "Variable Names" field in a similar manner as it is currently used to store
results returned by a select statement but without generating new numerated
versions of the variables.

The variable names should be comma separated and in the same sequence as the
OUT parameters returned by the call. If there are less variable names than OUT
parameters only as many results shall be stored in the thread-context variables
as variable names were supplied. If more variable names than OUT parameters
exist, the additional variables will be ignored. As such, I am making
assumptions about the sequence and the number of variable names provided.
Looking at the code that is used for storing results of a SELECT statement,
this seems to be the case here as well.

I checked the code once more (and also tested it in our environment) and it
seems to be doing what above description intends.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

Roman Bargezi <rb...@infonic.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #28602|0                           |1
        is obsolete|                            |

--- Comment #2 from Roman Bargezi <rb...@infonic.net> 2012-04-13 12:42:21 UTC ---
Created attachment 28603
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28603
Proposed enhancement patch to Rev 1234407 of AbstractJDBCTestElement.java

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #5 from Philippe Mouawad <p....@ubik-ingenierie.com> 2012-04-24 11:36:16 UTC ---
Thanks for clarification and patch.
Patch applied.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

--- Comment #1 from Roman Bargezi <rb...@infonic.net> 2012-04-13 10:37:02 UTC ---
Created attachment 28602
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28602
Proposed enhancement patch to Rev 1234407 of AbstractJDBCTestElement.java

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

Philippe Mouawad <p....@ubik-ingenierie.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO
                 CC|                            |p.mouawad@ubik-ingenierie.c
                   |                            |om
         OS/Version|                            |All

--- Comment #3 from Philippe Mouawad <p....@ubik-ingenierie.com> 2012-04-22 17:19:25 UTC ---
Hello,
Thanks for the patch but either I didn't fully understand its behaviour or
there is something wrong in it.

Particularly in the way you use the variables from JMeterContext.
Aren't you making suppositions on the order and number of variables being
equals to number of OUT parameters. I think there is some information missing,
maybe there should be an additional field or the result variable should be a
COMMA separated variable names. 

Regards

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

DO NOT REPLY [Bug 53073] Allow to assign the OUT result of a JDBC CALLABLE to JMeter variables

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53073

--- Comment #6 from Philippe Mouawad <p....@ubik-ingenierie.com> 2012-04-24 11:36:50 UTC ---
Date: Tue Apr 24 11:35:34 2012
New Revision: 1329645

URL: http://svn.apache.org/viewvc?rev=1329645&view=rev
Log:
Bug 53073 - Allow to assign the OUT result of a JDBC CALLABLE to JMeter
variables

Modified:
  
jmeter/trunk/src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/AbstractJDBCTestElement.java
   jmeter/trunk/xdocs/changes.xml
   jmeter/trunk/xdocs/usermanual/component_reference.xml

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.