Problem with putting data in database

923096 Apr 15, 2012 1:25 PM

Currently Being Moderated

Hi,

I configured database for semantic technology and I tested it using scrip (in SQL DEVELOPER)t:

CREATE TABLE articles_rdf_data (id NUMBER, triple SDO_RDF_TRIPLE_S);

EXECUTE SEM_APIS.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple');

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'));*

INSERT INTO articles_rdf_data VALUES (2,
SDO_RDF_TRIPLE_S ('articles','http://nature.example.com/Article1',
*'http://purl.org/dc/elements/1.1/creator',*
*'Jane Smith'));*
As result I had table with two column id and triple. But in triple I have got only MDSYS.SDO_RDF_TRIPLE_S not my insert data. What I should to have my insert data in table?
Another problem is when i use SQL*Plus and do the same steps I get error there are not method translateQueryPattern in class oracle/spatial/rdf/server/SQLEntryPoints

Edited by: user8894354 on 2012-04-15 13:22

1. Re: Problem with putting data in database

alwu Apr 16, 2012 8:47 AM (in response to 923096)

Currently Being Moderated

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
Report Abuse

Like (0)
2. Re: Problem with putting data in database

923096 Apr 16, 2012 12:10 PM (in response to 923096)

Currently Being Moderated

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
Report Abuse

Like (0)
3. Re: Problem with putting data in database

alwu Apr 17, 2012 9:20 AM (in response to 923096)

Currently Being Moderated

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
Report Abuse

Like (0)
4. Re: Problem with putting data in database

923096 Apr 18, 2012 5:31 AM (in response to 923096)

Currently Being Moderated

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
Report Abuse

Like (0)
5. Re: Problem with putting data in database

matperry Apr 18, 2012 5:44 AM (in response to 923096)

Currently Being Moderated

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;
Report Abuse

Like (0)
6. Re: Problem with putting data in database

alwu Apr 18, 2012 10:02 AM (in response to matperry)

Currently Being Moderated

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
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points