I downloaded Stardog on Linux machine. I created virtual graph for a database which is present in some other windows machine. then I installed Stardog studio on some windows machine. Now i am trying to query the virtual graph created in Linux machine on windows machine using stardog studio. It works fine for sometime and then it says connection is closed. Then i remove the virtual graph and add it again. Not sure what the problem is but it looses its connection frequently. Is there some sort of Time out that i can set/modify?
Which database platform are you creating the virtual graph for? What the error you are seeing? Have you tried tuning the Tomcat JDBC pooling options as mentioned in the docs?
I am connecting Microsoft SQL Server . The error looks like:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
** at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:228) ~[mssql-jdbc-6.4.0.jre8.jar:?]**
** at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1007) ~[mssql-jdbc-6.4.0.jre8.jar:?]**
** at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:3160) ~[mssql-jdbc-6.4.0.jre8.jar:?]**
** at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:2838) ~[mssql-jdbc-6.4.0.jre8.jar:?]**
** at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source) ~[?:?]**
I have not tried those attributes. Will probably try maxWait or maxAge.
Thank you!