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&...]