Hi,
I'm getting the following error when trying to create a Virtual Graph:
Here are the steps i've taken to configure my environment.
I guess you would be interested in steps 9 to 13.
In step 13, i wasn't sure about how to create and where to save it.
Any help really appreciated.
Stardog Studio 1.19
Server Version 7.2
Thanks very much,
-
Installed Docker Desktop on Macbook Pro
-
Downloaded Stardog Docker Image from the following location:
Get Started with Stardog - Get Started Page | Stardog -
Added the following databases to the image above:
• GettingStarted_Music_Data
• stardog-tutorial-beatles
• stardog-tutorial-music
• Northwind (a Microsoft sample database) -
Pushed changes to the following image:
Docker -
Set up MS SQL Server on Linux, including all MS sample databases, and pushed changes to the following image:
Docker
Image description:
It contains the following MS Sample Databases: WideWorldImporters, AdventureWorks2017, and a revised version of Northwind. You can connect to the server using Azure Data Studio. Use Connection Type "Microsoft SQL Server", Server ".", Authentication Type "SQL Login", User Name "SA", Password "*********", and Database "Master". -
Ran both, MS SQL Server and Stardog containers on Macbook Pro
-
Installed Azure Data Studio on Macbook Pro and connected to MS SQL Server container successfully.
-
Installed Stardog Studio on Macbook and connected to the container server successfully.
-
Check JDBC driver compatibility
Support matrix - JDBC Driver for SQL Server | Microsoft Learn
Stardog is running JRE version 18, so driver must be version 7.0 or above. -
Download JDBC driver version 8.2 (latest available)
Download - JDBC Driver for SQL Server | Microsoft Learn -
Set up STARDOG_EXT environment inside the docker container, as per instructions in the link below:
https://www.stardog.com/tutorials/using-virtual-graphs/
docker exec -u root -t -i container_id /bin/bash (requires space after container¬¬_id)
export STARDOG_EXT=/opt/stardog/ext
mkdir $STARDOG_EXT -
Copy Sql Server JDBC driver (jar) to STARDOG_EXT location
In my case, the driver downloaded from MS in step 10, named mssql-jdbc-8.2.2.jre13.jar
cd Downloads/sqljdbc_8.2\enu
docker cp 'mssql-jdbc-8.2.2.jre13.jar' 'ContainerID:/opt/stardog/ext'
Note: Must restart the Stardog Server
ALSO TRIED DRIVER FROM STARDOG DOCUMENTATION: mssql-jdbc-6.2.1.jre8.jar -
Properties File
Location: /var/opt/stardog/data (I wasn’t sure where to copy this file!)
Name: mssql.properties (I wasn’t sure what to name this file!)
Contents:
jdbc.url=jdbc:sqlserver://localhost;databaseName=Northwind;
jdbc.username=SA
jdbc.password=***************
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
docker cp ' mssql.properties' 'ContainerID:/var/opt/stardog/data'
Create Virtual Graph window:
JDBC Connection URL: jdbc:sqlserver://localhost;databaseName=Northwind;user=SA;password=Monday*1;
JDBC User Name: SA
JDBC Password:*******
JDBC Driver Class: om.microsoft.sqlserver.jdbc.SQLServerDriver