6 Replies Latest reply on Apr 18, 2012 5:02 PM by alwu-Oracle

Problem with putting data in database

923096 Apr 15, 2012 8:25 PM

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-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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions
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;
Like Show 0 Likes(0)

Actions
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
Like Show 0 Likes(0)

Actions

Go to original post