For users of Oracle SOA Suite 11g/12c, this blog will attempt to answer whether you should configure your connection pool settings at the adapter level or at the data source level.
Data Source Settings
On Oracle WebLogic Server 11g/12c, navigate to Data Sources > SOADataSource > Configuration > General.
Here, you can obtain the JNDI, such as jdbc/SOADataSource. This JNDI is generally handed to your developers so that they can use it from within their Java code. Keep in mind that this JNDI is also used by the DbAdapter (explained later).
Now click on the Connection Pool tab. Here, you can see the various settings of the connection pool such as the initial and maximum number of connections which you can adjust as necessary. Read the complete article here.
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.