Re: embeded tomcat and correct DataSource.

On 11/17/20 3:15 PM, Dave Cramer wrote:

I haven't setup an embedded tomcat in a while. I'd like to know the answer as well.

Any reason you aren't using something like quarkus ?

Dave Cramer

www.postgres.rocks

On Mon, 16 Nov 2020 at 12:05, Rob Sargent <robjsargent@gmail.com> wrote:

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.