I have configured the connection pool without statement pooling. On the WebSphere Application Server data source properties page, I have set the Statement cache size to 0 statements, which should turn off statement pooling. I also have checked “Non-transactional data source,” because our application manages the transaction state itself. It turns autocommit off when it wants to start a transaction, and commits the transaction itself.
The first warning makes sense because the Microsoft data source does not support statement pooling, and does not support a statement event listener. My question is why does this warning appear if we have not configured statement pooling?
The second warning complains that the “data source custom property commitOrRollbackOnCleanup is not configured.” I have searched the known universe for any documentation about this configuration property, and could not find a mention of it, so I don’t know what I am supposed to do.