[jboss-user] [Datasource Configuration] - JBAS014803: Duplicate resource

[Eric Hills]

Eric Hills [https://community.jboss.org/people/onecoder] created the discussion

"JBAS014803: Duplicate resource"

To view the discussion, visit: https://community.jboss.org/message/821573#821573

--------------------------------------------------------------
I am converting from JBoss 5 to AS 7.1  we have multiple datasources that use the same pool but with a different user and JNDI name.  I get the duplicate error.  Does anyone know how to deploy.  I have included a segment of my standalone.xml.  If anyone has thoughts it would be very helpful.  I have not found anything in my search other than changing the pool-name.  Also I will need to have 6 total entries similar to this they may all use the same db instance but will have a different JNDI name and different users and passwords.

<datasource jndi-name="java:/jdbc/xyz-xxx-reports" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">     
    <connection-url>
     jdbc:oracle:thin:@server:1526:webuat
   </connection-url>     
   <driver>
    oracle
   </driver>
   <security>
    <user-name>report_user</user-name>
    <password></password>
   </security>
   <new-connection-sql>select * from dual</new-connection-sql>
   <validation>
    <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
    <background-validation>true</background-validation>
    <background-validation-millis>10000</background-validation-millis>
    </validation>
    <timeout>
    <allocation-retry>1</allocation-retry>
    </timeout> 
   </datasource>
    <datasource jndi-name="java:/jdbc/abc-analysis" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">           
       <connection-url>
        jdbc:oracle:thin:@server:1526:webdev
       </connection-url>
       <driver-class>
        oracle
       </driver-class>
       <security>
        <user-name>history_user</user-name>
        <password></password>
       </security>
       <new-connection-sql>select * from dual</new-connection-sql>
   <validation>
    <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
    <background-validation>true</background-validation>
    <background-validation-millis>10000</background-validation-millis>
    </validation>
    <timeout>
    <allocation-retry>1</allocation-retry>
    </timeout>      
    </datasource> 


actual boot log message:

10:05:51,760 ERROR [org.jboss.as.controller.management-operation] Operation ("add") failed - address: ([
    ("subsystem" => "datasources"),
    ("data-source" => "OracleDS")
]) - failure description: "JBAS014803: Duplicate resource [
    (\"subsystem\" => \"datasources\"),
    (\"data-source\" => \"OracleDS\")
]"
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/821573#821573]

Start a new discussion in Datasource Configuration at Community
[https://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/20130605/ee8d2801/attachment.html