Hi all,
we got a config error mesg in WAS61 console saying that there is a duplicate name 'URL' exists in resources.xml file at particular location of appl. server in config dir.
From our observation we found there are 5 properties with name as URL as mentioned below.
1. <resourceProperties xmi:id="J2EEResourceProperty_1248106890890" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@//remote_ip:port/db" required="false" /> under <propertySet xmi:id="J2EEResourcePropertySet_1248106068839">
2. <resourceProperties xmi:id="J2EEResourceProperty_1248106941125" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@//remote_ip:port/db" required="false" /> under <propertySet xmi:id="J2EEResourcePropertySet_1248106400744">
3. <resourceProperties xmi:id="J2EEResourceProperty_1248105272599" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@//remote_ip:port/db" description="This is a required property. The URL indicating the database from which the Data Source will obtain connections, such as '
jdbc:oracle:thin:@localhost:1521:sample' for thin driver and 'jdbc:oracle:oci8:@sample' for thick driver." required="true" /> under
<propertySet xmi:id="J2EEResourcePropertySet_1248105272586">
4. <resourceProperties xmi:id="J2EEResourceProperty_1248106826194" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@//remote_ip:port/db" required="false" /> under <propertySet xmi:id="J2EEResourcePropertySet_1248105272586">
5. <resourceProperties xmi:id="J2EEResourceProperty_1248105688438" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@//remote_ip:port/db" description="This is a required property. The URL indicating the database from which the Data Source will obtain connections, such as 'jdbc:oracle:thin:@localhost:1521:sample' for thin driver and 'jdbc:oracle:oci8:@sample' for thick driver." required="true" /> under <propertySet xmi:id="J2EEResourcePropertySet_1248105688424">
If we can observe params 3 and 4 are both under <propertySet xmi:id="J2EEResourcePropertySet_1248105272586"> and values of remote_ip, port and db are same on all the 5.
Now our concern is
> which one we have to remove and how to select among them.
> What is the best way to remove.
> Is there any other file that needs to be changed.
> do we need stop/start server before or after the change.
Kindly help me in this regard.
Thanks
