[JDBC Table 1] Cannot connect to specified database: 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. (JDBC_00)

Hi Atousa,

It is likely your containers you’ve set up are not communicating with each other.

i.e. your new docker container Transformer cannot ‘see’ your mysqldb database container.

Try the suggestion I made on:

regarding creating a ‘cluster’ of containers.

i.e. 

Try the following on your pc:

docker network create atousa

docker network connect atousa mysqldb

docker network connect atousa <first-3-chars-of-the-containerid-of-your-transformer>

docker network inspect atousa

Russ.

In your connection, the port is usually 3306 ?

(not 3309).

Also, do you have the jdbc driver installed? If not, modify your deployment to add the archive file:

https://streamsets-training.s3.amazonaws.com/externalresources/externalResources.zip

Russ.

So you have a Data Collector as a tarball (you say not a Docker container?), but the mysqldb is a docker container, right? And you have another container ‘agitated_proskuriakova’? Is that the transformer?

I’ll set this up tomorrow and see if I can reproduce. I’ll use the usual root/StreamTra1ningSets! credentials for mysqldb.

I’ll use port 3306.

Can you try setting up an additional Data Collector as a container (so you have all 3 as containers) just to see if that setup works? (don’t forget to add the new docker data collector to your network as per my instructions above).

Maybe try adding your laptop ipaddress to your network:

docker network connect atousa <your-laptop-ip-address>

Perhaps the jdbc driver cannot be reached for the transformer because it is in the data collector.

(So the above command might help)

Whereas when you use the data collector directly, it can.