Database connection pooling

Web services are highly available and therefore can cause problems for any databases they need to connect to if they are forced to open a new connection every time they need to interrogate them. A way around this is to use a connection pool.

At present Talend only supports connection pooling using a JDBC connection. Therefore it is considered best practice to make use of the JDBC database components when working with databases via services.