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:
Added the following databases to the image above:
• Northwind (a Microsoft sample database)
Pushed changes to the following image:
Set up MS SQL Server on Linux, including all MS sample databases, and pushed changes to the following image:
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
Stardog is running JRE version 18, so driver must be version 7.0 or above.
Download JDBC driver version 8.2 (latest available)
Set up STARDOG_EXT environment inside the docker container, as per instructions in the link below:
docker exec -u root -t -i container_id /bin/bash (requires space after container¬¬_id)
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
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
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!)
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