jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sharad Yadav <sharad.yadav9...@gmail.com>
Subject Re: How to specify JDBC request parameter values for OracleTypes.ARRAY in JMeter for stote procedure
Date Fri, 21 Oct 2016 15:42:02 GMT
please try same with store procedure .don't try with function

On Fri, Oct 21, 2016 at 4:16 PM, Felix Schumacher <
felix.schumacher@internetallee.de> wrote:

>
>
> Am 21. Oktober 2016 11:18:34 MESZ, schrieb Sharad Yadav <
> sharad.yadav9630@gmail.com>:
> >please update
>
> What should be updated?
>
> The images you wanted to sent, were stripped and this could not be seen by
> us.
>
> I don't have Oracle and I don't have your plsql function and this can't
> test your setup.
>
> I think it is up to you to give us more information.
>
> I would try a simpler function - where the user defined type is replaced
> by an array and that has a really simple implementation, like the one I
> used for postgresql - and see if it is giving the same error.
>
> Regards,
> Felix
> >
> >On Thu, Oct 20, 2016 at 4:53 PM, Sharad Yadav
> ><sharad.yadav9630@gmail.com>
> >wrote:
> >
> >>
> >>
> >> On Thu, Oct 20, 2016 at 4:13 PM, Felix Schumacher <felix.schumacher@
> >> internetallee.de> wrote:
> >>
> >>> The list strips most attachments. Your images were stripped and this
> >>> can't be seen.
> >>>
> >>> Felix
> >>>
> >>> Am 20. Oktober 2016 17:06:52 MESZ, schrieb Sharad Yadav <
> >>> sharad.yadav9630@gmail.com>:
> >>> >Getting same exception..
> >>> >
> >>> >
> >>> >[image: Inline image 1]
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >
> >>> >[image: Inline image 2]
> >>> >
> >>> >On Thu, Oct 20, 2016 at 3:19 PM, Felix Schumacher <
> >>> >felix.schumacher@internetallee.de> wrote:
> >>> >
> >>> >> Am 20.10.2016 15:55, schrieb Sharad Yadav:
> >>> >>
> >>> >>> For REF CURSOR ,I am using Parameter value "ResultSet" and
> >Parameter
> >>> >type
> >>> >>> "OUT -10" and  getting correct result.but for Array.not able
to
> >get
> >>> >any
> >>> >>> docs or any help.Please suggest asap
> >>> >>>
> >>> >>
> >>> >> I tried a simple example callable statement using postgresql with
> >a
> >>> >> function f_array declared ad:
> >>> >>
> >>> >> create or replace function f_array(OUT a1 INT[]) AS $$
> >>> >> BEGIN
> >>> >>   a1[0]=1;
> >>> >>   a1[1]=2;
> >>> >> END;
> >>> >> $$
> >>> >> language plpgsql;
> >>> >>
> >>> >> and called that with a JDBC Sampler using
> >>> >>
> >>> >> Query Type: Callable Statement
> >>> >> Query: {call f_array(?)}
> >>> >> Parameter values: dummy
> >>> >> Parameter Types: OUT 2003
> >>> >> Variable name: a1
> >>> >>
> >>> >> and it worked OK.
> >>> >>
> >>> >> I don't have an oracle db at hand, so can't test it.
> >>> >>
> >>> >> Regards,
> >>> >>  Felix
> >>> >>
> >>> >>
> >>> >>
> >>> >>> On Thu, Oct 20, 2016 at 1:51 PM, Sharad Yadav
> >>> ><sharad.yadav9630@gmail.com
> >>> >>> >
> >>> >>> wrote:
> >>> >>>
> >>> >>> I have specified all parameter and  have checked only problem
> >with
> >>> >Array
> >>> >>>> Type.Please let me know how to declare Array as Output
> >Parameter
> >>> >value
> >>> >>>> and
> >>> >>>> Type
> >>> >>>>
> >>> >>>> On Thu, Oct 20, 2016 at 12:57 PM, Felix Schumacher
> >>> ><felix.schumacher@
> >>> >>>> internetallee.de> wrote:
> >>> >>>>
> >>> >>>>
> >>> >>>>>
> >>> >>>>> Am 20. Oktober 2016 13:18:46 MESZ, schrieb Sharad Yadav
<
> >>> >>>>> sharad.yadav9630@gmail.com>:
> >>> >>>>> >Please find below menytioned response that we are
getting
> >from
> >>> >store
> >>> >>>>> >procedure
> >>> >>>>> >
> >>> >>>>> >ORA-06553: PLS-306: wrong number or types of arguments
in
> >call to
> >>> >>>>> >'P_GET_SUMMARY_DETAILS'
> >>> >>>>>
> >>> >>>>> Have you specified all parameters? Is there anything
more in
> >the
> >>> >JMeter
> >>> >>>>> logs?
> >>> >>>>>
> >>> >>>>> Even tough, I suspect you get more problems, when you
have
> >solved
> >>> >this
> >>> >>>>> first step and want to access the results as an array.
> >>> >>>>>
> >>> >>>>> Regards,
> >>> >>>>> Felix
> >>> >>>>>
> >>> >>>>> >
> >>> >>>>> >
> >>> >>>>> >also find belwo mentioned store procedure body
> >>> >>>>> >
> >>> >>>>> > procedure p_get_summary_details(p_application_id
      in
> >>> >>>>> >xxfe_application_summaries.id%type,
> >>> >>>>> >                                  p_application_summary
out
> >>> >>>>> >xxco_alg_appl_summary_t_type,
> >>> >>>>> >                                  p_error_code
         out
> >>> >number,
> >>> >>>>> >                                  p_error_message
      out
> >>> >varchar2);
> >>> >>>>> >
> >>> >>>>> >
> >>> >>>>> >
> >>> >>>>> >Calling from Java is working fine as below mentioned
> >>> >>>>> >
> >>> >>>>> >   String getDBUSERByUserIdSql = "Call
> >>> >>>>> >OASPK014.P_GET_SUMMARY_DETAILS(?,?,?,?)";
> >>> >>>>> >
> >>> >>>>> >   dbConnection =getDBConnection();
> >>> >>>>> >callableStatement =
> >>> >dbConnection.prepareCall(getDBUSERByUserIdSql);
> >>> >>>>> >callableStatement.setBigDecimal(1, new
> >>> >BigDecimal(applicationId));
> >>> >>>>> >callableStatement.registerOutParameter(2,
> >>> >>>>> >java.sql.Types.ARRAY,"XXCO.XXCO_ALG_APPL_SUMMARY_T_TYPE");
> >>> >>>>> >callableStatement.registerOutParameter(3,
> >>> >java.sql.Types.INTEGER);
> >>> >>>>> >callableStatement.registerOutParameter(4,
> >>> >java.sql.Types.VARCHAR);
> >>> >>>>> >System.out.println(":::Array
> >Value:::::::"+java.sql.Types.ARRAY);
> >>> >>>>> >System.out.println(":::INTEGER
> >>> >Value:::::::"+java.sql.Types.INTEGER);
> >>> >>>>> >System.out.println(":::VARCHAR
> >>> >Value:::::::"+java.sql.Types.VARCHAR);
> >>> >>>>> >System.out.println(":::VARCHAR
> >Value:::::::"+OracleTypes.CURSOR);
> >>> >>>>> >
> >>> >>>>> >callableStatement.executeUpdate();
> >>> >>>>> >Integer errorCode = (Integer) callableStatement.getInt(3);
> >>> >>>>> >String errorMessage  = (String)
> >callableStatement.getString(4);
> >>> >>>>> >
> >>> >>>>> >Object[] data = (Object[]) ((Array)
> >>> >>>>> >callableStatement.getObject(2)).getArray();
> >>> >>>>> >
> >>> >>>>> >On Thu, Oct 20, 2016 at 11:01 AM, Felix Schumacher
<
> >>> >>>>> >felix.schumacher@internetallee.de> wrote:
> >>> >>>>> >
> >>> >>>>> >>
> >>> >>>>> >>
> >>> >>>>> >> Am 20. Oktober 2016 11:51:55 MESZ, schrieb
Sharad Yadav <
> >>> >>>>> >> sharad.yadav9630@gmail.com>:
> >>> >>>>> >> >HI,
> >>> >>>>> >> >
> >>> >>>>> >> >Not able to set  Parameter values and
Parameter types for
> >>> >Return
> >>> >>>>> >type
> >>> >>>>> >> >of
> >>> >>>>> >> >OracleTypes.ARRAY by store procedure.Please
give some
> >>> >suggestion as
> >>> >>>>> >i
> >>> >>>>> >> >have
> >>> >>>>> >> >tried below mentioned options...
> >>> >>>>> >> >
> >>> >>>>> >> >
> >>> >>>>> >> >Case1
> >>> >>>>> >> >Parameter values:: Array
> >>> >>>>> >> >
> >>> >>>>> >> >Parameter types:: OUT ARRAY
> >>> >>>>> >> >
> >>> >>>>> >> >
> >>> >>>>> >> >Case2
> >>> >>>>> >> >Parameter values:: Array
> >>> >>>>> >> >
> >>> >>>>> >> >Parameter types:: OUT 2003
> >>> >>>>> >> >
> >>> >>>>> >> >However geeting error in both the cases.
> >>> >>>>> >>
> >>> >>>>> >> Can you post the errors you get?
> >>> >>>>> >>
> >>> >>>>> >> Regards,
> >>> >>>>> >>   Felix
> >>> >>>>> >>
> >>> >>>>> >>
> >>> >>>>> >>
> >>> >>>>> >>
> >------------------------------------------------------------
> >>> >>>>> ---------
> >>> >>>>> >> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> >>> >>>>> >> For additional commands, e-mail:
> >user-help@jmeter.apache.org
> >>> >>>>> >>
> >>> >>>>> >>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>>
> >>>
> >>---------------------------------------------------------------------
> >>> >>>>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> >>> >>>>> For additional commands, e-mail: user-help@jmeter.apache.org
> >>> >>>>>
> >>> >>>>>
> >>> >>>>>
> >>> >>>>
> >>> >>>> --
> >>> >>>> Thanks & Regards,
> >>> >>>> Sharad Yadav
> >>> >>>>
> >>> >>>> "The weak can never forgive. Forgiveness is the attribute
of
> >the
> >>> >strong"
> >>> >>>>
> >>> >>>>
> >>> >>
> >---------------------------------------------------------------------
> >>> >> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> >>> >> For additional commands, e-mail: user-help@jmeter.apache.org
> >>> >>
> >>> >>
> >>>
> >>>
> >>>
> >---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> >>> For additional commands, e-mail: user-help@jmeter.apache.org
> >>>
> >>>
> >>
> >>
> >> --
> >> Thanks & Regards,
> >> Sharad Yadav
> >>
> >> "The weak can never forgive. Forgiveness is the attribute of the
> >strong"
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>


-- 
Thanks & Regards,
Sharad Yadav

"The weak can never forgive. Forgiveness is the attribute of the strong"

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message