Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

One Star

Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

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

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

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

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

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?
One Star

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

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 .
Seven Stars

Re: Exception in component tMysqlLastInsertId java.lang.NullPointerExcep

The way I explained in your other topic.