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

[Adrian Brock]

Adrian Brock [http://community.jboss.org/people/adrian%40jboss.org] replied to the discussion

"How to define a read-only connection ?"

To view the discussion, visit: http://community.jboss.org/message/533048#533048

--------------------------------------------------------------
> Roberto Mazzola wrote:
> 
> I try it but it doesn't works.
> 
> I change my DS to
> 
> <connection-property name="readOnly" type="java.lang.Boolean">true</connection-property>
> 
> 
> It reply always "false".
> 
> I try different way.. also using java standalone class but the only  way is to invoke directly the setReadOnly method on the connection
> 
> I opened also a post of IBM DB2 Forum....
> 
> I hope to find a solution...
> 
> ty
Actually that won't work.

I checked the dtd and there is no type="" attribute for ConnectionPropertys in -ds.xml,
only for ConfigPropertys in ra.xml

You might want to raise a feature request for it in JIRA?

If you can make your datasource XA, then you will be able to use
<xa-datasource-property name="readOnly">true</xa-datasource-property>
and it will work out the type from the setReadOnly(boolean) method.

For local datasources we don't know the types since we use
java.sql.Driver.connect(String, Properties);
and like I said above, there is no way to specify it.

--------------------------------------------------------------

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

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/20100319/a251e2f6/attachment.html