Does Oracle's XMLType support JDBC batch updates?

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

Answers


I don't think Oracle types can tell how they're invoked, so the answer would be "yes".

The real question is: "What problem do you think that batch processing will introduce that real-time processing does not?"


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.


Need Your Help

Can anyone suggest a method of versioning ATTRIBUTE (rather than OBJECT) data in DB

database version temporal-database 6nf

Taking MySQL as an example DB to perform this in (although I'm not restricted to Relational flavours at this stage) and Java style syntax for model / db interaction.

creating .htaccess

java regex apache .htaccess struts2

I am developing a project with Struts2. I use jsp for web-side. I use MySQL database for my application and I installed wamp server for it. My urls are like localhost/xxx?name.action?blablabla... i...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.