How can i set multiple connection properties for an oracle xa datasource:
For a single properties, the following works, as described elsewhere here in forums:
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.ReadTimeout=5000</xa-datasource-property>
but setting multiple properties fails, tried the following:
A) (only last one seems to count here)
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.ReadTimeout=5000</xa-datasource-property>
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.J2EE13Compliant=true</xa-datasource-property>
B) fails: java.lang.NoSuchMethodException: oracle.jdbc.xa.client.OracleXADataSource.setOracle.jdbc.J2EE13Compliant(java.lang.String)
<xa-datasource-property name="ConnectionProperties"><![CDATA[
oracle.jdbc.ReadTimeout=5000
oracle.jdbc.J2EE13Compliant=true]]></xa-datasource-property>
C) fails: java.lang.NoSuchMethodException: oracle.jdbc.xa.client.OracleXADataSource.setOracle.jdbc.J2EE13Compliant(java.lang.String)
<xa-datasource-property name="ConnectionProperties">
oracle.jdbc.ReadTimeout=5000
oracle.jdbc.J2EE13Compliant=true</xa-datasource-property>
D) fails: java.lang.NumberFormatException: For input string: "5000;oracle.jdbc.J2EE13Compliant=true"
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.ReadTimeout=5000;oracle.jdbc.J2EE13Compliant=true</xa-datasource-property>
E) fails
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.ReadTimeout=5000\noracle.jdbc.J2EE13Compliant=true</xa-datasource-property>
How to do it?