Music.properties example for SQL Server 12.0

[pierluigi (PL. Miraglia)]

That's my question: I have been able to use virtual graphs routinely on mysql, mariadb.

Now I need to connect to a SQL Server 12.0 (2016, I think) database. Would anyone have a basic example of the .properties file that would work for the music example in the tutorials?

Thank you,
Pierluigi

[Simon_Krauss]

Hi Pierluigi,

• The JDBC connection URL looks like this jdbc:sqlserver://localhost;databaseName=master . Note that the port is not included so it assumes the the default of 1433. If you’re on a different port, you need to put it after, e.g. localhost:1234. And of course change ‘master’ to whatever the name of your database is. More info here: https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017

• The jdbc.driver to use is “com.microsoft.sqlserver.jdbc.SQLServerDriver”. You also need to copy the .jar file with the JDBC driver to your stardog_install_dir/server/dbms/ directory. You can download the file (and any other drivers) from our docs: https://www.stardog.com/docs/#_supported_jdbc_drivers

And then username and password and that should do it.

Simon (Stardog PM)