How do I turn on PreparedStatement pooling? Bernie
> -----Original Message----- > From: Sitowitz, Paul [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 19, 2005 4:40 PM > To: Jakarta Commons Users List > Subject: RE: [dbcp] question regarding connection pooling and > prepared statements > > > Bill, > > Prepared Statements are on a per-connection level. In fact, > if you turn > on DBCP PrepareStatement pooling, a separate PrepareStatement > pool will > be maintained for each Db connection. The PreparedStatement > therefore is > tightly coupled with the connection that created it. > > Paul > > -----Original Message----- > From: Hudson, Bill [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 19, 2005 3:34 PM > To: [email protected] > Subject: [dbcp] question regarding connection pooling and prepared > statements > > > Question: I am trying to determine if commons-dbcp provides this > functionality: Can a prepared statement be generated against a > connection obtained from the a connection pool, say "connection x". > Then can connection x be returned to the pool, and at a later time can > the prepared statement be used with a different connection, say > "connection y", obtained from the same connection pool (both > connections > against same database, using the same driver). In other words, if I > maintain a reference to a prepared statement, will that reference be > valid regardless of what connection the underlying pool provides to me > over the course of my application's execution time? > > To phrase the question differently: are prepared statements on a > per-connection level, or are they "global" to all connections in the > connection pool? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
