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

[Mateusz User]

Mateusz User [https://community.jboss.org/people/urbanq] created the discussion

"Re: Oracle XA ds, ojdbc 11.2.0.3.0, jboss-6.0.0.Final, multiple connection properties"

To view the discussion, visit: https://community.jboss.org/message/763405#763405

--------------------------------------------------------------
I have the same problem in jboss 5.1.0.GA.
Found that XADataSourceDeploymentMetaData is setting 'XADataSourceProperties' property with pattern:
name+ "=" + value+ "\n".
So if you define:
<xa-datasource-property name="ImplicitCachingEnabled">true</xa-datasource-property>
<xa-datasource-property name="MaxStatements">32</xa-datasource-property>
<xa-datasource-property name="ConnectionProperties">defaultRowPrefetch=100\noracle.jdbc.StreamBufferSize=30</xa-datasource-property>

it will set:  XADataSourceProperties="ImplicitCachingEnabled=true\nMaxStatements=32\nConnectionProperties=defaultRowPrefetch=100\noracle.jdbc.StreamBufferSize=30"
and setting properties on OracleXADS will be:
xds.setImplicitCachingEnabled(true);
xds.setMaxStatements(32);
xds.setConnectionProperties(java.util.Properties(defaultRowPrefetch=100));
*xds.setOracle.jdbc.StreamBufferSize(30); <- !! no such method exception!*

as we expect:
xds.setImplicitCachingEnabled(true);
xds.setMaxStatements(32);
xds.setConnectionProperties(java.util.Properties(defaultRowPrefetch=100,oracle.jdbc.StreamBufferSize=30));

I didn't found any workaroud for this problem.
OracleXADataSource API is broken and only way is to JBoss will take care of it  :)
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/763405#763405]

Start a new discussion in Datasource Configuration at Community
[https://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/20121005/f03a242e/attachment.html