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!

Batch loader error - ORA-55328

630782Apr 3 2008 — edited May 19 2008
Hi,

I got the following error when I used the oracle.spatial.rdf.client.BatchLoader to load the data file into the database.

Loading up to rows = 1431875
java.sql.BatchUpdateException: ORA-55303: SDO_RDF_TRIPLE_S constructor failed: batch-mode + BNode-non-reuse
M= ORA-55328: literal value "Pseudoalteromonas atlantica strain T6c" insert attempt failed
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 333

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:602)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1248)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.ja
at oracle.spatial.rdf.client.NTripleConverter.loadNTriple(NTripleConverter.java:601)
at oracle.spatial.rdf.client.BatchLoader.main(BatchLoader.java:302)

The triple with that particular literal is:
<http://purl.uniprot.org/taxonomy/342610> <http://purl.uniprot.org/core/otherName> "Pseudoalteromonas atlantica strain T6c" .

I can't see any problem with the triple.

What cause the error and how to fix it? Thanks,

Weihua
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2008
Added on Apr 3 2008
9 comments
3,731 views