Hello, I was reading a post from yesterday about having multiple connections to a servlet with one database connection. What is the best "professional" way to achieve this? If I am using a servlet over cgi in order to save the overhead of connecting to a database each time, and am creating the connection to the database in the init() will the servlet or tomcat automatically create a pool of connections if i am expecting multiple access to the servlet at once?
Also, I know this is OT, but has anyone had problems using functions other than next() with the Microsoft JDBC Driver for SQL Server 2000 from the MS website? It won't allow functionality for previous(), etc. Thanks, Fuz ___________________________________________________________________________ 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