Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

End of TNS Channel in Oracle-Jena adaptor

669888Dec 17 2008 — edited Dec 17 2008
Hi,

I'm using the Oracle-Jena adaptor 2.0 to create a sparql endpoint using Joseki. I am performing validation check and if the connection is dead I try to recreate it by calling:

Oracle oracle = new Oracle(uri, name, passwd);
GraphOracleSem g = new GraphOracleSem(oracle, modelName);
defaultModel = new ModelOracleSem(graph);

However when I try to query the model I get an exception stating "end of TNS Channel". The setup works fine initially. What is the correct way to re-establish a connection to Oracle using the Oracle-Jena adaptor?

Thanks

Comments

alwu-Oracle
Is it caused by connection timeout?

Thanks,
669888
I'm trying to recover from a connection that is no longer valid, whether it timed out or was killed, etc. From the servlet, I call ((OracleConnection)connection).pingDatabase() to see if the connection is alive and if not recreate it
669888
Oops, its a Joseki issue. Turns out Joseki was holding onto an old copy of the Model and was trying to run queries off of that even though begin() was called on the new Model.
Sorry to bother
alwu-Oracle
That is fine. Please keep us informed about your progress with Joseki. We will be more than happy to assist.

Cheers.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 14 2009
Added on Dec 17 2008
#database-key-features, #rdf-graph-property-graph
4 comments
2,461 views