Forum Discussion

Jim_Cusack's avatar
Jim_Cusack
Contributor
16 years ago

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
  • 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)