JBoss Community

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

created by Mateusz User in Datasource Configuration - View the full discussion

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

Start a new discussion in Datasource Configuration at Community