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

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