On Aug 16, 11:25 am, Bill Burton <[email protected]> wrote: > Hello, > > Have you tried configuring access to DBCP via JNDI? Think that should allow > you to configure DBCP the way you want in Tomcat and Sequel only needs the > JNDI connection. > > For JDBC in general, there are multiple connection pool implementations. > Apache DBCP is just one. c3po (http://sourceforge.net/projects/c3p0/) is > another. > > If connecting to an Oracle database, there's a connection pool > implementation that can be accessed within the JDBC driver by specifying a > different driver class. Newer versions of the Oracle driver have separated > this functionality out into their Universal Connection Pool (UCP) feature > which is a separately installable jar file. > > If there is some way of configuring a generic JDBC driver with custom > parameters within Sequel, it would be possible to support most any kind of > connection pool since they would support JDBC as an interface.
Note that that having a connection pool class internal to the connection object that Sequel uses is not wise. The connection object that Sequel uses should represent a single database connection. If it doesn't, all sorts of problems could occur. For example, Database#transaction would not function correctly unless the same database connection was used for all statements inside the transaction. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
