Asking for confirmation that, when using an embedded tomcat instance, I should use the PGConnectionPoolDataSource if I wish to use Apache connection pool mechanism.
Well I was just shooting for the shortest stack possible. This is a home-grown server doing a very specific task, very specific clients (science stuff, neither Sir Elton nor I understand) My current working version has me managing a bare socket with a Selector. But there are a couple of brittle parts there so a dear friend (still laughing up his sleeve I'm sure) suggested embedding tomcat to leverage their selector impl and http support. Tests using DriverManager are working, now I think my last hurdle to using a DataSource is a jOOQ/java date/time issue. I'm not at all sure I've wired the DataSource in correctly, but examples using embedded tomcat are rare as hen's teeth.