Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[protege-discussion] Error converting KB to Oracle Database and SQL trace

Berens, Norbert BS at procom.de
Mon Oct 16 07:06:30 PDT 2006


Hi,

I surfed the web and the news groups looking for a solution for my
problem but i found nothing matching except a dead link to
http://protege.stanford.edu/mail_archive/msg07839.html

I'm , trying to convert a file based protege project to an Oracle data
base.MySQL and postgresql work fine, but when i try with Oracle 9.2 i'm
getting errors. Unfortunaltely we urgently need Oracle as the backend
store for our KB.
We are using the latest Oracle-JDBC-Driver (ojdbc14.jar) with Protege
3.1.
The error is as follows (from the Protege-log-file):

2006.10.16 14:53:57.498 CEST INFO: Created table with command 'CREATE
TABLE prowim.prowimora2 
(frame NUMBER NOT NULL, frame_type NUMBER NOT NULL, slot NUMBER NOT
NULL, facet NUMBER NOT NULL, is_template NUMBER NOT NULL, value_index
NUMBER NOT NULL, value_type NUMBER NOT NULL, short_value VARCHAR2(3066),
long_value LONG)' -- DatabaseFrameDb.createTable()
2006.10.16 14:53:57.498 CEST INFO: Getting 1129 frames, please be
patient, Mon Oct 16 14:53:57 CEST 2006 -- DatabaseFrameDb.saveFrames()
2006.10.16 14:54:01.780 CEST WARNING: Failed to create table on database
Oracle with command 'CREATE TABLE prowim.prowimora2 (frame NUMBER NOT
NULL, frame_type NUMBER NOT NULL, slot NUMBER NOT NULL, facet NUMBER NOT
NULL, is_template NUMBER NOT NULL, value_index NUMBER NOT NULL,
value_type NUMBER NOT NULL, short_value VARCHAR2(3066), long_value
LONG)' :ORA-00955: Es gibt bereits ein Objekt mit diesem Namen
 -- DatabaseFrameDb.createTable()

Nevertheless the table has been created. And there are exactly 5000
records within the table. Within the original mysql database from that i
created the file based version there are 10740 records.
Are there any known limitations with Oracle, that i have to handle? 
To get a clearer view on what happens at the DB-Interface i tried to
switch on the SQL trace within the protege.lax: 
(SimpleJdbcDatabaseManager.trace=true) but i don't see any SQL commands
on my console. How can I enable this trace? 

Is there anybody who can help me?

Kind regards

Norbert Berens











More information about the protege-discussion mailing list