Skip to main content

Change the development database type using the setdbtype command

By using setdbtype, we can switch the development database, To switch we have to follow the below steps


  • Stop the WebSphere Commerce Test Server.
  • Stop the WebSphere Commerce development database.

Run the below command based on the database


DB2:

setdbtype db2 DB2_HOME dbName dbAdminID dbAdminPassword dbUserIDdbUserPassword [dbHost dbServerPort dbNode] [createdb]

Oracle :

setdbtype oracle ORACLE_HOME dbName dbAdminID dbAdminPassword dbUserIDdbUserPassword [dbHost dbServerPort] [createdb]

Derby/Cloudscape:

setdbtype cloudscape [createdb]


Where:

DB2_HOME
The root directory of DB2. For example, C:\IBM\SQLLIB

ORACLE_HOME
The root directory of the Oracle DBMS. For example, C:\oracle\product\11.1.0\client_1

dbName
The name of the database. For example, mall.

dbAdminID
The database administrator's ID. For example, db2admin or oracle.

dbAdminPassword
The associated password for dbAdminID

dbUserID
The database user ID that connects to the database.

dbUserPassword
The associated password for dbUserID

dbHost
Optional: The host name of a remote database server.

dbServerPort
Optional: The port number of the remote database server.

dbNode
Optional: The node name of the remote database.

createdb
Optional: If specified, the command creates a new empty database.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to read applied promotions codes

The below snippet will give you to read the promotions codes which are applied to order number, String orderId = "978593958"; OrderKey orderKey = new OrderKey(new Long(orderId)); PromotionArgumentSessionBeanPersistenceManager promoManager = new PromotionArgumentSessionBeanPersistenceManager(); PromotionArgument promArg = promoManager.load(orderKey); Iterator prmoExeRecds = promArg.getPromotionExecutionRecords(); while(prmoExeRecds.hasNext()) { PromotionExecutionRecord promotionExeecutionRecord = (PromotionExecutionRecord) prmoExeRecds.next(); Promotion promotion = promotionExeecutionRecord.getPromotion(); System.out.println("Name: " + promotion.getName()); System.out.println("Admin description: " + promotion.getDescription(commandContext.getLocale(), com.ibm.commerce.marketing.promotion.Description.SHOPPER_SHORT_DESC)); }
Post a Comment
Read more

How to do Email Configurations in Web sphere Commerce

Web sphere commerce allows to send email messages to customers by making use of the below mentioned steps. Create the JSP which will be used for generating contents of the email  For e.g.: SendEmail.jsp Create View for the JSP in Struts-Config-Ext.xml Make an Entry in Struts-Config-Ext.xml file for .jsp as below < action path='/SendEmailView' type='com.ibm.commerce.struts.BaseAction'>     < set-property property ='authenticate' value ='10001:1'/>      < set-property property ='https' value ='10001:1'/> < /action> < forward name="SendEmailView /10001/-3" path="/< location of JSP file >/ TestEmail.jsp" className="com.ibm.commerce.struts.ECActionForward">     < set-property property="implClassName"     value="com.ibm.commerce.messaging.viewcommands.MessagingViewCommandImpl"/>     < set-property property="int
Post a Comment
Read more

IBM Announces version 9 of WebSphere Commerce!

What’s new in Version 9 includes information about new functionality and changes in existing functionality from previous WebSphere Commerce Version to the modernized WebSphere Commerce Version 9 release: Micro services architecture , with lightweight, self-contained, distributed servers, supports horizontal scaling, parallel development, and utilization of modern, open source tools. Docker containers deliver key benefits for DevOps , including deployment automation, delivery acceleration, and application portability. Flexible deployment options for  Docker containers  gives IT organizations more infrastructure choices for e-commerce workloads, including all cloud options: private, public, or hybrid deployment. Evolution of the technology stacks  makes customization of the brand and business user experience more efficient and cost effective. Key changes include adoption of lightweight IBM WebSphere Liberty, replacement of Enterprise JavaBeans™ (EJBs) with Java™ Persistence API (J
Post a Comment
Read more