1 Reply Latest reply: Jan 18, 2013 5:57 PM by alwu-Oracle RSS

    can bind a LONG value only for insert into a LONG column

    981327
      I got an exception when I was using sesame adapter to dump a turtle file which contains long texts as objects into oracle semantic database. The exception information is:
      org.openrdf.repository.RepositoryException: org.openrdf.sail.SailException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
      ORA-06512: in "SF.ORACLE_ORARDF_ADDHELPER", line 1
      ORA-06512: in line 1
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
           at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4735)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
           at oracle.spatial.rdf.client.sesame.OracleSailConnection.addStatement(OracleSailConnection.java:1976)
           at org.openrdf.repository.sail.SailRepositoryConnection.addWithoutCommit(SailRepositoryConnection.java:249)
           at org.openrdf.repository.base.RepositoryConnectionBase.add(RepositoryConnectionBase.java:510)
           at org.openrdf.repository.util.RDFInserter.handleStatement(RDFInserter.java:193)
           at org.openrdf.rio.turtle.TurtleParser.reportStatement(TurtleParser.java:963)
           at org.openrdf.rio.turtle.TurtleParser.parseObject(TurtleParser.java:416)
           at org.openrdf.rio.turtle.TurtleParser.parseObjectList(TurtleParser.java:339)
           at org.openrdf.rio.turtle.TurtleParser.parsePredicateObjectList(TurtleParser.java:315)
           at org.openrdf.rio.turtle.TurtleParser.parseTriples(TurtleParser.java:301)
           at org.openrdf.rio.turtle.TurtleParser.parseStatement(TurtleParser.java:208)
           at org.openrdf.rio.turtle.TurtleParser.parse(TurtleParser.java:186)
           at org.openrdf.rio.turtle.TurtleParser.parse(TurtleParser.java:131)
           at org.openrdf.repository.base.RepositoryConnectionBase.addInputStreamOrReader(RepositoryConnectionBase.java:404)
           at org.openrdf.repository.base.RepositoryConnectionBase.add(RepositoryConnectionBase.java:295)
           at org.openrdf.repository.base.RepositoryConnectionBase.add(RepositoryConnectionBase.java:226)
           at sforcl.dao.support.OracleSailDaoTemplate.addTTLFile(OracleSailDaoTemplate.java:114)
           at sforcl.test.OracleSailDaoTemplateTest.testAddTTLFile(OracleSailDaoTemplateTest.java:33)
           at sforcl.test.OracleSailDaoTemplateTest.main(OracleSailDaoTemplateTest.java:122)
      How can I solve this problem?