oracle.sql.BLOB.DURATION_CALL与oracle.sql.BLOB.DURATION_SESSION的区别

oracle.sql.BLOB.DURATION_CALL vs oracle.sql.BLOB.DURATION_SESSION

What is the difference between the two?

两者有什么区别？

It is used to create a temporary LOB by calling the BLOB.createTemporary(connection, true, flag).

它用于通过调用BLOB.createTemporary（connection，true，flag）来创建临时LOB。

I have the following scenario:

我有以下情况：

All connections are pooled and never released till shutdown. I want the temporary LOB to be in existence only for a execution of preparedStatement (viz for insert. After insert, I don't need the lob). Which flag should I use?

所有连接都汇集在一起，直到关闭才会释放。我希望临时LOB仅用于执行preparedStatement（即插入。插入后，我不需要lob）。我应该使用哪个标志？

1 个解决方案

#1

My guess is that DURATION_SESSION is more suitable in this case.

我的猜测是DURATION_SESSION在这种情况下更合适。

Some links:

一些链接：

http://docs.oracle.com/cd/B12037_01/java.101/b10979/oralob.htm#i1060097

http://download.oracle.com/otn_hosted_doc/jdeveloper/905/jdbc-javadoc/constant-values.html#oracle.sql.BLOB.DURATION_CALL

http://docs.oracle.com/cd/B10501_01/appdev.920/a96591/adl11tmp.htm

#1