embulk-output-jdbc icon indicating copy to clipboard operation
embulk-output-jdbc copied to clipboard
verified publisher icon embulk

OracleOutputPluginTest#testInsertDirectDirectMethod fails

Open hito4t opened this issue 9 years ago • 4 comments 

Caused by: java.lang.AssertionError
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12146)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
    at org.embulk.output.jdbc.StandardBatchInsert.flush(StandardBatchInsert.java:74)
    at org.embulk.output.jdbc.StandardBatchInsert.finish(StandardBatchInsert.java:87)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput$4.run(AbstractJdbcOutputPlugin.java:976)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1070)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$RetryableSQLExecution.call(AbstractJdbcOutputPlugin.java:1058)
    at org.embulk.spi.util.RetryExecutor.run(RetryExecutor.java:100)
    at org.embulk.spi.util.RetryExecutor.runInterruptible(RetryExecutor.java:77)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1042)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.withRetry(AbstractJdbcOutputPlugin.java:1035)
    at org.embulk.output.jdbc.AbstractJdbcOutputPlugin$PluginPageOutput.finish(AbstractJdbcOutputPlugin.java:972)
    at org.embulk.exec.LocalExecutorPlugin$ScatterTransactionalPageOutput.finish(LocalExecutorPlugin.java:496)
    at org.embulk.spi.PageBuilder.finish(PageBuilder.java:244)
    at org.embulk.standards.CsvParserPlugin.run(CsvParserPlugin.java:393)
    at org.embulk.spi.FileInputRunner.run(FileInputRunner.java:154)
    at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.runInputTask(LocalExecutorPlugin.java:294)
    at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor.access$000(LocalExecutorPlugin.java:212)
    at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:257)
    at org.embulk.exec.LocalExecutorPlugin$ScatterExecutor$1.call(LocalExecutorPlugin.java:253)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    ... 3 more

hito4t avatar Sep 08 '16 04:09 hito4t

I'm seeing the same error in my application when I enable batching in the driver - did you figure out what causes this?

tadhgpearson avatar Oct 20 '17 02:10 tadhgpearson

@tadhgpearson No. insert_method: direct worked if executed in command line ( embulk run xxx.yml). But failed if executed with EmbulkEmbed. How did you execute embulk-output-oracle?

hito4t avatar Oct 24 '17 08:10 hito4t

I wasn't using embark - I got this error in my own Hibernate-based application.

tadhgpearson avatar Oct 27 '17 00:10 tadhgpearson

I see. This problem might be caused by ClassLoader. In Embulk, Oracle JDBC Driver is not loaded by the system class loader, but by a custom class loader of Embulk.

hito4t avatar Oct 27 '17 05:10 hito4t