DataSource JDBC query - Operations allowed
Is there a way to insert or delete rows from a JBDC source using the DataSource test step? Thanks, Jim Cusack
Forum Discussion
I am having trouble using the DataSink step - I keep getting an 'Invalid Column Index' error - even though I am inserting 10 values into a table that has 10 columns
I have 1 property defined to place into the first value
Here is the SQL:
insert into ordermax.crm_om_orders(order_number, created_date, processed_date, attempts, err_msg, action, bos_po_number, submit_date, race_ack_date, race_created_date)
values (?,sysdate,sysdate,'0',null,'INS_ORDER',null,sysdate,null,null)
I have 1 property defined to place into the first value
Here is the SQL:
insert into ordermax.crm_om_orders(order_number, created_date, processed_date, attempts, err_msg, action, bos_po_number, submit_date, race_ack_date, race_created_date)
values (?,sysdate,sysdate,'0',null,'INS_ORDER',null,sysdate,null,null)
