Re: embeded tomcat and correct DataSource.

On Tue, 17 Nov 2020 at 18:15, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

>
> 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(at)gmail(dot)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.
>

Quarkus can be compiled to native ...
https://quarkus.io/guides/building-native-image

Dave Cramer
www.postgres.rocks