Config file for MySQL

[Gautamshahi]

Hi,

In the test case, there are multiple files for MySQL. which should I use for the beginners?

[pheyvaer]

Hi @Gautamshahi

To which test case are you referring?

[Gautamshahi]

Thanks for your reply. First of all, there are many test cases for MYSQL at https://github.com/RMLio/rml-test-cases/tree/master/test-cases what is the use of each test case?

Second, I started with test case https://github.com/RMLio/rml-test-cases/tree/master/test-cases/RMLTC0001b-MySQL

Why do we need resource..sql? What kind of query should it contain?

Again in the mapping.ttl file, rml:source <#DB_source>; is it referring to the DB_source as connection properties?
Then in the connection properties, where should I put jdbc jar file and d2rq:Database, what I replace here?

It will great if you can provide an example or instruction file.

Thank you for your time.

[Gautamshahi]

@pheyvaer can you please provide a hint to resolve the issue?

[pheyvaer]

The resource.sql needs to be loaded in your MySQL database that should be running locally. Then in <#DB_source> you fill in the parameters so that they match your local MySQL instance. The JDBC jar should be used by the RML processor. For example in the case of the RMLMapper it is include by default.

What tool are you using the execute the test cases?