10g and cacheManager

From: Frederic Houbie <fh_at_ionicsoftDELETEME.com>
Date: Wed, 23 Jun 2004 09:51:28 +0200
Message-ID: <40d93680$0$8980$6c56d894@feed0.news.be.easynet.net>

Hi all,
using Oracle 10g cacheManager, do I have to reset the dbms_session before closing the connection, or is it done by Oracle ?

OracleConnectionCacheManager connMgr =
OracleConnectionCacheManager.getConnectionCacheManagerInstance(); Properties properties = new Properties();

properties.setProperty("MinLimit", "1");
properties.setProperty("MaxLimit", "25");
properties.setProperty("InitialLimit", "10");
properties.setProperty("ConnectionWaitTimeout", "10");
properties.setProperty("AbandonedConnectionTimeout", "900");

connMgr.createCache(m_CacheId, m_OracleDataSource, properties); Connection con = m_OracleDataSource.getConnection();

con.prepareCall("begin dbms_session.set_identifier(?);end;"); ps.setString(1, userName);
ps.execute();

/// Stuffs.....

// Do I need to reset the client identifier using
// dbms_session.set_identifier(null) ??? before closing?
// or is it done automatically,

con.close();

thanks

Frederic Received on Wed Jun 23 2004 - 02:51:28 CDT