This content has been marked as final.
Show 6 replies
-
1. Re: Problem with putting data in database
alwu-Oracle Apr 16, 2012 3:47 PM (in response to 923096)Hi,
The error message "... not method translateQueryPattern in class oracle/spatial/rdf/server/SQLEntryPoints"
probably means that your PL/SQL or JAVA packages were not 100% properly loaded.
You can try reloading sdordfty.sql and semrelod.sql. Please see the following thread.
Enabling Semantic Technologies in 11g R2
One thing to confirm. So you installed 11203 and loaded the catsem SQL from the ORACLE_HOME/md/admin directory,
right? Did you notice any error messages?
Thanks,
Zhe -
2. Re: Problem with putting data in database
923096 Apr 16, 2012 7:10 PM (in response to 923096)I installed 11.1 (because I have trouble with listener.) and I haven't got any error. Have you got idea why in SQL Developer always I have got MDSYS.SDO_RDF_TRIPLE_S in insert data?
Edited by: user8894354 on 2012-04-16 12:09 -
3. Re: Problem with putting data in database
alwu-Oracle Apr 17, 2012 4:20 PM (in response to 923096)Hi,
Could you try reloading sdordfty.sql and semrelod.sql? Please see the following thread.
Enabling Semantic Technologies in 11g R2
I am not sure what you meant by "I have got MDSYS.SDO_RDF_TRIPLE_S in insert data"
Could you please cut & paste here the error message?
Thanks,
Zhe -
4. Re: Problem with putting data in database
923096 Apr 18, 2012 12:31 PM (in response to 923096)I try reloaded thia file. When I do
INSERT INTO articles_rdf_data VALUES (1,
SDO_RDF_TRIPLE_S ('articles','http://nature.example.com/Article1',
'http://purl.org/dc/elements/1.1/title','All about XYZ'));
I want have row with number 1 and with for example All about XYZ. But I have number 1 and instead of All about XYZ I have String MDSYS.SDO_RDF_TRIPLE_S -
5. Re: Problem with putting data in database
Matperry-Oracle Apr 18, 2012 12:44 PM (in response to 923096)Hi,
Do you see the data with this query?
SELECT A.ID, A.TRIPLE.GET_SUBJECT() AS SUBJ, A.TRIPLE.GET_PROPERTY() AS PROP, A.TRIPLE.GET_OBJECT() AS OBJ
FROM ARTICLES_RDF_DATA A; -
6. Re: Problem with putting data in database
alwu-Oracle Apr 18, 2012 5:02 PM (in response to Matperry-Oracle)Hi,
In addition to what Matt suggested, I'd like to point out that ID column is not mandatory. An application table requires a column of type SDO_RDF_TRIPLE_S. If necessary, you can add additional columns to "associate" more information with triples. In this case, you used an ID column which can be used as an application specific+ way to identify triples.
Note that such additional columns will not be used by SPARQL queries (unless you manually join SEM_MATCH with your application table).
Thanks,
Zhe