I have a translation thread that chooses routes based on trxids. Each route detail specifies an outbound destination implemented with the database-outbound protocol. We’ve defined several of these database-outbound protocol threads, one for each table, but all sharing the same connection properties. I still have the following questions after browsing the Database-Outbound documentation page.
1. If all outbound-database protocol threads share the same process, will they also share the same connection? Or does each thread maintain its own connection via a connection life cycle specified by the connection options on the protocol property panel?
2. Is connection pooling performed? If so, where can we configure this?