Hi Spec: O/s : Unix HP 11i Tomcat : 6.0.18 J2sdk : 1.6 DB : Oracle 10g
Question 1) Which is faster JNDI Based Connection pool / ordinary JDBC based connection / close ? 2) In JNDI / context based Connection pool for the code given below InitialContext ic = new InitialContext(); DataSource ODS =(javax.sql.DataSource)ic.lookup("java:comp/env/jdbc/MYSCEMA"); Connection conn = ODS.getConnection() // Insert /Update /Delete/... conn.close() --> What does this code do ? (return connection to pool or close the connection ) Googled /yahooed but non correct answers .... Please advice Karthik