Hi! The following URL may help in case u r interested in implementing Connection Pooling.
http://www.webdevelopersjournal.com/columns/connection_pool.html Deepak Bajaj ----- Original Message ----- From: "David Mossakowski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 3:58 PM Subject: Re: Best practices > http://industry.java.sun.com/products/jdbc/drivers > > you can find drivers that implement connection pooling; Oracle type 4 > driver for example does > > d. > > KILINC ALKAN wrote: > > > Hi, > > > > Try to use ConnectionPooling. You can find free connection pool codes by > > searching internet. I suggest you to read "Java Servlet Programming" book > > from O'Reilly books. ISBN 1-56592-391-X > > > > If you want to use a result of a query for querying again, place that query > > as an inner query sentence behaving like a table name in the outer query. > > Don't use programming for such things. > > > > > > -----Original Message----- > > From: A mailing list for discussion about Sun Microsystem's Java Servlet API > > Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Manuel > > Valencia > > Sent: Tuesday, April 09, 2002 7:55 PM > > To: [EMAIL PROTECTED] > > Subject: Best practices > > > > > > Hi: > > > > When an application needs several querys (selects and updates), what's > > better, > > have only one Connection object, Statement, ResultSet, DataMetaData and pass > > through parameters to methods OR within each method have your Connection, > > Statement, ResultSet, and DataMetaData objects. > > > > One more question, if is necesary have a query into another query, what's > > better, use 2 set of objects (Connection, Statement, ResulSet, DataMetaData) > > OR > > to make one query and put the results into a Vector object then do the other > > query (use only a set of objects). > > > > In your experience people, what's better for both cases? > > > > ___________________________________________________________________________ > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > > of the message "signoff SERVLET-INTEREST". > > > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > > Resources: http://java.sun.com/products/servlet/external-resources.html > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > > > ___________________________________________________________________________ > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > > of the message "signoff SERVLET-INTEREST". > > > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > > Resources: http://java.sun.com/products/servlet/external-resources.html > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > > > > > > > > > > -- > David Mossakowski [EMAIL PROTECTED] > Instinet Corporation 212.310.7275 > > > > **************************************************************************** *** > <<Disclaimer>> > > This message is intended only for the use of the Addressee and > may contain information that is PRIVILEGED and/or > CONFIDENTIAL or both. > > This email is intended only for the personal and confidential use > of the recipient(s) named above. > > If the reader of this email is not an intended recipient, you have > received this email in error and any review, dissemination, > distribution or copying is strictly prohibited. > > If you have received this email in error, please notify the sender > immediately by return mail and permanently deleting the copy > you received. > > Thank you. > > **************************************************************************** *** > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
