-
1. Re: oracle 12c semantic jena nosql connection
alwu-Oracle Dec 1, 2014 5:22 PM (in response to 2804739)Hi Landong,
We support both Oracle Database and Oracle NoSQL Database. And Joseki works with both backend databases. Since you are installing Oracle DB 12c on AWS, you can focus on Jena Adapter for Oracle DB 12c and JDBC connection.
The following document is relevant.
https://docs.oracle.com/database/121/RDFRM/sem_jena.htm#RDFRM236
Hope it helps,
Zhe Wu
-
2. Re: oracle 12c semantic jena nosql connection
2804739 Dec 2, 2014 12:16 PM (in response to 2804739)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
-
3. Re: oracle 12c semantic jena nosql connection
2804739 Dec 2, 2014 12:57 PM (in response to 2804739)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
-
4. Re: oracle 12c semantic jena nosql connection
alwu-Oracle Dec 2, 2014 4:47 PM (in response to 2804739)Hi Landong,
A few things to check:
Did you copy ojdbc6.jar to
${CATALINA_HOME}/lib?
Did you modify context.xml?
Thanks,
Zhe Wu
-
5. Re: oracle 12c semantic jena nosql connection
2804739 Dec 2, 2014 6:04 PM (in response to alwu-Oracle)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
-
6. Re: oracle 12c semantic jena nosql connection
alwu-Oracle Dec 2, 2014 8:30 PM (in response to 2804739)Hi Landong,
I don't think you need to switch to WLS to get Joseki working. We use internally both WLS and Tomcat and they work fine. Please send me an email at alan dot wu at oracle dot com. I will show you how to turn on debug and then we will be able to find out what is going on.
Thanks,
Zhe Wu