Connection to stardog from mysql

Stardog Designer
1

I have to fetch the data from mysql and upload it to stardog. we are currently using stardog free version. we tried to load the data from mysql database to stardog. but it gave us some exceptions

stardog.exceptions.StardogException: [500] 000012: 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. it would be helpful if we get the answer on how to connect to mysql from stardog free. we tried with jdbc driver but not sure why it is not working.

2

It might be that the pooled connection timed out. Try adding these data source connection properties:

testOnBorrow=true
validationQuery=SELECT 1

poolprops
poolprops2214×702 29.3 KB

-Paul

3

tried but received same error

image
image1681×540 37.4 KB

4

That looks good. Are you certain the database is alive and well? Can you connect to it with another app like DBeaver or SQuirreL using the same connecting string and credentials?

Where is the Stardog server running (Stardog cloud, or elsewhere)?

5

we are using stardog cloud free version

6

Where is MySQL hosted? Is there firewall that could possibly be preventing connections from Stardog cloud? (In which case you would need to whitelist produswest2-vg-egress.stardog.cloud (44.238.183.206). See: Advanced Topics | Stardog Documentation Latest