Hi Andy, Sorry for the formatting issues. I have attached the configuration and exception log files for your reference.
The database server did not restart and it is highly unlikely for the Fuseki server to be idle as we execute a suite of tests regularly on hourly basis. Something which I missed in my previous e-mail is that we have deployed Fuseki on Tomcat 8. Is there a way to enable connection pooling or modify the configuration to use a PoolDataSource etc? Thanks, Akhilesh On Tue, Mar 29, 2016 at 3:05 PM, Andy Seaborne <[email protected]> wrote: > On 29/03/16 09:33, Bangalore Akhilesh wrote: > >> Hi, >> >> We have deployed fuseki with SDB against Oracle database. We have used >> *jena-sdb-3.1.0-20160211.100203-49* with >> *apache-jena-fuseki-2.4.0-SNAPSHOT* >> . >> >> It worked fine for few days before we started to experience the SQL >> connection closed problems. Can you please let me know why this is >> happening? Am I missing anything in the configuration? >> >> Below are my configuration and exception log. >> >> *Configuration:* >> > > This part has formatting problems: > > >> @prefix : <# <http://example.com/#>> . @prefix fuseki: < >> http://jena.apache.org/fuseki#> . @prefix rdf: < >> http://www.w3.org/1999/02/22-rdf-syntax-ns#> . @prefix rdfs: < >> http://www.w3.org/2000/01/rdf-schema#> . @prefix sdb: < >> http://jena.hpl.hp.com/2007/sdb#> . @prefix ja: < >> http://jena.hpl.hp.com/2005/11/Assembler#> . :service_sdb_all a fuseki: >> Service ; rdfs:label "SDB - Oracle" ; fuseki:name "oracle" ; fuseki: >> serviceQuery "query", "sparql" ; fuseki:serviceUpdate "update" ; fuseki: >> serviceUpload "upload" ; fuseki:serviceReadWriteGraphStore "data" ; >> fuseki: >> serviceReadGraphStore "get" ; fuseki:dataset :sdb_dataset_readwrite ; . : >> sdb_dataset_readwrite a sdb:DatasetStore ; sdb:store :rdbms_datastore . : >> rdbms_datastore a sdb:Store ; sdb:layout "layout2" ; sdb:connection : >> fuseki_data_conn ; . :fuseki_data_conn a sdb:SDBConnection ; sdb:sdbType " >> oracle" ; sdb:driver "oracle.jdbc.driver.OracleDriver" ; sdb:jdbcURL " >> jdbc:oracle:thin:@localhost:1521/xe" ; sdb:sdbUser "myuser" ; sdb: >> sdbPassword "password" ; . >> >> *Exception log:* >> >> [2016-03-28 20:45:46] Fuseki INFO [305964] 500 SQLException in >> executing SQL statement (1 ms) >> [2016-03-28 20:45:46] Fuseki INFO [305965] GET >> >> http://localhost:8080/fuseki/oracle/query?query=SELECT%20%3Fs%20%3Fp%20%3Fo%0D%0AWHERE%0D%0A%7B%0D%0A%20%20GRAPH%20%3Curn%3Amydepts%3Aplatforms%3Acustomers%3ATestCompany1%3E%20%7B%20%3Fs%20%3Fp%20%3Fo%20.%20%7D%0D%0A%7D%0D%0A >> [2016-03-28 20:45:46] Fuseki INFO [305965] GET /oracle :: 'query' :: >> <none> ? >> >> query=SELECT%20%3Fs%20%3Fp%20%3Fo%0D%0AWHERE%0D%0A%7B%0D%0A%20%20GRAPH%20%3Curn%3Amydepts%3Aplatforms%3Acustomers%3ATestCompany1%3E%20%7B%20%3Fs%20%3Fp%20%3Fo%20.%20%7D%0D%0A%7D%0D%0A >> [2016-03-28 20:45:46] Fuseki INFO [305965] Query = SELECT ?s ?p ?o >> WHERE { GRAPH <urn:mydepts:platforms:customers:TestCompany1> { ?s ?p >> ?o . } } >> *[2016-03-28 20:45:46] SDBConnection WARN execQuery: SQLException* >> *Closed Connection* >> > > It is not clear to me what's going on. > > Did the database server restart? > > Was the Fuseki server idle for a significant period of time prior to the > 500's starting? > > Andy > >
