2 Replies Latest reply on Dec 19, 2016 9:02 PM by yenier

    Error Batch Loading N-Triple Format Semantic Data Using the Java API


      Hi all:


      I'm trying insert semantic data storage in N-Triple format (*.nt extension file), running the following command (Windows system) as is indicated in https://docs.oracle.com/database/121/RDFRM/GUID-1E972D71-0BBE-459E-8075-538ABE4F5911.htm#RDFRM598

      java -Ddb.user=kegg -Ddb.password=kegg -Ddb.host=localhost -Ddb.port=1521 -Ddb.sid=orcl -Dappend=true -Dcharset="UTF-8"  -classpath %ORACLE_HOME%\md\jlib\sdordf.jar;%ORACLE_HOME%\jdbc\lib\ojdbc6.jar oracle.spatial.rdf.client.BatchLoader  C:\Users\Yenier\Desktop\dados\kegg-drug.nt rdf_data rdf_users kegg_mat

      But it returns the following error:

      Temporary table already exists!

      java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

      ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 9731

      ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 9750

      ORA-06512: em "MDSYS.RDF_APIS", line 1759

      ORA-06512: em line 1

      More details are showed in the next figure:


      What can I do?


      I guess to dropping this temporary table, the problem will be resolved, but I don't know what is the table name in MDSYS user.