Search code examples
javaoraclejdbcbatch-filexmltype

Does Oracle's XMLType support JDBC batch updates?

Does Oracle's JDBC implementation support XMLType batch updates (via PreparedStatement.addBatch())?

Solution

  • After a lot of research, it appears like a known limitation of Oracle's JDBC implementation is that it does not support "stream types" as bind variables (XMLType being a stream type).

    According to their own documentation:

    Oracle's implementation of standard update batching does not support stream types as bind values. (This is also true of Oracle update batching.) Any attempt to use stream types will result in an exception.