[jboss-user] [IronJacamar] - Re: Test connection through CLI when <allow-multiple-users/> is applied to a datasource

[anuragdebnath]

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/800024#800024

--------------------------------------------------------------
Hi Jesper,

I did try with the <security> element but that does not helps.

The <user-name> and <password> that we provide in the <security> element is the default DB credentials to acess the database.
The point  is, if I have "<allow-multiple-users/>" the same credentials cannot be used by/for different users. 

Here is the new updated datasource config - 

<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>
                    <security>
                        <user-name>jboss</user-name>
                        <password>jboss</password>
                    </security>
                    <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/800024#800024]

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/20130228/19b27ddc/attachment.html