Hi,
May I know when setting up an alternate connection pool for the TimerPool, what Resource Type should I use? The default __TimerPool connection pool is of type "XADataSource" while at the application level, I have been creating my DB connection pool as "DataSource".
A brief search on the web turned up this: "You need an XADataSource if you want to execute a Distributed Transaction. You need a Distributed Transaction if you have a transaction with 2 or more different (not equal) DataSources."
http://www.inetsoftware.de/products/jdbc/mssql/configuration/XADataSource.htm
It doesn't LOOK like the TimerPool would span multiple data sources, so can I go ahead and create it as a normal "DataSource" connection pool?
Thanks,
Wong
[Message sent by forum member 'lilwong' (lilwong)]
http://forums.java.net/jive/thread.jspa?messageID=253121