I just realized that if you want to try working with the package I posted earlier that you’ll have to modify the configuration to use the Oracle driver and if you’re using Tomcat you’ll have to extract the war file into a directory, drop the oracle jdbc library in the WEB-INF/lib directory then rebuild another war files using the jar command.
From: Bangalore Akhilesh [mailto:[email protected]] Sent: Tuesday, March 29, 2016 6:53 AM To: [email protected] Subject: Re: Fuseki with SDB - connection closed exception 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]<mailto:[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/#<http://example.com/>>> . @prefix fuseki: < http://jena.apache.org/fuseki#<http://jena.apache.org/fuseki>> . @prefix rdf: < http://www.w3.org/1999/02/22-rdf-syntax-ns#<http://www.w3.org/1999/02/22-rdf-syntax-ns>> . @prefix rdfs: < http://www.w3.org/2000/01/rdf-schema#<http://www.w3.org/2000/01/rdf-schema>> . @prefix sdb: < http://jena.hpl.hp.com/2007/sdb#<http://jena.hpl.hp.com/2007/sdb>> . @prefix ja: < http://jena.hpl.hp.com/2005/11/Assembler#<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
