Hi,

I am just wondering if there are any implications of defining a datasource for use within Pentaho as a "no-tx-datasource" rather than a "local-tx-datasource"?

ie: Does Pentaho use JTA Transactions?

I found some posts regarding Hibernate, and that it needs to use JTA Transactions (local-tx-datasource), however, do datasources that use JPivot need this functionality?

I ask this because I have created my own EJB that interacts with a couple of datasources used in Pentaho, however, it doesn't like me having two different datasources (using JNDI) within the same class.

I looked around, and found that setting no-tx-datasource helps, although, just wondering if this will affect Pentaho operations at all?

Thanks
Antonio