I am using tAmazonAuroraConnection for connecting aurora DB, but getting the below error.
"Starting job testjob at 10:47 15/02/2019.
[statistics] connecting to socket on port 3744 [statistics] connected Exception in component tDBConnection_1_in (testjob) com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:674) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1086) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:832) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at local_project.testjob_0_1.testjob.tDBConnection_1_inProcess(testjob.java:381) at local_project.testjob_0_1.testjob.runJobInTOS(testjob.java:832) at local_project.testjob_0_1.testjob.main(testjob.java:683) Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3161) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:598) ... 18 more [statistics] disconnected"
The host and port used for connecting through Talend has been working though SQL workbench and Telnet to the server is also working . Tried changing the Additional JDBC Parameter: "noDatetimeStringSync" to Additional JDBC Parameter: "noDatetimeStringSync=true&useSSL=true&requireSSL=true" but it didn't help.
Yes I was able to connect through another application. I have found a workaround for this issue, the aurora DB configured in AWS is using postgreSQL engine but the talend tAmazonAurora components are using MySQL engine. I used a normal DB component and choose the DB type as postgreSQL after setting up the metadata connection for the same which led to the installation of the required postgreSQL jar file and now the job is running fine.
Yes I was able to connect through another application. I have found a workaround for this issue, the aurora DB configured in AWS is using postgreSQL engine but the talend tAmazonAurora components are using MySQL engine. I used a normal DB component and choose the DB type as postgreSQL after setting up the metadata connection for the same which led to the installation of the required postgreSQL jar file and now the job is running fine.
I have a similar situation, but I stuck on something else.
Else the DB is on PostgreSQL, so my data extraction process took 15 minutes.
Now the DB is migrated on Amazon aurora, I am using the same component on Talend, same job, same data volume all same but now the execution time is raised to 45 minutes.
