I am currently working with Aurora Mysql database.
I am trying to use tAmazonAuroraConnection component to open a connection and try to use the same connection in the same job and close the connection at the end of the job.
I am having two doubts.
doubt 1:
Attached JobFlow image is my job design.
In the connection component i gave the connection details,
In the input component i am using the checkbox Use Existing Connection.
While running the job the connection component has no issue where as the input component which uses the connection is having the issue.
Below is the error coming while running the job. If i am not using the existing connection option then the job is running without any failure.
Exception in component tDBInput_2_in (test) java.lang.NullPointerException at oflow.test_1_0.test.tDBInput_2_inProcess(test.java:4245) at oflow.test_1_0.test.tDBConnection_1_inProcess(test.java:3570) at oflow.test_1_0.test.runJobInTOS(test.java:5581) at oflow.test_1_0.test.main(test.java:4657) [FATAL]: oflow.test_1_0.test - tDBInput_2_in null java.lang.NullPointerException at oflow.test_1_0.test.tDBInput_2_inProcess(test.java:4245) at oflow.test_1_0.test.tDBConnection_1_inProcess(test.java:3570) at oflow.test_1_0.test.runJobInTOS(test.java:5581) at oflow.test_1_0.test.main(test.java:4657)
Doubt 2:
I need to populate the data into aurora database, for my purpose i am having the update flow , in the AuroraOutput component i am using Update operation, and also i am setting Use Batch Size option (In Advanced Setting), If I am using the Use existing connection option in this output component along with the Batch Size Option checked , the job throwing a compilation error stating
"batchSizeCounter_tDBOutput_1_out cannot be resolved to a variable"
only if i am unchecked the Use Batch Size option (In Advanced Setting) then this compilation error gone.
could you suggest me with the solution for the above two doubts.
