oracle 12c semantic jena nosql connection

Hi Zhe Wu,

Thanks for the information.

I have enabled the semantic graph support on Oracle 12 C AWS following the example of https://docs.oracle.com/database/121/RDFRM/sdo_rdf_concepts.htm#RDFRM602

However, I am having problem to connect joseki/Tomcat to the Oracle DB.

I am using the Jena adapter (jena_adapter_12101_for_apache_jena_2.7.2) downloaded from here

Oracle Semantic Technologies Downloads

The built-in joseki.war was deployed to a Apache Tomcat 7.0.57.  the joseki-config.ttl has the following syntax:

## --------------------------------------------------------------

## Datasets

#

[] ja:loadClass "oracle.spatial.rdf.client.jena.assembler.OracleAssemblerVocab" .

oracle:Dataset  rdfs:subClassOf  ja:RDFDataset .

<#oracle> rdf:type oracle:Dataset;

    joseki:poolSize     2 ;         ## Number of concurrent connections allowed to this dataset.

    oracle:connection

    [ a oracle:OracleConnection ;

    ];

    oracle:allGraphs [ oracle:firstModel "M_NAMED_GRAPHS" ] .

#    oracle:defaultModel [ oracle:firstModel "ABOX"; oracle:modelName "TBOX"; oracle:rulebaseName "OWLPRIME"; oracle:useVM "TRUE" ] .

## --------------------------------------------------------------

The Joseki interface shows up but the click on "submit query" will hang forever with no response. there is no error/exception in the Tomcat log.

I am wondering if I've missed any obvious step during the setting-up?

Thanks,

Landong

Btw,  I've followed the example of https://docs.oracle.com/database/121/RDFRM/sdo_rdf_concepts.htm#RDFRM604 to insert triples to SQL.

So, the backend DB and SEM_API are working well.

I've created the JDBC resource and resource link in Tomcat https://docs.oracle.com/database/121/RDFRM/sem_jena.htm#RDFRM743

<Resource name="OracleSemDS" auth="Container" type="oracle.jdbc.pool.OracleDataSource" driverClassName="oracle.jdbc.OracleDriver" factory="oracle.jdbc.pool.OracleDataSourceFactory" url="jdbc:oracle:thin:@127.0.01:1521:triples" user="rdfuser" password="password" maxActive="30" maxIdle="10" maxWait="-1"/>

the process seems to be straightforward on jdbc, however I have not been able to get it up and running.

is there any suggestion and advise?

Thanks ,

Landong

Hi Zhe Wu,

Yes, I did both .  I've also tried JDBC from anther java application, the JDBC link, username and password actually work well with the Jar file.

Any clue ? or shall I go for webLogic?

Thanks,

Landong