On 03 Mar 2005 11:38, rajwani wrote:

>Interceptor approach does not guarnatee the release of temporary
>clob/blob memory as postFlush is not called if insert/update fails.

We call the code which cleans up the thread level temporary blob/clob in
post flush and also in servlet filter. Servlet filter call is there to
take care of blob/clobs missed by postFlush as it is not called in case
of errors. When the call is made in filter I get the following
exception. Can I just ignore it? as according to the oracle
documentation SQLException is throw by freeTemporary if clob/blod is
permanent or is already free. Exception message if not clear.

http://download-east.oracle.com/otn_hosted_doc/jdeveloper/904preview/jdbc-javadoc/oracle/sql/BLOB.html#freeTemporary()

java.sql.SQLException: Must be logged on to server
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
        at
oracle.jdbc.ttc7.TTC7Protocol.assertLoggedIn(TTC7Protocol.java:2296)
        at
oracle.jdbc.ttc7.TTC7Protocol.freeTemporaryLob(TTC7Protocol.java:3351)
        at
oracle.sql.LobDBAccessImpl.freeTemporary(LobDBAccessImpl.java:774)
        at oracle.sql.CLOB.freeTemporary(CLOB.java:1085)
        at oracle.sql.CLOB.freeTemporary(CLOB.java:1036)