Usage Of Amazon Aurora conection component

Gayathri_IFF — Sat, 04 Apr 2020 08:39:30 GMT

Hi Team,

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.

Thanks-

Gayathri S

Re: Usage Of Amazon Aurora conection component

Anonymous — Wed, 08 Apr 2020 06:50:20 GMT

Hi
It sounds like a bug, the tDBInput component can not get the existing DB connection. I don't have an access
to Aurora Mysql database for testing, however, I would like you to open a jira issue on our bugtracker.
https://jira.talendforge.org/secure/Dashboard.jspa?_ga=2.11271613.841515057.1586222355-680381362.1566008802

Regards
Shong

topic Re: Usage Of Amazon Aurora conection component in Talend Studio

Usage Of Amazon Aurora conection component

Re: Usage Of Amazon Aurora conection component