In my current project, I am using iBatis with EJB3 (Application server is JBoss 4.2.3). There are 2 ways to configure iBatis for connection.
First: Create datasource in application server and use it from iBatis
Second: In SqlMapConfig.xml file, define the URL, ID and password and get connection.
I want to understand which approach I should use. What are the pros and cons of one over the other.
Will there be any impact on transaction propagation.
Please help with your valuable inputs.
Thanks in advance.
Rgds - Sidd