You can prepare ur statement in Init method of the servlet and execute it doGet method.
If u r using connection pooling create ur pool in init method of the servlet.
At 12:22 PM 06/23/2000 -0700, you wrote:
>One of the points, I thought, of PreparedStatement was that you prepared it
>ONCE and executed it many times. How can one achieve this in a servlet that
>uses connection pooling? Is there a way to prepare statements ahead of time,
>so that when doGet is called, you only need to execute the sql?
>
>Dave Ford
>
>___________________________________________________________________________
>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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rajesh Basawa
Professional Services, Cisco Systems, Inc.
Voice: 408-853 9557
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
___________________________________________________________________________
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
