About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
How to setup a database client for Cloudscape?development?database using Rational Application Developer *|* -52D322841CBF9DAB8525793D004FBD61- *|*
Answer
Technote (troubleshooting)
Problem(Abstract)
When using WebSphere CommerceDeveloper with a Cloudscapedevelopmentdatabase you would like to set up a database client using Rational Application Developer.
Resolving the problem
Follow the steps to set up the database client using the Rational Application Developer:
- Open Rational Application Developer toolkit environment where commerce is installed
- Click Windows then select Open perspectives. In "Other..." click Database Development
- Click Windows then select "Show View" and open "Data Source Explorer"
- Under Data Source Explorer right click Database connections and click New
In Select a database manager select Derby. For the JDBC driver select Birt Sampledb Derby Embedded Driver. For database location enter the location of the Cloudscape database. For example D:\IBM\WCDE_INT70\db\mall. - Click Finish. You should now be able to explore the commerce database when using the Database Development prospective:
Note: To connect to this database you must stop the WebSphere Commerce Server. Only one connection is allowed to CloudscapedevelopmentDerby database.
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
Sterling Total Payments for Financial Services
Software version:
All Versions
Document number:
766443
Modified date:
12 October 2021
UID
ibm10766443
Manage My Notification Subscriptions