I don't think that there will be, as a connection acts as a transaction (if
you don't use light weight databases). Thus creating ONE prepared statements
for different connections doesn't make sense.
Yours
Toyin
----- Original Message -----
From: "Tim Fox" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 1:29 PM
Subject: Kind of related to jsp but bit of topic - sorry!
> The question really revolves around use of database connection pools -
> the reason I'm posting here is coz it relates to our model 2 jsp
> application - so apologies if this is somewhat off topic.
>
> Various web-actions in our application require database connections
> which are checked out of a pool, the action is processed then they are
> checked in.
>
> For transactional reasons the same connection (or connections) is used
> throughout the web action for each of the possibly many db operations
> required.
>
> Now there are certain queries which are used time and time again so it
> would be nice to prepare them in advance (using preparedstatement),
> unfortunately preparedstatement only prepares the statement on a
> *particular* db connection, and, as I said before each request will
> essentially use its own connection.
>
> Is there any way around this or do I have to literally prepare every
> statement on every connection in the pool? This could turn into a bit of
> a nightmare.
>
> TIA
>
> --
> Tim Fox (��o)
>
> Senior developer
> Hyperlink plc
> http://hyperlink.com
>
> email: [EMAIL PROTECTED]
> phone: +44 (0) 207 240 8121
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
