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:57:45 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

------------------------------------------------------------------------------
  
  
  = 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: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org


Mime
View raw message