the referenced jndi lookup in the webapp context is located in India and the DB is in Ithaca NY the Indian JNDI lookup is considerably slower than 'ordinary JDBC connection' from NY
With Warm Regards Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Date: Wed, 24 Sep 2008 18:56:53 +0530 > Subject: RE: Some Prilim questions > > Hi > > Ok, I have read the link provided > > This answers the 2nd Question > > What about the first Question ? > >> Which is faster JNDI Based Connection pool / ordinary JDBC based > >> connection / close ? > > > With regards > karthik > > -----Original Message----- > From: Martin Gainty [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2008 6:48 PM > To: users@tomcat.apache.org > Subject: RE: Some Prilim questions > > > read this > http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html > > Martin > ______________________________________________ > Disclaimer and confidentiality note > Everything in this e-mail and any attachments relates to the official > business of Sender. This transmission is of a confidential nature and Sender > does not endorse distribution to any party other than intended recipient. > Sender does not necessarily endorse content contained within this > transmission. > > > > From: [EMAIL PROTECTED] > > To: users@tomcat.apache.org > > Date: Wed, 24 Sep 2008 18:19:38 +0530 > > Subject: Some Prilim questions > > > > 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 > > > > > > _________________________________________________________________ > See how Windows Mobile brings your life together-at home, work, or on the go. > http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/ > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > _________________________________________________________________ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
