[jboss-user] [JCA] - How to define a read-only connection ?

[Vicky Kak]

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.ibm.db2.udb.doc/ad/rjvdsprp.htm

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

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