topic Exception in component tMysqlLastInsertId java.lang.NullPointerExcep in Talend Studio

Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

Anonymous — Thu, 11 Jul 2013 09:30:13 GMT

hello ,
Every time i try to use this component a nullpointerException comme to me .
can any body help me ?
thank you

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

Anonymous — Thu, 11 Jul 2013 09:42:09 GMT

Hi,
Could you please post your work flow and component setting screenshots into forum so that we can address your issue quickly.
Best regards
Sabrina

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

Anonymous — Thu, 11 Jul 2013 09:55:36 GMT

their is my work folw and the TmysqlLastInsertId setting .
thank you

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

alevy — Fri, 12 Jul 2013 00:58:06 GMT

Usually, you should look at the code (click the tab at the bottom-left of your design area) and find the exact line on which the NPE occurred to identify the problem.
(See the first number in the stacktrace e.g. 516 in the following:
Exception in component tJava_1
java.lang.NullPointerException
at idm_from_superb.test_0_1.test.tJava_1Process(test.java:516)
at idm_from_superb.test_0_1.test.runJobInTOS(test.java:842)
at idm_from_superb.test_0_1.test.main(test.java:601)
)
However, in this case, I don't see a tMysqlConnection so where will tMysqlLastInsertId get its value from? It needs to share a connection with tMysqlOutput to work. Did you read the component help to understand how to use it?

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

Anonymous — Fri, 12 Jul 2013 09:15:37 GMT

Thank you , but how do I can use the last input Id In the other sqlOutPut . Like you see I use Tmap and I need rows from my file to both bases .

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

alevy — Fri, 12 Jul 2013 13:40:18 GMT

The way I explained in your https://community.talend.com/t5/Design-and-Development/mapping-foreign-key-in-Tmap-with-2-mysqloutput/td-p/113346.