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/10/24 03:55:27 UTC
[Bug 54048] New: less type choices in JDBC request
output(callablestatement)
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
Priority: P2
Bug ID: 54048
Assignee: issues@jmeter.apache.org
Summary: less type choices in JDBC request
output(callablestatement)
Severity: normal
Classification: Unclassified
Reporter: ltchronus@gmail.com
Hardware: PC
Status: NEW
Version: unspecified
Component: Main
Product: JMeter
The current parameter types in jdbc request only rely only on java.sql.Types.
I suggest as as enhancement to increase the types.
The improvement is necessary because sometimes,the output parameter is not the
types in java.sql.Types.Maybe a cursor or others.
Here is an example:
Stored Procedure :
create or replace procedure RK_JSCX
(
OUTTABLE out sys_refcursor,
OUTINFO out varchar2
)
as
begin
open OUTTABLE for select
PONUM,ITEMNUM,DESCRIPTION,CSTM_MOD,ORDERQTY,REQUESTEDBY from RECMAT;
OUTINFO:=1;
exception
when no_data_found then
OUTINFO :=2;
rollback;
end RK_JSCX;
my sql query in jmeter :
declare
outinfo varchar2(20);
outtable sys_refcursor;
begin
{call RK_JSCX(?,?)};
end;
and what's type for my first output parameter?
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
--- Comment #4 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
Date: Sat Oct 27 18:34:59 2012
New Revision: 1402840
URL: http://svn.apache.org/viewvc?rev=1402840&view=rev
Log:
Bug 54048 - less type choices in JDBC request output(callablestatement)
Bugzilla Id: 54048
Modified:
jmeter/trunk/xdocs/usermanual/component_reference.xml
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |p.mouawad@ubik-ingenierie.c
| |om
Hardware|PC |All
OS| |All
Severity|normal |enhancement
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|WONTFIX |WORKSFORME
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
Philippe Mouawad <p....@ubik-ingenierie.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |WONTFIX
--- Comment #1 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
This is how to do it:
SQL Query : call RK_JSCX(?,?)
Parameter values : OUT, OUT
Parameter types : OUT -10,OUT VARCHAR
-10 being the int value of OracleTypes.CURSOR
Variable names: cursor, outInfo
Names are what you want
JMeter allows using more types than java.sql.Types constantes, in this case
instead of using Constant names, you use integer values of constants.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
--- Comment #2 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
Date: Sat Oct 27 18:32:46 2012
New Revision: 1402838
URL: http://svn.apache.org/viewvc?rev=1402838&view=rev
Log:
Fixed some errors
Modified:
jmeter/trunk/xdocs/changes.xml
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 54048] less type choices in JDBC request
output(callablestatement)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54048
--- Comment #3 from Philippe Mouawad <p....@ubik-ingenierie.com> ---
(In reply to comment #2)
> Date: Sat Oct 27 18:32:46 2012
> New Revision: 1402838
>
> URL: http://svn.apache.org/viewvc?rev=1402838&view=rev
> Log:
> Fixed some errors
>
> Modified:
> jmeter/trunk/xdocs/changes.xml
WRONG COMMENT
--
You are receiving this mail because:
You are the assignee for the bug.