You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jmeter-dev@jakarta.apache.org by bu...@apache.org on 2008/08/20 10:31:10 UTC
DO NOT REPLY [Bug 45657] New: Callable Statement does not support
Oracle Cursor parameter type?
https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
Summary: Callable Statement does not support Oracle Cursor
parameter type?
Product: JMeter
Version: 2.3.2
Platform: PC
OS/Version: Windows 2000
Status: NEW
Severity: normal
Priority: P2
Component: Main
AssignedTo: jmeter-dev@jakarta.apache.org
ReportedBy: elva.deocampo@gmail.com
I was load testing on Oracle using the latest library/jar from their site
(ojdbc14.jar), with JDBC sampler's callable statements and ViewResultsTree
listener.
Every procedure worked fine, save for those that need the parameter type
OracleType.CURSOR.
I tried OracleType.CURSOR (thinking that since I already provided the library,
it would work fine) but Jmeter threw an exception:
java.sql.SQLException: Invalid data type: OracleType.CURSOR
So instead I used java.sql.Types.OTHER, as was advised by some colleague.
But it threw yet another exception:
java.sql.SQLException: Invalid column type
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 45657] Callable Statement does not support Oracle
Cursor parameter type?
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
Sebb <se...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |enhancement
--- Comment #1 from Sebb <se...@apache.org> 2008-08-20 04:42:10 PST ---
JMeter is intended for use with a generic JDBC API, and Oracle-specific
parameter types are not supported.
However, it might be possible to allow the use of vendor-specific types, if a
way can be found to do this that works with all JDBC implementations (e.g. by
allowing the parameter type to be expressed as a plain number).
Changing to enhancement.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
Re: DO NOT REPLY [Bug 45657] Callable Statement does not support
Oracle Cursor parameter type?
Posted by sebb <se...@gmail.com>.
This is a question for the JMeter users list.
Please repost there.
Make sure you include more details as to what you tried, and the
*exact* error messages you received.
Please don't reply to Buzilla messages; if you want to refer to a
Bugzilla issue, just quote the URL.
On 18/09/2009, rpaliath <ra...@hotmail.com> wrote:
>
> I have a stored procedure which I am trying to call using JMETER. This stored
> procedure returns data inside an application defined cursor. How do I
> declare that? I tried using the standard definition, but I am getting a
> "Invalid data type: <schemaname>.<packagename>.bank_holiday_cur_type"
> message. I tried declaring the Parameter Type as -10, in which case it gives
> me an "SQLException: Invalid column type" error.
> I am using JMETER version 2.3.4.
>
> Thanks.
>
>
> Bugzilla from bugzilla@apache.org wrote:
> >
> > https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
> >
> >
> > Sebb <se...@apache.org> changed:
> >
> > What |Removed |Added
> > ----------------------------------------------------------------------------
> > Status|NEW |RESOLVED
> > Resolution| |FIXED
> >
> >
> >
> >
> > --- Comment #2 from Sebb <se...@apache.org> 2008-11-04 08:07:29 PST ---
> > By the way, it's [oracle.jdbc.]OracleTypes, not OracleType.
> >
> > I've added code to treat the type as an integer if it is not recognised as
> > a
> > standard field name:
> >
> > URL: http://svn.apache.org/viewvc?rev=711279&view=rev
> > Log:
> > JDBC Request now handles arbitray variable types
> >
> > This will be in nightly builds after r711279 (
> > https://svn.apache.org/viewcvs.cgi?view=rev&rev=711279 ).
> >
> > OracleTypes.CURSOR = -10 if you want to try it out.
> >
> >
> > --
> > Configure bugmail:
> > https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> > ------- You are receiving this mail because: -------
> > You are the assignee for the bug.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
> >
> >
> >
>
>
> --
> View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-45657--New%3A-Callable-Statement-does-not-support-Oracle-Cursor-parameter-type--tp19065028p25515046.html
> Sent from the JMeter - Dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
Re: DO NOT REPLY [Bug 45657] Callable Statement does not support
Oracle Cursor parameter type?
Posted by rpaliath <ra...@hotmail.com>.
I have a stored procedure which I am trying to call using JMETER. This stored
procedure returns data inside an application defined cursor. How do I
declare that? I tried using the standard definition, but I am getting a
"Invalid data type: <schemaname>.<packagename>.bank_holiday_cur_type"
message. I tried declaring the Parameter Type as -10, in which case it gives
me an "SQLException: Invalid column type" error.
I am using JMETER version 2.3.4.
Thanks.
Bugzilla from bugzilla@apache.org wrote:
>
> https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
>
>
> Sebb <se...@apache.org> changed:
>
> What |Removed |Added
> ----------------------------------------------------------------------------
> Status|NEW |RESOLVED
> Resolution| |FIXED
>
>
>
>
> --- Comment #2 from Sebb <se...@apache.org> 2008-11-04 08:07:29 PST ---
> By the way, it's [oracle.jdbc.]OracleTypes, not OracleType.
>
> I've added code to treat the type as an integer if it is not recognised as
> a
> standard field name:
>
> URL: http://svn.apache.org/viewvc?rev=711279&view=rev
> Log:
> JDBC Request now handles arbitray variable types
>
> This will be in nightly builds after r711279 (
> https://svn.apache.org/viewcvs.cgi?view=rev&rev=711279 ).
>
> OracleTypes.CURSOR = -10 if you want to try it out.
>
>
> --
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-45657--New%3A-Callable-Statement-does-not-support-Oracle-Cursor-parameter-type--tp19065028p25515046.html
Sent from the JMeter - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org
DO NOT REPLY [Bug 45657] Callable Statement does not support Oracle
Cursor parameter type?
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45657
Sebb <se...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Sebb <se...@apache.org> 2008-11-04 08:07:29 PST ---
By the way, it's [oracle.jdbc.]OracleTypes, not OracleType.
I've added code to treat the type as an integer if it is not recognised as a
standard field name:
URL: http://svn.apache.org/viewvc?rev=711279&view=rev
Log:
JDBC Request now handles arbitray variable types
This will be in nightly builds after r711279 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=711279 ).
OracleTypes.CURSOR = -10 if you want to try it out.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-dev-help@jakarta.apache.org