[jboss-user] [Datasource Configuration] - Oracle XA ds, ojdbc 11.2.0.3.0, jboss-6.0.0.Final, multiple connection properties

Juergen H [http://community.jboss.org/people/work_registries] created the discussion "Oracle XA ds, ojdbc 11.2.0.3.0, jboss-6.0.0.Final, multiple connection properties" To view the discussion, visit: http://community.jboss.org/message/639185#639185 -------------------------------------------------------------- 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? -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/639185#639185] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]