https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226331#M18269 Hi, <BR />Could you please indicate the build version you're using?<BR />Best regards<BR />Sabrina Wed, 26 Mar 2014 06:31:35 GMT Anonymous 2014-03-26T06:31:35Z https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226330#M18268 Hey, <BR />I am currently running into an null pointer issue when attempting to use tMysqlInput without streaming enabled (I am basically doing a select * from a 6 million row table). <BR />Exception in component tMysqlInput_3 <BR />java.lang.NullPointerException <BR /> at gen.adhoc_campaignmember_0_1.Adhoc_CampaignMember.tMysqlInput_3Process(Adhoc_CampaignMember.java:1067) <BR /> at gen.adhoc_campaignmember_0_1.Adhoc_CampaignMember.tMysqlConnection_3Process(Adhoc_CampaignMember.java:399) <BR /> at gen.adhoc_campaignmember_0_1.Adhoc_CampaignMember.runJobInTOS(Adhoc_CampaignMember.java:1344) <BR /> at gen.adhoc_campaignmember_0_1.Adhoc_CampaignMember.main(Adhoc_CampaignMember.java:1209) <BR />This issue doesn't occur when using streaming. <BR />Can someone clarify what the exact cause for this error? I believe its probably due to the size of the extract, but I don't understand why its throwing a NullPointerException. Shouldn't it be a memory issue? <BR />Also if I must enable streaming - is there a way I can have tMysqlInput -&gt; tMysqlOutput with streaming enabled? <BR />When I attempt it I get the following error: <BR />java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@311671b2 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. <BR /> <BR />Any help / advice is greatly appreciated. <BR />Thanks, <BR />Brian <BR /> <IMG src="https://community.qlik.com/" /> <IMG src="https://community.qlik.com/" /> Wed, 26 Mar 2014 05:56:16 GMT https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226330#M18268 Anonymous 2014-03-26T05:56:16Z https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226331#M18269 Hi, <BR />Could you please indicate the build version you're using?<BR />Best regards<BR />Sabrina Wed, 26 Mar 2014 06:31:35 GMT https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226331#M18269 Anonymous 2014-03-26T06:31:35Z https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226332#M18270 Hi,<BR />Am getting the same error as above am using Talend 5.4.1. Till yesterday it was working fine, i just added tmysqloutput of same table. Fri, 16 May 2014 08:49:44 GMT https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226332#M18270 AbiJeev 2014-05-16T08:49:44Z https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226333#M18271 Hi, <BR />Use OnSubJobOk b/w tMysqlconnect and tMysqlInput. <BR />Thanks, <BR />kumar Fri, 16 May 2014 10:55:06 GMT https://community.qlik.com/t5/Talend-Studio/Null-Pointer-Issue-with-tMysqlInput/m-p/2226333#M18271 Anonymous 2014-05-16T10:55:06Z