Open martinbog opened 9 years ago
Hi Martin,
I hope this helps.
Before starting development, please note that you will need to be somewhat familiar with java development, maven (and git), so you might want to refresh on these a bit.
Now, to come to the actual problem: I couldn't find a "free" version of a jdbc driver for SQL server. If you could point me to one to include as a maven dependency, I could include it in the parser.
Hi Nikos, thank you for instructions to compile the project! Petr
Hi,
you can use the following jdbc driver for SQL Server:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.4.0.jre8</version>
</dependency>
Check the support matrix here to see which version you need.
with database connectivity as following:
# MSSQL example
db.url=jdbc:sqlserver://localhost;instanceName=SQLEXPRESS;databaseName=yourdbname
db.login=yourlogin
db.password=yourpassword
db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
Some things to take into account that did the trick for me:
Hi,
I would like to get R2RML Parser working with SQL Server. You've already explained how to modify sources:
"""
You will need a JDBC driver for SQL Server though. Place the jar in the lib folder.
The difference among the various databases is in retrieving the table columns (see Parser.java, lines 635-641). If you do not have rr:tableName mappings in your R2RML file and have rr:sqlQuery instead, I believe you will not have a problem. """
After these changes, I would like to know how to compile properly sources in order to get the same configuration as the latest release (https://github.com/nkons/r2rml-parser/releases).
Thank you in advance, Martin