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

[Juergen H]

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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20111130/f891fadb/attachment.html