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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
