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 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

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

Dataload Utility

Data can be loaded into WCS tables using data load utility. WCS Data Load utility performs the following functions in a single operation: 1.                Reads the data from the input source file. 2.                Transforms the source data to Web Sphere Commerce business objects. 3.                Allocates and resolves Web Sphere Commerce business objects to physical data. 4.                Loads the physical data into the database. There are three configurations files and a input source file required to complete the data loader setup. WCS supports only CSV File Reader for other input source you have to write your own Reader Class. This means that if you are using OOB CSV Reader then your input file must be...
Post a Comment
Read more