OK, so I should create table using sdb, not from sql developer?
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 >
