How to pass input parameters Custom SQL Adpater service

, ,
1

Hey,
I have created a JDBC adapter service which is customSQL adapter type. Looks like custom service does not take inputs at runtime. Fore more details I am adding the request details below;

I’ve 2 input fields. If I hard code the inputs it works but it does not take inputs at run time.

SELECT code_id,code_value,ps.SERVICE_ID,ps.CSG_SERVICE_CODE,ps.SERVICE_DESCRIPTION,ps.service_price,ps.billing_type_code_id
from prm_subcomponent sub, prm_subcomponent_service sp, prd_service ps,prd_codes c
where sub.subcomponent_id in (
select distinct(s.subcomponent_id)
from prm_promotion p, prm_promotion_component pc,prm_comp_subcomponent cs,prm_subcomponent s ,
prm_acquisition_channel ac
where p.PROMOTION_ID = ?
and p.PROMOTION_ID = pc.PROMOTION_ID
and cs.COMPONENT_ID = pc.COMPONENT_ID
and cs.SUBCOMPONENT_ID = s.SUBCOMPONENT_ID
and ac.subcomponent_id = s.subcomponent_id
and ac.acquisition_channel_type = ‘DIRECT’
and s.END_DATE is null
and cs.END_DATE is null
and pc.END_DATE is null
and p.END_DATE is null
)
and sub.SUBCOMPONENT_ID = sp.SUBCOMPONENT_ID
and ps.SERVICE_ID = sp.SERVICE_ID
and ps.service_type_code_id = c.code_id
order by code_value

Help really appriciated!!

2

Can you post the input definitions you entered on the SQL tab of the service? Input JDBC Type, Input Field Type and Input Field.

3

you can declare a input field and the value passed to that field is substitued at runtime.

say you can define field called ‘PROMOTION_ID’ in input field section like below
Input JDBC Type= VARCHAR
input Field Type= java.lang.String
input Field = PROMOTION_ID