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 ------------------------------------------------------------------------------ 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 @@ -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 = 1- Run the following commands in the Mysql Command Shell - create database companyweb; // Creates 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 companydatabase.sql and inser + 2- Create a text file and name it as "comapnyweb.sql", you should insert the following lines in this file; + || CREATE TABLE EMPLOYEE ( || + ID INTEGER NOT NULL AUTO_INCREMENT, + NAME VARCHAR(30), + SN VARCHAR(10), + MANAGER SMALLINT, + DEPARTMENTID INTEGER, + PRIMARY KEY (ID) + ); + + CREATE TABLE DEPARTMENT ( + ID INTEGER NOT NULL AUTO_INCREMENT, + NAME VARCHAR(30), + LOCATION VARCHAR(30), + NUMBER VARCHAR(10), + COMPANYID INTEGER, + EOTM INTEGER, + PRIMARY KEY (ID) + ); + + CREATE TABLE COMPANY ( + ID INTEGER NOT NULL AUTO_INCREMENT, + NAME VARCHAR(30), + PRIMARY KEY (ID) + ); + CREATE UNIQUE INDEX SQL060217085530980 ON COMPANY (ID ASC); + + CREATE UNIQUE INDEX SQL060217085531710 ON DEPARTMENT (ID ASC); + + INSERT INTO COMPANY VALUES (51, "ACME Publishing"); + INSERT INTO COMPANY VALUES (52, "Do-rite plumbing"); + INSERT INTO COMPANY VALUES (53, "MegaCorp"); - 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]
