Talend community forum / Null pointer exception while executing code - tjoin

svpavani · 2010-05-08 09:58:04

Hi All,

Attached here in is the screenshot for the workspace on which im working.

My primary requirement is to migrate the data from Excel to MySql with some filtrations and mappings.

Earlier the highlighted TJoin with my SQL table were not there, due to some requirement I have created a new one and mapped it accordingly.

The code generated from this mappings is being used in java framework. When I try executing the code, I am facing with Null Pointer Exception.

When I tried debugging the code, I came to know that the attribute in tjoin adjacent to the highlighted one (I mean the newly created tjoin) is holding null value.

I am herein copying snippet of the code for your reference. In the code at line 62 where a "if" condition is there, its not entering the loop.

Code:

import com.tcs.upload.pat_upload.row17Struct;

if (row15 != null) {

    /**
     * [tJoin_6
     * main ]
     * start
     */

    currentComponent = "tJoin_6";

    row17 = null;

    row17 = new row17Struct();
    row17.Appl_Group = row15.Appl_Group;
    row17.Appl_Name = row15.Appl_Name;
    row17.aging = row15.aging;
    row17.criticality = row15.criticality;
    row17.How_many_Application_Releases_are_planned = row15.How_many_Application_Releases_are_planned;
    row17.adhoc = row15.adhoc;
    row17.Custom_Developed_or_Package_Solution = row15.Custom_Developed_or_Package_Solution;
    row17.Tech_Group = row15.Tech_Group;
    row17.Number_of_Internal_Interfaces_that_this_Application_has = row15.Number_of_Internal_Interfaces_that_this_Application_has;
    row17.Credit_Card_Data = row15.Credit_Card_Data;
    row17.Employee_Sensitive_Information = row15.Employee_Sensitive_Information;
    row17.Company_Financial_Information = row15.Company_Financial_Information;
    row17.Patient_Health_Information = row15.Patient_Health_Information;
    row17.support = row15.support;
    row17.Estimated_Nuber_of_incidents = row15.Estimated_Nuber_of_incidents;
    row17.Estimated_Number_of_Problems_Received_in_Previous_Year = row15.Estimated_Number_of_Problems_Received_in_Previous_Year;
    row17.Estimated_Number_of_Service_Requests_Received_in_Previous_Year = row15.Estimated_Number_of_Service_Requests_Received_in_Previous_Year;
    row17.Maint_and_Support_Contract_Model = row15.Maint_and_Support_Contract_Model;
    row17.Project_Enhancement_Outsourcing_Potential = row15.Project_Enhancement_Outsourcing_Potential;
    row17.Project_MS_Outsourcing_Potential = row15.Project_MS_Outsourcing_Potential;
    row17.Total_Effort_Project_Wise = row15.Total_Effort_Project_Wise;
    row17.Cluster_Name_or_Value_Chain = row15.Cluster_Name_or_Value_Chain;
    row17.sum_of_weightage = row15.sum_of_weightage;
    row17.calc_Criticality = row15.calc_Criticality;
    row17.Appl_Comp_Number_of_Interfaces = row15.Appl_Comp_Number_of_Interfaces;
    row17.Appl_Comp_Business_complexity = row15.Appl_Comp_Business_complexity;
    row17.Appl_Comp_Technical_Complexity = row15.Appl_Comp_Technical_Complexity;
    row17.Appl_Comp_Application_size = row15.Appl_Comp_Application_size;
    row17.Stability_No_of_Incidents = row15.Stability_No_of_Incidents;
    row17.TCS_Presence_percentage = row15.TCS_Presence_percentage;
    row17.TCS_Presence = row15.TCS_Presence;
    row17.Transition_Duration = row15.Transition_Duration;
    row17.Data_Sensitivity = row15.Data_Sensitivity;
    row17.Geography = row15.Geography;
    row17.trans_on_fte = row15.trans_on_fte;
    row17.trans_off_fte = row15.trans_off_fte;
    row17.trans_effort = row15.trans_effort;
    row17.offtrans_on_fte = row15.offtrans_on_fte;
    row17.offtrans_off_fte = row15.offtrans_off_fte;
    row17.offtrans_effort = row15.offtrans_effort;
    row17.sec_no_sens_on = row15.sec_no_sens_on;
    row17.sec_no_sens_off = row15.sec_no_sens_off;
    row17.sec_sens_on = row15.sec_sens_on;
    row17.sec_sens_off = row15.sec_sens_off;


    if (util_tJoin_6.isJoined(row15)) {
        row17.ss_sec_effort = util_tJoin_6.lookupValue.ss_effort;

    }

I suspect that due to new inclusion of the tjoin might be creating some mismatches in the mappings.

Kindly help me in this regard.

Thanks
Regards,
Pavani.

Uploaded Images

Last edited by svpavani (2010-05-08 10:02:41)

Announcement

Unanswered posts

#1 2010-05-08 09:58:04

Null pointer exception while executing code - tjoin

Code:

Board footer