data-sources.xml - BaseResourceException - complaining about two-phase comm

61 Views

Hi,

I am seeing the following exception. Please let me know how to fix this.

thanks

Sunita

com.sap.engine.services.connector.exceptions.BaseResourceException: The resource "xxx" does not support two-phase commit and cannot be enlisted in the current transaction, because another non supporting two-phase commit resource is already enlisted for component "webContainer/applications/JavaEE/YY-TPRO/YYr-TPRO" in application "JavaEE/YY-TPRO". Only one of the enlisted resources is allowed to be non two-phase commit compliant.

I am using JDBC 1.x datasource, and the .xml looks like this:

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE data-sources SYSTEM 'data-sources.dtd'>

<data-sources>

<application-name>JavaEE/yy-TPRO</application-name>

<data-source>

<data-source-name>xxx</data-source-name>

<alias>jdbc/xxyyDB/TPRO</alias>

<driver-name>OracleThin</driver-name>

<init-connections>1</init-connections>

<max-connections>20</max-connections>

<max-time-to-wait-connection>60</max-time-to-wait-connection>

<sql-engine>vendor_sql</sql-engine>

<jdbc-1.x>

<driver-class-name>oracle.jdbc.driver.OracleDriver</driver-class-name>

<url>jdbc:oracle:thin:@sol-mercury:1521:hermes</url>

<user-name>abcd</user-name>

</jdbc-1.x>

</data-source>

</data-sources>