[DWS-2] Establish Enunciate build framework, and deploy to Jetty

[dynamobi-build]

[reporter="ngoodman", created="Fri, 16 Oct 2009 17:18:01 -0700", resolved="Tue, 23 Feb 2010 19:24:17 -0800"]

[dynamobi-build]

[author="ngoodman", created="Thu, 7 Jan 2010 17:28:23 -0800"]

First step, is to make a build.xml that enunciates a simple web service.

Initially, please just do some prototyping and testing:

Build two web services:
1- List of Tables (table name, schema, catalog)
2- Columns of Table (column name)

Service 1 just lists all tables
select table_name, schema_name from sys_root.dba_tables;
Service 2 takes a table/schema name as an input parameter
select column_name from sys_root.dba_columns where table_name = ?

Build SOAP/REST services in deployed .war file.

[dynamobi-build]

[author="ngoodman", created="Thu, 7 Jan 2010 17:28:56 -0800"]

Please start a simple prototype of these two web services using Enunciate.

[dynamobi-build]

[author="rzhang", created="Wed, 13 Jan 2010 09:29:43 -0800"]

Currently I implemented service1. Later I will add service2.

Code was checked-in under https://studio.dynamobi.com/svn/DWS/dynamows-admin
jar files were not checked-in as commit failed.
In fact, jar files include eunicate.home\lib*.jar and lucidDb jdbc driver class ie., lucidDb.home(0.92)\plugin\LucidDbClient.

Please see the attachment, which presents a demo.

[dynamobi-build]

[author="rzhang", created="Wed, 13 Jan 2010 09:32:25 -0800"]

Here is a demo for service1
Here is an agenda

1. build ok
1. deploy it into jetty-6.1.7 ok
2. Start a server side of lucidDB ok
3. launch Jetty ok
4. check the result

api http://127.0.0.1:8080/dynamobi/
service1 http://127.0.0.1:8080/dynamobi/rest/TableService

[dynamobi-build]

[author="rzhang", created="Fri, 15 Jan 2010 06:23:04 -0800"]

demo for serivce 1 and servce2
json is available

[dynamobi-build]

[author="ngoodman", created="Wed, 20 Jan 2010 16:52:19 -0800"]

Please do:

• please remove Maven building and use Ant
• Continue to work on SOAP generation
• change .properties from a relative path to a resource path, and put this in the generated .war WEB-INF/classes
• please separate our lib/ from enunciate required lib/ (include and deploy both into .war) but it is confusing to intermingle. At the end, we will have two /lib/ dirs (name them whatever you want).
• Rename Table/Column and drop "Entity" from them
• Add a /TableService/ that does not require an ID, that lists all tables in all schemas
• Demonstrate a small visual change to the HTML layout (change color somewhere)

Some of the above tasks you may have already done - I checked out version 45 so I could run Ant.

[dynamobi-build]

[author="rzhang", created="Thu, 21 Jan 2010 04:05:38 -0800"]

Please check out the code from this link below
https://studio.dynamobi.com/svn/DWS/branch/dynamows-admin

Please explain more detail for this requirement.
Demonstrate a small visual change to the HTML layout (change color somewhere)

[dynamobi-build]

[author="ngoodman", created="Thu, 21 Jan 2010 16:31:39 -0800"]

I'm not sure why we need to branch to the other location. We will not be using Maven, so there is no reason to keep two branches (one w/ Maven and the other with Ant).

That being said, I'm not opposed to branching when we get into situations where we need to split up development.

Please consolidate the SVN repository to be:

/DWS/dynamows-admin
/DWS/dynamows-admin/trunk
/DWS/dynamows-admin/branches
/DWS/dynamows-admin/tags

and do all of our work in
/DWS/dynamows-admin/trunk

We don't need branches yet, I don't think!

Raydone.
Please check out the code from this link
https://studio.dynamobi.com/svn/DWS/dynamows-admin/trunk version 76
It works well.

[dynamobi-build]

[author="ngoodman", created="Thu, 21 Jan 2010 16:35:14 -0800"]

re: change .properties from a relative path to a resource path, and put this in the generated .war WEB-INF/classes

The jdbc.properties is not being put into the .war file.

Example:
nicholas-goodmans-macbook-pro:dynamows-admin ngoodman$ ant
...

BUILD SUCCESSFUL
Total time: 12 seconds
nicholas-goodmans-macbook-pro:dynamows-admin ngoodman$ unzip -l target/dynamobi.war | egrep 'jdbc.properties'
nicholas-goodmans-macbook-pro:dynamows-admin ngoodman$ svn update
At revision 60.

Ray: you can check out version 76.
I have put jdbc.properties in WEB_INF/classes/ thru adding config in enunciate.xml

[dynamobi-build]

[author="ngoodman", created="Thu, 21 Jan 2010 16:36:45 -0800"]

re: Demonstrate a small visual change to the HTML layout (change color somewhere)

I was referring to making some template changes of the docs (colors, or font or something)
http://enunciate.codehaus.org/module_docs.html

[dynamobi-build]

[author="ngoodman", created="Tue, 26 Jan 2010 18:56:38 -0800"]

Link to email posted by rzhang, response from Ryan Heaton.

Please use his suggestion to resolve the SOAP issue, ASAP

http://markmail.org/message/chqptcytqyk7b4zi#query:enunciate%20dev%20order%3Adate-backward+page:1+mid:4h5mks5gmdts7nzd+state:results

[dynamobi-build]

[author="rzhang", created="Wed, 27 Jan 2010 04:56:48 -0800"]

Now the soap service are working...
The root cause is about mismatched jars.
I copy the jars for JAX-WS into our lib/.

[dynamobi-build]

[author="ngoodman", created="Tue, 23 Feb 2010 19:24:17 -0800"]

We've got this working... it works in Jetty. We need to get the .war to deploy in OSGi DBUILD-6 but this is definitely working.