Re: TAF and FCF together ?

Hi Kuassi, could you discuss the ramifications of these TAF considerations as it relates to JDBC?

(metalink registration required)

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=97926.1

Under what conditions would a running JDBC application suffer from "Continuing work on existing cursors may raise an error
(eg: ORA-25401 "cannot continue fetches")"? Will existing
PreparedStatements
ever become defunct?

When will JDBC queries fail with "Failed over selects may raise an error"
and what error?

Do JDBC connections ever rely on having altered the session state with such calls as "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';" or global temp tables, which will be lost on failover?

If a JDBC client is using the Oracle OCI driver, doing transactions, how/when
to they know that a failover occurred so they know to roll back?

thanks,
Joe Received on Thu Sep 14 2006 - 17:00:24 CDT