[jboss-user] [IronJacamar] - Re: Test connection through CLI when <allow-multiple-users/> is applied to a datasource
anuragdebnath
do-not-reply at jboss.com
Wed Feb 27 10:32:18 EST 2013
anuragdebnath [https://community.jboss.org/people/anuragdebnath] created the discussion
"Re: Test connection through CLI when <allow-multiple-users/> is applied to a datasource"
To view the discussion, visit: https://community.jboss.org/message/799906#799906
--------------------------------------------------------------
>> First of all - don't create JIRAs before we have come to a conclusion on the possible feature. - See more at: https://community.jboss.org/message/799896#799896#799896 https://community.jboss.org/message/799896#799896
I will make a Note of it from next time onwards. Thanks.
>> Second - you havn't posted your configuration of the datasource. The test-connection-in-pool will use the default credentials specified, so why isn't that working ?
Here is the datasource snippet with <allow-multiple-users/> applied -
<xa-datasource jndi-name="java:/etsDataSourcexa" pool-name="OracleXA_DS" enabled="true">
<xa-datasource-property name="URL">
XXXX
</xa-datasource-property>
<driver>ojdbc6.jar</driver>
<new-connection-sql>select 1 from dual</new-connection-sql>
<xa-pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>100</max-pool-size>
<allow-multiple-users/>
</xa-pool>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<background-validation-millis>30000000</background-validation-millis>
<stale-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.OracleStaleConnectionChecker"/>
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
</validation>
<statement>
<prepared-statement-cache-size>25</prepared-statement-cache-size>
</statement>
</xa-datasource>
<driver name="ojdbc6.jar" module="com.oracle">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/799906#799906]
Start a new discussion in IronJacamar at Community
[https://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/20130227/b3d60d51/attachment.html
More information about the jboss-user
mailing list