Problem after Jena Patch
560844Nov 27 2007 — edited Jan 2 2008I have just applied the Jena patch for 11g and I am now having trouble with the BatchLoader. The output from my batch command is:
Note: You can use JVM properties -Ddb.user=<user> -Ddb.password=<password> -Ddb.host=<host> -Ddb.sid=<sid> -Ddb.port=<port> to configure database connection.
JVM property -Dappend=true can be used to specify APPEND mode. By default, this option is false.
JVM property -Dexchange=true can be used to allow table partition exchange which is faster and less space consuming.
This option is less robust though. By default, it is false
Connecting to jdbc:oracle:thin:@dev1.company.com:1521:MUM as user demo
Append mode
Copy existing data out
Just load triples into one column
Temporary table already exists!
java.sql.SQLException: ORA-00955: name is already used by an existing object
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3449
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3485
ORA-06512: at "MDSYS.RDF_APIS", line 910
ORA-06512: at line 1
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:944)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3839)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1085)
at oracle.spatial.rdf.client.NTripleConverter.loadNTriple(NTripleConverter.java:391)
at oracle.spatial.rdf.client.BatchLoader.main(BatchLoader.java:302)
I have tried dropping and re-creating all sorts of things, but I've stopped shy of dropping and re-creating the MDSYS user. Any thoughts on the cause of this problem?
Message was edited by:
StinkyMatt