On 26/04/12 18:36, Mariusz Sepczuk wrote:
OK, so I should create table using sdb, not from sql developer?
Yes. See documentation - there's a command line tool to do it.
(You need the DB tools to create the database in the first place)
Andy
Dnia 26 kwietnia 2012 19:24 Andy Seaborne<[email protected]> napisał(a):
On 26/04/12 17:54, Mariusz Sepczuk wrote:
I forget write of course I downloaded SDB and add library to
eclipse.
As Damian says, let SDB format the tables. Your create the database,
then it's under the control of SDB.
Dnia 26 kwietnia 2012 18:33 Damian Steer<[email protected]>
napisał(a):
On 26 Apr 2012, at 17:18, Mariusz Sepczuk wrote:
Hi,
I created table using SQL Developer Create table sem(s
VARCHAR(200),p VARCHAR(200),o VARCHAR(200)); And insert data
INSERT INTO SEM VALUES ('<http://www.a.pl>','<http://www.b.pl>',
'ania'). Now using Jena and sdb I try select this data SELECT *
WHERE { ?s ?p ?o }. But I have error ORA-00942: table or view
does not exist... What is wrong?
That's sort of like "layout 1" which may work or may not - don't use it
for real (it exists to test the extensibility).
But it's the wrong table name anyway.
MS
Oracle's native RDF support is not the same as SDB, which stores a
graph in a relational database. You need the Oracle Jena adapter
(from Oracle), or alternatively use SDB to format the database.
Damian
Andy
