You would want to use connection pooling, where sessions are recycled; see import oracle.jdbc.pool.OracleDataSource
Joined: Nov 20, 2005
Hi . Actually I meant what impact would it make on my application performance if such calls are made frequantly. As of now , i'm using WSAD and working with pooled connections only.
But , due to some design issues , I need to make such calls frequently. so, i wanted to know the seriousness of such calls. In my env , Db server is an independent system and Application(server) runs on a diff system.
Naveen, No more so than using the pooled connection directly. WebSphere (or any other app server) lets you pick the class used in the data source. So you can still use the pooled connection and get the same benefits. More in fact, since the app server can manage the connection.