Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem after Jena Patch

560844Nov 27 2007 — edited Jan 2 2008
I 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

Comments

Fran
welcome to OTN forums.

Please search before post:
9648502
2305368
2201373

When the issue will be solved, remember mark this question as answered to keep clean that forum.
900442
you may try and use fully qualified host names instead of the simple host name when trying to establish a connection from sql developer.

Regards,
Raj K.
Osama_Mustafa
Refer to
SQL Developer Shows "Connection Closed" Error When Running a Query [ID 1297692.1]
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 30 2008
Added on Nov 27 2007
5 comments
3,625 views