Dear Wiki user, You have subscribed to a wiki page or wiki category on "Ws Wiki" for change notification.
The following page has been changed by willianmaja: http://wiki.apache.org/ws/Tuscany/TuscanyJava/DAS_Java_Overview/RDBDAS_HOWTO_HelloDASApp ------------------------------------------------------------------------------ = A. Initial Setup: = - 1- Install Tomcat{latest version} and Mysql{latest version}. + '''1- Install Tomcat{latest version} and Mysql{latest version}.''' - 2- Download dependencies and libraries + '''2- Download dependencies and libraries''' - 3- Create companyweb directory in {Tomcat root}/webapps/. EX: {Tomcat root}/webapps/companyweb + '''3- Create companyweb directory in {Tomcat root}/webapps/. EX: {Tomcat root}/webapps/companyweb''' - 4- Create the directory {Tomcat root}/webapps/companyweb/WEB-INF/lib and put the libraries in it. Otherwise you can put them in {Tomcat root}/common/lib + '''4- Create the directory {Tomcat root}/webapps/companyweb/WEB-INF/lib and put the libraries in it. Otherwise you can put them in {Tomcat root}/common/lib''' - 5- The required libraries are: + '''5- The required libraries are:''' i) common-{latest version}.jar @@ -26, +26 @@ viii) tuscany-sdo-xxx.jarix) xsd-{latest version}.jar - x) mysql-connector-java-{latest version}.jar -> "This is the JDBC connector, It'll be used to connect to Mysql database." + x) mysql-connector-java-{latest version}.jar -> ''This is the JDBC connector, It'll be used to connect to Mysql database.'' = B. Creating CompanyWeb Database = + After the setting up your enviroment, the next step will be to create the databse where the DAS will connect and manage the transaction with the SDO features. + + - 1- Run the following commands in the Mysql Command Shell + '''1- Run the following commands in the Mysql Command Shell''' - create database companyweb; -> "This command will create the CompanyWeb database" + create database companyweb; -> ''This command will create the CompanyWeb database'' + - use companyweb; -> Set the shell to work with companyweb database + use companyweb; -> ''Set the shell to work with companyweb database'' - 2- Create a text file and name it as "comapnyweb.sql", you should insert the following lines in this file; + '''2- Create a text file and name it as "comapnyweb.sql", you should insert the following lines in this file:''' + - || CREATE TABLE EMPLOYEE ( + CREATE TABLE EMPLOYEE ( - || ID INTEGER NOT NULL AUTO_INCREMENT, |||| + ID INTEGER NOT NULL AUTO_INCREMENT, - NAME VARCHAR(30), + NAME VARCHAR(30), - SN VARCHAR(10), + SN VARCHAR(10), - MANAGER SMALLINT, + MANAGER SMALLINT, - DEPARTMENTID INTEGER, + DEPARTMENTID INTEGER, - PRIMARY KEY (ID) + PRIMARY KEY (ID) ); CREATE TABLE DEPARTMENT ( @@ -66, +71 @@ INSERT INTO COMPANY VALUES (51, "ACME Publishing"); INSERT INTO COMPANY VALUES (52, "Do-rite plumbing"); INSERT INTO COMPANY VALUES (53, "MegaCorp"); + + 3- Run the following command in the Mysql Shell - source {path}/companyweb.sql -> Executes the script to create tables, constraints, etc. + source {path}/companyweb.sql -> ''Executes the script to create tables, constraints, etc.'' = C. Creating XML configuration file = 1- Create the file CompanyConfig.xml in the directory {Tomcat root}/webapps/companyweb/WEB-INF/classes --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
