[jboss-user] [Datasource Configuration] - one data source with multiple Oracle database users

[Nicolas Kaczmarski]

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&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101025/97db5666/attachment.html