To Change DB connection in Search -Solr ( WebSphere Commerce Feature Pack 7)- Toolkit

Search DB mapping- settings - You may get this error if FEP7 was installed on mall DB and later DB2 localdb was restored .

         

Error:

        

          Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Database 'c:\WCDE_E~1\db\mall' not found.DSRA0010E: SQL State = XJ004, Error Code = 40,000

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Solution:

Go to :

WAS Admin Console : Environment >Naming > Name Space Bindings

Select -> com.ibm.commerce.foundation.server.services.search.datasource

Change String value from

jdbc/WebSphere Commerce Cloudscape DataSource demo

To

jdbc/WebSphere Commerce DB2 DataSource demo

Restart Server