Virtual graph based on a SQL database


(rohit pandey) #1

I am trying to map a simple table from an SQL database into Stardog. When ever I try to add the virtual graph I get the same error message.

“Unable to load class: com.microsoft.sqlserver.jdbc.SQLServerDriver from ClassLoader:sun.misc.Launcher$AppClassLoader@4783da3f;ClassLoader:java.net.URLClassLoader@3af6317c”

My properties file has:
jdbc.url=jdbc:sqlserver://PARABOLE-PC;databaseName=TestDatabase_Demo;
jdbc.username=********
jdbc.password=***********
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

Also I am not sure about username and password.My SQL server has windows authentication so I am using the password and username which I use to login to my laptop.


(stephen) #2

Hi,

In order for the ClassLoader to find your JDBC class, you need to have the JAR file either in $STARDOG_EXT or $STARDOG/server/dbms (i.e., somewhere on the classpath) when you start the Stardog server. If you copy the jar to one of those places and restart your server this error will go away.


(system) #3

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.