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 01:15:42 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

The comment on the change is:
It's not finished... Later it'll be more a step-by-step with comments

------------------------------------------------------------------------------
- IN Progress
  
+ This Tutorial purpose is to provide a simple "how to" and give a step-by-step to build a
simple aplication using DAS/SDO features from Tuscany project. Here you'll build our "CompanyWeb
Sample Web Application". This sample uses Mysql and Tomcat.
+ 
+ 
+ A. Initial Setup:
+ 	1- Install Tomcat{latest version} and Mysql{latest version}.
+ 	2- Download dependencies and libraries
+ 	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
+ 	5- The required libraries are:
+ 		   i) common-{latest version}.jar
+ 		  ii) ecore-{latest version}.jar
+ 		 iii) ecore-change-{latest version}.jar
+ 		  iv) ecore-xmi-{lateste version}.ar
+ 		   v) log4j-{latest version}.jar
+ 		  vi) sdo-api-xxx.jar
+ 		 vii) tuscany-das-rdb-xxx.jar
+ 		viii) tuscany-sdo-xxx.jar
+ 		  ix) xsd-{latest version}.jar
+ 		   x) mysql-connector-java-{latest version}.jar
+ 
+ 
+ B. Creating CompanyWeb Database
+ 	1- Run the following commands in the Mysql Command Shell
+ 		create database companyweb; // Creates the CompanyWeb database
+ 		use companyweb; // Set the shell to work with companyweb database
+ 	2- Create a companydatabase.sql and inser
+ 		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
+ 	2- Edit it and write the following code:
+ 
+ <?xml version="1.0" encoding="ASCII"?>
+ <Config xsi:noNamespaceSchemaLocation="http:///org.apache.tuscany.das.rdb/config.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+     
+     <Command name="all companies" SQL="select * from COMPANY" kind="Select"/>
+     
+     <Command name="all companies and departments" SQL="select * from COMPANY left outer
join DEPARTMENT on COMPANY.ID = DEPARTMENT.COMPANYID" kind="Select"/>
+ 
+     <Command name="all departments for company" SQL="select * from COMPANY inner join
DEPARTMENT on COMPANY.ID = DEPARTMENT.COMPANYID where COMPANY.ID = ?" kind="Select"/>
+ 
+     <Command name="company by id with departments" SQL="select * from COMPANY left outer
join DEPARTMENT on COMPANY.ID = DEPARTMENT.COMPANYID where COMPANY.ID = ?" kind="Select"/>
+ 	
+  
+     <Table tableName="COMPANY">
+         <Column columnName="ID" primaryKey="true" generated="true"/>
+     </Table>
+     
+ 	<Table tableName="DEPARTMENT">
+ 		<Column columnName="ID" primaryKey="true" generated="true"/>
+ 	</Table>
+ 	
+ 	<Relationship name="departments" primaryKeyTable="COMPANY" foreignKeyTable="DEPARTMENT"
many="true">
+       <KeyPair primaryKeyColumn="ID" foreignKeyColumn="COMPANYID"/>
+     </Relationship>
+ 	
+ 	
+ </Config>
+ 
+ 	3- Save the file.
+ D. Creating the class wich manages the DAS/SDO features
+ 	1- Create the file CompanyCLient.java in the directory {Tomcat root}/webapps/companyweb/WEB-INF/classes/org/apache/tuscany/samples/das/companyweb
+ 	2- Write the following code in the file : 
+ --HOW to make the jsp.
+ http://people.apache.org/~kelvingoodson/das_java/RC4b/
+ 

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@ws.apache.org
For additional commands, e-mail: general-help@ws.apache.org


Mime
View raw message