Vicky Kak [http://community.jboss.org/people/vickyk] replied to the discussion "How to define a read-only connection ?" To view the discussion, visit: http://community.jboss.org/message/539661#539661 -------------------------------------------------------------- Can you make sure that com.ibm.db2.jcc.DB2XADataSource::setReadOnly()/getReadOnly() exists? The IBM docs shows that it exists but can you confirm if there are setter getter methods for it too ? http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.i... Also you could try setting this in xa-datasource/local-tx-datasource? <connection-property name="connectionProperties">readOnly=true</connection-property> Let us know if this works. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/539661#539661] Start a new discussion in JCA at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]