10 Replies Latest reply on Oct 21, 2015 10:41 PM by alwu-Oracle

    Fuseki - java.sql.SQLRecoverableException

    Akhilesh Bangalore

      Hi,

       

      We have launched an instance of the Fuseki adapter against Oracle 11g.

       

      After leaving the instance idle for a week or so, we have encountered java.sql.SQLRecoverableException.

      Full error message - java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error

       

      I have tried to supply the jetty configuration containing a JNDI resource with commons-dbcp datasource so that I can supply a validationQuery to keep the connections active. But Fuseki cant seem to find this resource when supplying a configuration with datasource at the command line.

       

      Deploying Fuseki into WebLogic might ease the JNDI creation but would require a war file. I have created Fuseki - Packaging as war discussion for the same.

       

      Any suggestions to resolve the SQLRecoverableException will be helpful.

       

      Thanks,

      Akhilesh

        • 1. Re: Fuseki - java.sql.SQLRecoverableException
          alwu-Oracle

          Hi,

           

          Could you please use Fuseki 1.0.1 (as a standalone application) and Apache Jena 2.11.1 together with the latest Jena Adapter (support for Apache Jena) and see if the problem goes away? We have done a whole lot of testing and stress testing against Oracle 11.2.0.3 (and 11.2.0.4) and we haven't seen such an exception before.

           

          Thanks,

           

          Zhe Wu

          • 2. Re: Fuseki - java.sql.SQLRecoverableException
            Akhilesh Bangalore

            Hi Zhe Wu,

             

            We have encountered this error while running in standalone mode.

             

            The fuseki server was run on a windows 2008 server.

             

            It was started with a configuration at the commandline.

             

            java -jar fuseki-server.jar --config config-oracle.rdf

            Thanks,

            Akhilesh

            • 3. Re: Fuseki - java.sql.SQLRecoverableException
              Akhilesh Bangalore

              Hi,

               

              Below is the full stack trace.

               

              C:\Jena\Adapter for Jena 2.11.1\fuseki>java -jar fuseki-server.jar --config config-oracle.rdf

              13:55:28 INFO  startMonitor: starts

              13:55:29 INFO  performInference: has valid entailment already

              13:55:29 INFO  Dataset path = /oracle

              13:55:29 INFO  Fuseki 1.0.1 2014-01-18T19:01:20+0000

              13:55:29 INFO  Started 2015/09/09 13:55:29 UTC on port 3030

              07:46:50 INFO  [1] GET http://localhost:3030/oracle/query?query=select+%3Fs+%3Fp+%3Fo+%3Fg%0D%0A%7B%0D%0AGraph+%3Fg+%7B%3Fs+%3Fp+%3Fo%7D%0D%0A%

              07:46:50 INFO  [1] Query = select ?s ?p ?o ?g  {  Graph ?g {?s ?p ?o}  }

              07:46:50 ERROR getGraph:

              java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:897)

                      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

                      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)

                      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)

                      at oracle.spatial.rdf.client.jena.Oracle.executeQueryWithArg(Oracle.java:559)

                      at oracle.spatial.rdf.client.jena.OracleModelBase.isValidModel(OracleModelBase.java:2101)

                      at oracle.spatial.rdf.client.jena.OracleNamedGraph.<init>(OracleNamedGraph.java:352)

                      at oracle.spatial.rdf.client.jena.OracleNamedGraph.<init>(OracleNamedGraph.java:283)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getGraph(DatasetGraphOracleSem.java:688)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getDefaultGraph(DatasetGraphOracleSem.java:624)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getDefaultGraph(DatasetGraphOracleSem.java:280)

                      at oracle.spatial.rdf.client.jena.QueryEngineSem.eval(QueryEngineSem.java:155)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:137)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:107)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:88)

                      at oracle.spatial.rdf.client.jena.QueryEngineSem$1.create(QueryEngineSem.java:213)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:530)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:474)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:515)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:173)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeQuery(SPARQL_Query.java:274)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.execute(SPARQL_Query.java:241)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeWithParameter(SPARQL_Query.java:195)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.perform(SPARQL_Query.java:80)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.executeLifecycle(SPARQL_ServletBase.java:171)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.executeAction(SPARQL_ServletBase.java:152)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.execCommonWorker(SPARQL_ServletBase.java:140)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.doCommon(SPARQL_ServletBase.java:69)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.doGet(SPARQL_Query.java:61)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)

                      at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)

                      at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448)

                      at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:82)

                      at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:294)

                      at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419)

                      at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455)

                      at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)

                      at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)

                      at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)

                      at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)

                      at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)

                      at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)

                      at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)

                      at org.eclipse.jetty.server.Server.handle(Server.java:370)

                      at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)

                      at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53)

                      at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949)

                      at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011)

                      at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)

                      at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)

                      at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72)

                      at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298)

                      at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)

                      at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)

                      at java.lang.Thread.run(Unknown Source)

              Caused by: java.net.SocketException: Connection reset by peer: socket write error

                      at java.net.SocketOutputStream.socketWrite0(Native Method)

                      at java.net.SocketOutputStream.socketWrite(Unknown Source)

                      at java.net.SocketOutputStream.write(Unknown Source)

                      at oracle.net.ns.DataPacket.send(DataPacket.java:210)

                      at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230)

                      at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:312)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)

                      at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

                      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)

                      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

                      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

                      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)

                      ... 57 more

              07:46:50 WARN  [1] RC = 500 : java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error

              com.hp.hpl.jena.shared.JenaException: java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getGraph(DatasetGraphOracleSem.java:701)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getDefaultGraph(DatasetGraphOracleSem.java:624)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getDefaultGraph(DatasetGraphOracleSem.java:280)

                      at oracle.spatial.rdf.client.jena.QueryEngineSem.eval(QueryEngineSem.java:155)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.evaluate(QueryEngineBase.java:137)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.createPlan(QueryEngineBase.java:107)

                      at com.hp.hpl.jena.sparql.engine.QueryEngineBase.getPlan(QueryEngineBase.java:88)

                      at oracle.spatial.rdf.client.jena.QueryEngineSem$1.create(QueryEngineSem.java:213)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.getPlan(QueryExecutionBase.java:530)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.startQueryIterator(QueryExecutionBase.java:474)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execResultSet(QueryExecutionBase.java:515)

                      at com.hp.hpl.jena.sparql.engine.QueryExecutionBase.execSelect(QueryExecutionBase.java:173)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeQuery(SPARQL_Query.java:274)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.execute(SPARQL_Query.java:241)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.executeWithParameter(SPARQL_Query.java:195)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.perform(SPARQL_Query.java:80)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.executeLifecycle(SPARQL_ServletBase.java:171)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.executeAction(SPARQL_ServletBase.java:152)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.execCommonWorker(SPARQL_ServletBase.java:140)

                      at org.apache.jena.fuseki.servlets.SPARQL_ServletBase.doCommon(SPARQL_ServletBase.java:69)

                      at org.apache.jena.fuseki.servlets.SPARQL_Query.doGet(SPARQL_Query.java:61)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)

                      at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)

                      at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)

                      at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448)

                      at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:82)

                      at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:294)

                      at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419)

                      at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455)

                      at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)

                      at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)

                      at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)

                      at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)

                      at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)

                      at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)

                      at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)

                      at org.eclipse.jetty.server.Server.handle(Server.java:370)

                      at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)

                      at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53)

                      at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949)

                      at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011)

                      at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)

                      at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)

                      at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72)

                      at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298)

                      at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)

                      at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)

                      at java.lang.Thread.run(Unknown Source)

              Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:897)

                      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

                      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

                      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)

                      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)

                      at oracle.spatial.rdf.client.jena.Oracle.executeQueryWithArg(Oracle.java:559)

                      at oracle.spatial.rdf.client.jena.OracleModelBase.isValidModel(OracleModelBase.java:2101)

                      at oracle.spatial.rdf.client.jena.OracleNamedGraph.<init>(OracleNamedGraph.java:352)

                      at oracle.spatial.rdf.client.jena.OracleNamedGraph.<init>(OracleNamedGraph.java:283)

                      at oracle.spatial.rdf.client.jena.DatasetGraphOracleSem.getGraph(DatasetGraphOracleSem.java:688)

                      ... 47 more

              Caused by: java.net.SocketException: Connection reset by peer: socket write error

                      at java.net.SocketOutputStream.socketWrite0(Native Method)

                      at java.net.SocketOutputStream.socketWrite(Unknown Source)

                      at java.net.SocketOutputStream.write(Unknown Source)

                      at oracle.net.ns.DataPacket.send(DataPacket.java:210)

                      at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230)

                      at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:312)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)

                      at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)

                      at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)

                      at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

                      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)

                      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

                      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

                      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)

                      ... 57 more

              07:46:50 INFO  [1] 500 java.sql.SQLRecoverableException: IO Error: Connection reset by peer: socket write error (53 ms)

              07:55:05 WARN  deregister: attempting to close reference from graph null when there are no references to close

               

              Thanks,

              Akhilesh

              • 4. Re: Re: Fuseki - java.sql.SQLRecoverableException
                Akhilesh Bangalore

                ... and below is the rdf configuration.

                 

                <?xml version="1.0" encoding="utf-8" ?>
                <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
                         xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#"
                         xmlns:ora-jena-joseki="http://www.oracle.com/2009/05/orardf/jena-joseki-ns#"
                         xmlns:jena-fuseki="http://jena.apache.org/fuseki#"
                         xmlns:jena-assembler="http://jena.hpl.hp.com/2005/11/Assembler#">
                
                  <rdf:Description rdf:about="http://www.oracle.com/2009/05/orardf/jena-joseki-ns#Dataset">
                    <rdfs:subClassOf rdf:resource="http://jena.hpl.hp.com/2005/11/Assembler#RDFDataset"/>
                  </rdf:Description>
                
                  <rdf:Description rdf:about="http://fuseki.configuration.me/#oracle">
                    <rdf:type rdf:resource="http://www.oracle.com/2009/05/orardf/jena-joseki-ns#Dataset"/>
                    <ora-jena-joseki:connection>
                      <ora-jena-joseki:OracleConnection>
                        <ora-jena-joseki:jdbcURL>jdbc:oracle:thin:@my-oracle-server.com:1521:XE</ora-jena-joseki:jdbcURL>
                        <ora-jena-joseki:User>xxxxxx</ora-jena-joseki:User>
                        <ora-jena-joseki:Password>xxxxxx</ora-jena-joseki:Password>
                      </ora-jena-joseki:OracleConnection>
                    </ora-jena-joseki:connection>
                
                    <ora-jena-joseki:allGraphs>
                      <rdf:Description>
                        <ora-jena-joseki:firstModel>RELATIONS</ora-jena-joseki:firstModel>
                        <ora-jena-joseki:rulebaseName>RELATIONS_RB</ora-jena-joseki:rulebaseName>
                      </rdf:Description>
                    </ora-jena-joseki:allGraphs>
                  </rdf:Description>
                
                  <rdf:Description rdf:about="http://fuseki.configuration.me/#service1">
                    <rdf:type rdf:resource="http://jena.apache.org/fuseki#Service"/>
                    <jena-fuseki:name>oracle</jena-fuseki:name>
                    <jena-fuseki:serviceQuery>sparql</jena-fuseki:serviceQuery>
                    <jena-fuseki:serviceQuery>query</jena-fuseki:serviceQuery>
                    <jena-fuseki:serviceUpdate>update</jena-fuseki:serviceUpdate>
                    <jena-fuseki:serviceUpload>upload</jena-fuseki:serviceUpload>
                    <jena-fuseki:serviceReadWriteGraphStore>data</jena-fuseki:serviceReadWriteGraphStore>
                    <jena-fuseki:serviceReadGraphStore>get</jena-fuseki:serviceReadGraphStore>
                    <jena-fuseki:dataset rdf:resource="http://fuseki.configuration.me/#oracle"/>
                  </rdf:Description>
                
                  <rdf:Description rdf:about="http://fuseki.configuration.me/#emptyDataset">
                    <rdf:type rdf:resource="http://jena.hpl.hp.com/2005/11/Assembler#RDFDataset"/>
                  </rdf:Description>
                
                  <jena-fuseki:Server rdf:nodeID="genid1">
                    <jena-fuseki:services>
                      <rdf:Description>
                        <rdf:first rdf:resource="http://fuseki.configuration.me/#service1"/>
                        <rdf:rest rdf:resource="http://www.w3.org/1999/02/22-rdf-syntax-ns#nil"/>
                      </rdf:Description>
                    </jena-fuseki:services>
                  </jena-fuseki:Server>
                
                  <rdf:Description rdf:nodeID="genid3">
                    <jena-assembler:loadClass>oracle.spatial.rdf.client.jena.assembler.OracleAssemblerVocab</jena-assembler:loadClass>
                  </rdf:Description>
                
                </rdf:RDF>
                
                • 5. Re: Fuseki - java.sql.SQLRecoverableException
                  alwu-Oracle

                  Which DB version are you using?

                   

                  Thanks,

                   

                  Zhe Wu

                  • 6. Re: Fuseki - java.sql.SQLRecoverableException
                    Akhilesh Bangalore

                    Oracle 11g - 11.2.0.4

                     

                    Thanks,

                    • 7. Re: Fuseki - java.sql.SQLRecoverableException
                      alwu-Oracle

                      Thanks.

                       

                      Can you please take a look at the following document and set SQLNET.EXPIRE_TIME, SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.OUTBOUND_CONNECT_TIMEOUT?

                       

                      https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm

                       

                      Thanks,

                       

                      Zhe Wu

                      • 8. Re: Fuseki - java.sql.SQLRecoverableException
                        Akhilesh Bangalore

                        Hi Zhe Wu,

                         

                        In the document, there is a recommended value for the expire time. What are the recommended values for inbound & outbound timeouts?

                         

                        Before I make a change, I have a question - I think these settings will apply to the whole of Oracle server not just the instance which supports triples!

                         

                        Thanks,

                        Akhilesh

                        • 9. Re: Fuseki - java.sql.SQLRecoverableException
                          alwu-Oracle

                          Hi Akhilesh,

                           

                          Let's set expire time to 1 and leave inbound & outbound untouched, for now.

                          Yes, this setting applies to the whole database. Please let us know if the SQLRecoverableException

                          goes away.

                           

                          Thanks,

                           

                          Zhe Wu

                          • 10. Re: Fuseki - java.sql.SQLRecoverableException
                            alwu-Oracle

                            Hi,

                             

                            Did the problem get fixed with SQLNET.EXPIRE_TIME setting?

                             

                            Thanks,


                            Zhe Wu