ws-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Ws Wiki] Update of "Tuscany/TuscanyJava/DAS Java Overview/RDBDAS HOWTO HelloDASApp" by willianmaja
Date Wed, 15 Nov 2006 21:47:35 GMT
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: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org


Mime
View raw message