How does JDBC pool treat libraries?

[Gazzille]

Hi there,

in last of my several Payara installation I found a little obstacle in JDBC connection pool configuration. I have an enterprise application in a ear package with all needed libraries inside and in app resource I defined a Postgres JDBC connection pool.

Contrary to what I expected, the pool did not working and I received error because Payara did not recognize Posegres JDBC library.

After that I put library in lib folder of Payara domain and the pool has start working without error.

I am using Payara 173.

The question is: is this the correct behavior or is it a bug?

Very kind regards.

Alessio

[Fabio Turizo]

That is the correct behaviour. JDBC connection pools are server resources, which means that in order for the server several containers to interact with these JDBC connection pools, it needs to have access to the database drivers in its classpath. 

[Gazzille]

Hi Fabio,

thank you very much for your time.

So, this means that to include database libraries in an ear is a nonsense?

Bye.

Gaz