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
