Nicolas Kaczmarski [http://community.jboss.org/people/pekka_x] created the discussion "one data source with multiple Oracle database users" To view the discussion, visit: http://community.jboss.org/message/568176#568176 -------------------------------------------------------------- Dear All, I have 2 application using 2 differents datasources : <?xml version="1.0" encoding="UTF-8"?> <datasources>   <local-tx-datasource>     <jndi-name>TooWsDataSource</jndi-name>     <connection-url>jdbc:oracle:thin:@172.25.225.40:1521:paid</connection-url>     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>     <user-name>Too</user-name>     <password>too</password>     <metadata>        <type-mapping>Oracle10g</type-mapping>     </metadata>   </local-tx-datasource>   <!-- New schema for EPT/WS  -->    <local-tx-datasource>     <jndi-name>TooWsDataSourcePt</jndi-name>     <connection-url>jdbc:oracle:thin:@172.25.225.40:1521:paid</connection-url>     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>     <user-name>Too2</user-name>     <password>too</password>     <metadata>        <type-mapping>Oracle10g</type-mapping>     </metadata>   </local-tx-datasource> </datasources> But when the second application do an sql request the user used is "Too" instead of "Too2". Have you ideas? -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/568176#568176] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]