I am using a Oracle database. I would like to know how I can setup connection pools and also setup data sources that use these connection.
I setup configuration in oracle-ds.xml, but I think that would just be data sources directly connecting to database and not through connection pool.
This is how my oracle-ds file looks, for e.g .
But this is, I think, is a data source configuration. How do I do connection pools and have data sources use that connection pool?
First answer is RTFM ;)
Second answer is that you configure the connection pool inside of the datasource. Look at the manual for how to specify connection pool options.