Manually update Datasource in Websphere Application Server(4 of 285 technotes for 2015)

• Open “Resources.xml” file (see below for the locations)
  
• Search for “resources.jdbc:DataSource” and 
  
• Update the “resourceProperties”
  

Standalone Server

<was_install>profiles<profile_name>configcells<cell_name>resources.xml

eg:

C:IBMWebSphereAppServerprofilesAppSrv01configcellsWIN-MKSD266W0DXNode01Cellresources.xml

or 

<was_install>profiles<profilename>configcells<cell_name>nodes<node_name>serversserver1resources.xml

eg:

C:IBMWebSphereAppServerprofilesWSRRSrv12configcellswsrr12Node01Cellnodeswsrr12Node01serversserver1resources.xml

Cluster

<was_install>profiles<dmgr_name>configcells<cell_name>clusters<cluster_member>resources.xml”

eg:

“C:IBMWebSphereAppServerprofilesDmgr1configcellsdmgr1Cell01clustersesb_env2.AppTargetresources.xml”

And

<was_install>profiles<dmgr_name>configcells<cell_name>resources.xml

eg:

C:IBMWebSphereAppServerprofilesDmgr1configcellsdmgr1Cell01resources.xml