Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

less type choices in JDBC request output(callablestatement) #2959

Closed
asfimport opened this issue Oct 24, 2012 · 4 comments
Closed

less type choices in JDBC request output(callablestatement) #2959

asfimport opened this issue Oct 24, 2012 · 4 comments

Comments

@asfimport
Copy link
Collaborator

luting (Bug 54048):
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?

OS: All
Resolution: WORKSFORME

@asfimport
Copy link
Collaborator Author

@pmouawad (migrated from Bugzilla):
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.

@asfimport
Copy link
Collaborator Author

@pmouawad (migrated from Bugzilla):
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

@asfimport
Copy link
Collaborator Author

@pmouawad (migrated from Bugzilla):
(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

@asfimport
Copy link
Collaborator Author

@pmouawad (migrated from Bugzilla):
Date: Sat Oct 27 18:34:59 2012
New Revision: 1402840

URL: http://svn.apache.org/viewvc?rev=1402840&view=rev
Log:
#2959 - less type choices in JDBC request output(callablestatement)
#2959

Modified:
jmeter/trunk/xdocs/usermanual/component_reference.xml

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant