• Khushal M Jain
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I am extracting Lead ID and Email from salesforce and updating an Oracle Table with ID if the email matches.

If I hard code email address then the update works correctly. 

<bean id="updateLeadSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            update VM_TDM.LEAD LEAD
               set LEAD.ID = @ID@
                   
            where
                  LEAD.EMAIL= 'Padraig.Acton@Prontomail.com'
                   
                   
        </value>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="ID"    value="java.lang.String"/>          
            <entry key="EMAIL" value="java.lang.String"/>            
        </map>
    </property>
</bean>

But if I pass it as reference parameter as below, then the update does not happen.

I am not getting any erros in either case.

<bean id="updateLeadSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            update VM_TDM.LEAD LEAD
               set LEAD.ID = @ID@
                   
            where
                  LEAD.EMAIL= @EMAIL@
                   
                   
        </value>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="ID"    value="java.lang.String"/>          
            <entry key="EMAIL" value="java.lang.String"/>            
        </map>
    </property>
</bean>