diff options
Diffstat (limited to 'sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb')
86 files changed, 986 insertions, 0 deletions
diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/CompanyAppGbl.xml b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/CompanyAppGbl.xml new file mode 100644 index 0000000000..45d34aaac9 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/CompanyAppGbl.xml @@ -0,0 +1,11 @@ + +<!-- CONTEXT added per Global JNDI doc - link App to Global context above --> + <Context path="/CompanyApp" + debug="5" reloadable="true" crossContext="true"> + <!-- Disable Manager session persistance - causes failures w/iBATIS --> + <Manager pathname=""/> + <ResourceLink name="jdbc/dastest" + global="jdbc/dastest" + type="javax.sql.DataSource" /> + + </Context>
\ No newline at end of file diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/db.lck b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/db.lck Binary files differnew file mode 100644 index 0000000000..9f6b4b3d4b --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/db.lck diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log.ctrl b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log.ctrl Binary files differnew file mode 100644 index 0000000000..edbd775299 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log.ctrl diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log1.dat Binary files differnew file mode 100644 index 0000000000..7e85ac8e8f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/log1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/logmirror.ctrl b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/logmirror.ctrl Binary files differnew file mode 100644 index 0000000000..edbd775299 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/log/logmirror.ctrl diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c10.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c10.dat Binary files differnew file mode 100644 index 0000000000..5d8ecaa10f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c10.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c101.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c101.dat Binary files differnew file mode 100644 index 0000000000..0f79fa7574 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c101.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c111.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c111.dat Binary files differnew file mode 100644 index 0000000000..39d49e3d19 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c111.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c121.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c121.dat Binary files differnew file mode 100644 index 0000000000..2a4311779b --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c121.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c130.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c130.dat Binary files differnew file mode 100644 index 0000000000..64e3c18d62 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c130.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c141.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c141.dat Binary files differnew file mode 100644 index 0000000000..0632d04164 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c141.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c150.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c150.dat Binary files differnew file mode 100644 index 0000000000..d7541026f6 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c150.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c161.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c161.dat Binary files differnew file mode 100644 index 0000000000..6673bf1873 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c161.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c171.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c171.dat Binary files differnew file mode 100644 index 0000000000..c2a753cc5d --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c171.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c180.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c180.dat Binary files differnew file mode 100644 index 0000000000..cb9391aed1 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c180.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c191.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c191.dat Binary files differnew file mode 100644 index 0000000000..d3cf1d6364 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c191.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1a1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1a1.dat Binary files differnew file mode 100644 index 0000000000..a7a2d536e9 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1a1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1b1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1b1.dat Binary files differnew file mode 100644 index 0000000000..19097e69e7 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1b1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1c0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1c0.dat Binary files differnew file mode 100644 index 0000000000..359525a31a --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1c0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1d1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1d1.dat Binary files differnew file mode 100644 index 0000000000..9f257df932 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1d1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1e0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1e0.dat Binary files differnew file mode 100644 index 0000000000..e43e52fb7f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1e0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1f1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1f1.dat Binary files differnew file mode 100644 index 0000000000..7e6ee3b1e0 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c1f1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c20.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c20.dat Binary files differnew file mode 100644 index 0000000000..1be6390f06 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c20.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c200.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c200.dat Binary files differnew file mode 100644 index 0000000000..b15d56855c --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c200.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c211.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c211.dat Binary files differnew file mode 100644 index 0000000000..84b0022312 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c211.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c221.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c221.dat Binary files differnew file mode 100644 index 0000000000..63106a9523 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c221.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c230.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c230.dat Binary files differnew file mode 100644 index 0000000000..9975f27c1f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c230.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c241.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c241.dat Binary files differnew file mode 100644 index 0000000000..835c645a16 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c241.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c251.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c251.dat Binary files differnew file mode 100644 index 0000000000..d3d6adf4fb --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c251.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c260.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c260.dat Binary files differnew file mode 100644 index 0000000000..8d7333df7d --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c260.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c271.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c271.dat Binary files differnew file mode 100644 index 0000000000..af722f7d73 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c271.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c281.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c281.dat Binary files differnew file mode 100644 index 0000000000..3972983c2e --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c281.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c290.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c290.dat Binary files differnew file mode 100644 index 0000000000..31577b8124 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c290.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2a1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2a1.dat Binary files differnew file mode 100644 index 0000000000..0f700d13a7 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2a1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2b1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2b1.dat Binary files differnew file mode 100644 index 0000000000..1d6382fb3d --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2b1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2c1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2c1.dat Binary files differnew file mode 100644 index 0000000000..3bc60d886b --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2c1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2d0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2d0.dat Binary files differnew file mode 100644 index 0000000000..c542d3c91c --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2d0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2e1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2e1.dat Binary files differnew file mode 100644 index 0000000000..16abd20b5f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2e1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2f0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2f0.dat Binary files differnew file mode 100644 index 0000000000..eb26be5932 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c2f0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c300.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c300.dat Binary files differnew file mode 100644 index 0000000000..1214f1df4b --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c300.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c31.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c31.dat Binary files differnew file mode 100644 index 0000000000..18c16f1123 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c31.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c311.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c311.dat Binary files differnew file mode 100644 index 0000000000..926cbf25b5 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c311.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c320.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c320.dat Binary files differnew file mode 100644 index 0000000000..07e7bc023c --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c320.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c331.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c331.dat Binary files differnew file mode 100644 index 0000000000..fd827f9dc2 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c331.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c340.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c340.dat Binary files differnew file mode 100644 index 0000000000..ca70319886 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c340.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c351.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c351.dat Binary files differnew file mode 100644 index 0000000000..8fbe2a527c --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c351.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c360.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c360.dat Binary files differnew file mode 100644 index 0000000000..dcf9c746e1 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c360.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c371.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c371.dat Binary files differnew file mode 100644 index 0000000000..6f21a840ea --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c371.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c380.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c380.dat Binary files differnew file mode 100644 index 0000000000..b512e8065f --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c380.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c391.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c391.dat Binary files differnew file mode 100644 index 0000000000..27006e95a1 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c391.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3a0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3a0.dat Binary files differnew file mode 100644 index 0000000000..565dca97ac --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3a0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3b1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3b1.dat Binary files differnew file mode 100644 index 0000000000..36894c9818 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3b1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3c0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3c0.dat Binary files differnew file mode 100644 index 0000000000..d0c538aede --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3c0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3d1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3d1.dat Binary files differnew file mode 100644 index 0000000000..65bcec5527 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3d1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3e0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3e0.dat Binary files differnew file mode 100644 index 0000000000..bdab359420 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3e0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3f1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3f1.dat Binary files differnew file mode 100644 index 0000000000..dc2d278b57 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c3f1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c400.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c400.dat Binary files differnew file mode 100644 index 0000000000..3072709cec --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c400.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c41.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c41.dat Binary files differnew file mode 100644 index 0000000000..61086690f2 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c41.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c411.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c411.dat Binary files differnew file mode 100644 index 0000000000..ca551d8249 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c411.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c420.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c420.dat Binary files differnew file mode 100644 index 0000000000..f04de0840e --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c420.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c431.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c431.dat Binary files differnew file mode 100644 index 0000000000..398b1672cc --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c431.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c440.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c440.dat Binary files differnew file mode 100644 index 0000000000..af259d0872 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c440.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c451.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c451.dat Binary files differnew file mode 100644 index 0000000000..772a18c658 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c451.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c460.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c460.dat Binary files differnew file mode 100644 index 0000000000..505428362d --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c460.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c471.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c471.dat Binary files differnew file mode 100644 index 0000000000..484d0df42d --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c471.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c481.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c481.dat Binary files differnew file mode 100644 index 0000000000..faac073076 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c481.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c490.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c490.dat Binary files differnew file mode 100644 index 0000000000..7585319d21 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c490.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c4a1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c4a1.dat Binary files differnew file mode 100644 index 0000000000..4fe8b786e3 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c4a1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c51.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c51.dat Binary files differnew file mode 100644 index 0000000000..7fc7937b15 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c51.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c60.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c60.dat Binary files differnew file mode 100644 index 0000000000..d1fb08c946 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c60.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c71.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c71.dat Binary files differnew file mode 100644 index 0000000000..d4c2090a3b --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c71.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c81.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c81.dat Binary files differnew file mode 100644 index 0000000000..38b6ea6520 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c81.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c90.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c90.dat Binary files differnew file mode 100644 index 0000000000..a607a5969c --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/c90.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ca1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ca1.dat Binary files differnew file mode 100644 index 0000000000..19b4c9e340 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ca1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cb1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cb1.dat Binary files differnew file mode 100644 index 0000000000..73dc986572 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cb1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cc0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cc0.dat Binary files differnew file mode 100644 index 0000000000..d1eef3bb56 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cc0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cd1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cd1.dat Binary files differnew file mode 100644 index 0000000000..c7e6db3ef7 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cd1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ce1.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ce1.dat Binary files differnew file mode 100644 index 0000000000..8fd3bf17a8 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/ce1.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cf0.dat b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cf0.dat Binary files differnew file mode 100644 index 0000000000..332b3d9a8a --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/seg0/cf0.dat diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/service.properties b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/service.properties new file mode 100644 index 0000000000..8cfe3b09a5 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/dastest/service.properties @@ -0,0 +1,22 @@ +#C:\apacheSVN\java\target\dastest +# ******************************************************************** +# *** Please do NOT edit this file. *** +# *** CHANGING THE CONTENT OF THIS FILE MAY CAUSE DATA CORRUPTION. *** +# ********************************************************************
+#Fri Feb 17 08:55:29 MST 2006
+SysschemasIndex2Identifier=225
+SyscolumnsIdentifier=144
+SysconglomeratesIndex1Identifier=49
+SysconglomeratesIdentifier=32
+SyscolumnsIndex2Identifier=177
+SysschemasIndex1Identifier=209
+SysconglomeratesIndex3Identifier=81
+SystablesIndex2Identifier=129
+SyscolumnsIndex1Identifier=161
+derby.serviceProtocol=org.apache.derby.database.Database
+SysschemasIdentifier=192
+derby.storage.propertiesId=16
+SysconglomeratesIndex2Identifier=65
+derby.serviceLocale=en_US
+SystablesIdentifier=96
+SystablesIndex1Identifier=113
diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/pom.xml b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/pom.xml new file mode 100644 index 0000000000..942ccccb21 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/pom.xml @@ -0,0 +1,42 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * Copyright (c) 2005-2006 The Apache Software Foundation or its licensors, as applicable. + * + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + --> +<project> + + <parent> + <groupId>org.apache.tuscany.samples.das</groupId> + <artifactId>das-samples</artifactId> + <version>SNAPSHOT</version> + </parent> + + <modelVersion>4.0.0</modelVersion> + <artifactId>companyWeb</artifactId> + <packaging>war</packaging> + <name>Tuscany DAS sample Company WEB</name> + <description>Sample use of RDB DAS with JSP</description> + <version>SNAPSHOT</version> + + <dependencies> + + <dependency> + <groupId>org.apache.tuscany.das</groupId> + <artifactId>tuscany-das-rdb</artifactId> + <version>${pom.version}</version> + <scope>provided</scope> + </dependency> + + </dependencies> +</project> diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/readme.htm b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/readme.htm new file mode 100644 index 0000000000..f9bfd4c946 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/readme.htm @@ -0,0 +1,567 @@ +<html xmlns:o="urn:schemas-microsoft-com:office:office"
+xmlns:w="urn:schemas-microsoft-com:office:word"
+xmlns:st1="urn:schemas-microsoft-com:office:smarttags"
+xmlns="http://www.w3.org/TR/REC-html40">
+
+<head>
+<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
+<meta name=ProgId content=Word.Document>
+<meta name=Generator content="Microsoft Word 10">
+<meta name=Originator content="Microsoft Word 10">
+<link rel=File-List href="readme_files/filelist.xml">
+<title>Tuscany RDB DAS Sample</title>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="City"/>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="State"/>
+<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
+ name="place"/>
+<!--[if gte mso 9]><xml>
+ <o:DocumentProperties>
+ <o:Author>IBM_USER</o:Author>
+ <o:LastAuthor>IBM_USER</o:LastAuthor>
+ <o:Revision>4</o:Revision>
+ <o:TotalTime>132</o:TotalTime>
+ <o:Created>2006-03-03T01:56:00Z</o:Created>
+ <o:LastSaved>2006-03-03T01:56:00Z</o:LastSaved>
+ <o:Pages>1</o:Pages>
+ <o:Words>909</o:Words>
+ <o:Characters>5187</o:Characters>
+ <o:Company>IBM</o:Company>
+ <o:Lines>43</o:Lines>
+ <o:Paragraphs>12</o:Paragraphs>
+ <o:CharactersWithSpaces>6084</o:CharactersWithSpaces>
+ <o:Version>10.6735</o:Version>
+ </o:DocumentProperties>
+</xml><![endif]--><!--[if gte mso 9]><xml>
+ <w:WordDocument>
+ <w:SpellingState>Clean</w:SpellingState>
+ <w:GrammarState>Clean</w:GrammarState>
+ <w:Compatibility>
+ <w:BreakWrappedTables/>
+ <w:SnapToGridInCell/>
+ <w:WrapTextWithPunct/>
+ <w:UseAsianBreakRules/>
+ </w:Compatibility>
+ <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
+ </w:WordDocument>
+</xml><![endif]--><!--[if !mso]><object
+ classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
+<style>
+st1\:*{behavior:url(#ieooui) }
+</style>
+<![endif]-->
+<style>
+<!--
+ /* Font Definitions */
+ @font-face
+ {font-family:Wingdings;
+ panose-1:5 0 0 0 0 0 0 0 0 0;
+ mso-font-charset:2;
+ mso-generic-font-family:auto;
+ mso-font-pitch:variable;
+ mso-font-signature:0 268435456 0 0 -2147483648 0;}
+ /* Style Definitions */
+ p.MsoNormal, li.MsoNormal, div.MsoNormal
+ {mso-style-parent:"";
+ margin:0in;
+ margin-bottom:.0001pt;
+ mso-pagination:widow-orphan;
+ font-size:12.0pt;
+ font-family:"Times New Roman";
+ mso-fareast-font-family:"Times New Roman";}
+h1
+ {mso-style-next:Normal;
+ margin-top:12.0pt;
+ margin-right:0in;
+ margin-bottom:3.0pt;
+ margin-left:0in;
+ mso-pagination:widow-orphan;
+ page-break-after:avoid;
+ mso-outline-level:1;
+ font-size:16.0pt;
+ font-family:Arial;
+ mso-font-kerning:16.0pt;}
+p.MsoFootnoteText, li.MsoFootnoteText, div.MsoFootnoteText
+ {mso-style-noshow:yes;
+ margin:0in;
+ margin-bottom:.0001pt;
+ mso-pagination:widow-orphan;
+ font-size:10.0pt;
+ font-family:"Times New Roman";
+ mso-fareast-font-family:"Times New Roman";}
+span.MsoFootnoteReference
+ {mso-style-noshow:yes;
+ vertical-align:super;}
+a:link, span.MsoHyperlink
+ {color:blue;
+ text-decoration:underline;
+ text-underline:single;}
+a:visited, span.MsoHyperlinkFollowed
+ {color:purple;
+ text-decoration:underline;
+ text-underline:single;}
+pre
+ {margin:0in;
+ margin-bottom:.0001pt;
+ mso-pagination:widow-orphan;
+ font-size:10.0pt;
+ font-family:"Courier New";
+ mso-fareast-font-family:"Times New Roman";}
+span.codefrag
+ {mso-style-name:codefrag;}
+span.SpellE
+ {mso-style-name:"";
+ mso-spl-e:yes;}
+span.GramE
+ {mso-style-name:"";
+ mso-gram-e:yes;}
+@page Section1
+ {size:8.5in 11.0in;
+ margin:1.0in 1.25in 1.0in 1.25in;
+ mso-header-margin:.5in;
+ mso-footer-margin:.5in;
+ mso-paper-source:0;}
+div.Section1
+ {page:Section1;}
+ /* List Definitions */
+ @list l0
+ {mso-list-id:280770398;
+ mso-list-type:hybrid;
+ mso-list-template-ids:-1591061486 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
+@list l0:level1
+ {mso-level-number-format:bullet;
+ mso-level-text:\F0B7;
+ mso-level-tab-stop:.5in;
+ mso-level-number-position:left;
+ text-indent:-.25in;
+ font-family:Symbol;}
+@list l1
+ {mso-list-id:646667692;
+ mso-list-type:hybrid;
+ mso-list-template-ids:-728441462 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
+@list l1:level1
+ {mso-level-number-format:bullet;
+ mso-level-text:\F0B7;
+ mso-level-tab-stop:.5in;
+ mso-level-number-position:left;
+ text-indent:-.25in;
+ font-family:Symbol;}
+@list l2
+ {mso-list-id:975526902;
+ mso-list-type:hybrid;
+ mso-list-template-ids:1435802096 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
+@list l2:level1
+ {mso-level-tab-stop:.5in;
+ mso-level-number-position:left;
+ text-indent:-.25in;}
+@list l3
+ {mso-list-id:1305811547;
+ mso-list-type:hybrid;
+ mso-list-template-ids:42887628 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
+@list l3:level1
+ {mso-level-tab-stop:.5in;
+ mso-level-number-position:left;
+ text-indent:-.25in;}
+@list l3:level2
+ {mso-level-number-format:alpha-lower;
+ mso-level-tab-stop:1.0in;
+ mso-level-number-position:left;
+ text-indent:-.25in;}
+@list l4
+ {mso-list-id:1766462262;
+ mso-list-type:hybrid;
+ mso-list-template-ids:2029450580 67698689 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
+@list l4:level1
+ {mso-level-number-format:bullet;
+ mso-level-text:\F0B7;
+ mso-level-tab-stop:.5in;
+ mso-level-number-position:left;
+ text-indent:-.25in;
+ font-family:Symbol;}
+@list l4:level2
+ {mso-level-number-format:alpha-lower;
+ mso-level-tab-stop:1.0in;
+ mso-level-number-position:left;
+ text-indent:-.25in;}
+ol
+ {margin-bottom:0in;}
+ul
+ {margin-bottom:0in;}
+-->
+</style>
+<!--[if gte mso 10]>
+<style>
+ /* Style Definitions */
+ table.MsoNormalTable
+ {mso-style-name:"Table Normal";
+ mso-tstyle-rowband-size:0;
+ mso-tstyle-colband-size:0;
+ mso-style-noshow:yes;
+ mso-style-parent:"";
+ mso-padding-alt:0in 5.4pt 0in 5.4pt;
+ mso-para-margin:0in;
+ mso-para-margin-bottom:.0001pt;
+ mso-pagination:widow-orphan;
+ font-size:10.0pt;
+ font-family:"Times New Roman";}
+</style>
+<![endif]-->
+</head>
+
+<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
+
+<div class=Section1>
+
+<p class=MsoNormal><span class=GramE><span style='font-size:9.0pt'>Copyright<span
+style='color:black'> </span>(c)<span style='color:black'> </span>2005<span
+style='color:black'> </span>The<span style='color:black'> </span>Apache<span
+style='color:black'> </span>Software<span style='color:black'> </span>Foundation<span
+style='color:black'> </span>or<span style='color:black'> </span>its<span
+style='color:black'> </span>licensors,<span style='color:black'> </span>as<span
+style='color:black'> </span>applicable.</span></span><span style='font-size:
+9.0pt'><o:p></o:p></span></p>
+
+<p class=MsoNormal><span style='font-size:9.0pt'>Licensed<span
+style='color:black'> </span>under<span style='color:black'> </span>the<span
+style='color:black'> </span>Apache<span style='color:black'> </span>License,<span
+style='color:black'> </span>Version<span style='color:black'> </span>2.0<span
+style='color:black'> </span>(the<span style='color:black'> </span>"License");
+you<span style='color:black'> </span>may<span style='color:black'> </span>not<span
+style='color:black'> </span>use<span style='color:black'> </span>this<span
+style='color:black'> </span>file<span style='color:black'> </span>except<span
+style='color:black'> </span>in<span style='color:black'> </span>compliance<span
+style='color:black'> </span>with<span style='color:black'> </span>the<span
+style='color:black'> </span>License. You<span style='color:black'> </span>may<span
+style='color:black'> </span>obtain<span style='color:black'> </span>a<span
+style='color:black'> </span>copy<span style='color:black'> </span>of<span
+style='color:black'> </span>the<span style='color:black'> </span>License<span
+style='color:black'> </span>at<o:p></o:p></span></p>
+
+<p class=MsoNormal><span style='font-size:9.0pt'><o:p> </o:p></span></p>
+
+<p class=MsoNormal><span style='font-size:9.0pt;color:black'><span
+style='mso-spacerun:yes'> </span><span style='mso-spacerun:yes'> </span></span><span
+style='font-size:9.0pt'>http://www.apache.org/licenses/LICENSE-2.0<o:p></o:p></span></p>
+
+<p class=MsoNormal><span style='font-size:9.0pt'><o:p> </o:p></span></p>
+
+<p class=MsoNormal><span style='font-size:9.0pt'>Unless<span style='color:black'>
+</span>required<span style='color:black'> </span>by<span style='color:black'> </span>applicable<span
+style='color:black'> </span>law<span style='color:black'> </span>or<span
+style='color:black'> </span>agreed<span style='color:black'> </span>to<span
+style='color:black'> </span>in<span style='color:black'> </span>writing,<span
+style='color:black'> </span>software distributed<span style='color:black'> </span>under<span
+style='color:black'> </span>the<span style='color:black'> </span>License<span
+style='color:black'> </span>is<span style='color:black'> </span>distributed<span
+style='color:black'> </span>on<span style='color:black'> </span>an<span
+style='color:black'> </span>"AS<span style='color:black'> </span>IS"<span
+style='color:black'> </span>BASIS, WITHOUT<span style='color:black'> </span>WARRANTIES<span
+style='color:black'> </span>OR<span style='color:black'> </span>CONDITIONS<span
+style='color:black'> </span>OF<span style='color:black'> </span>ANY<span
+style='color:black'> </span>KIND,<span style='color:black'> </span>either<span
+style='color:black'> </span>express<span style='color:black'> </span>or<span
+style='color:black'> </span>implied. See<span style='color:black'> </span>the<span
+style='color:black'> </span>License<span style='color:black'> </span>for<span
+style='color:black'> </span>the<span style='color:black'> </span>specific<span
+style='color:black'> </span>language<span style='color:black'> </span>governing<span
+style='color:black'> </span>permissions<span style='color:black'> </span>and
+limitations<span style='color:black'> </span>under<span style='color:black'> </span>the<span
+style='color:black'> </span>License.<o:p></o:p></span></p>
+
+<h1><st1:State><st1:place>Tuscany</st1:place></st1:State> RDB DAS Sample</h1>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>This stand-alone sample demonstrates usage of the SDO RDB
+Data Access Service in the context of a simple web application.</p>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>The application starts with a canned database of Companies
+and their related Departments.<span style='mso-spacerun:yes'> </span>Through
+the web page interface, a user can:</p>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<ol style='margin-top:0in' start=1 type=1>
+ <li class=MsoNormal style='mso-list:l2 level1 lfo1;tab-stops:list .5in'>Display
+ all Companies in the database</li>
+ <li class=MsoNormal style='mso-list:l2 level1 lfo1;tab-stops:list .5in'>Display
+ all Companies and related Departments</li>
+ <li class=MsoNormal style='mso-list:l2 level1 lfo1;tab-stops:list .5in'>Add a
+ new Department to a Company</li>
+ <li class=MsoNormal style='mso-list:l2 level1 lfo1;tab-stops:list .5in'>Delete
+ all Departments from a Company</li>
+ <li class=MsoNormal style='mso-list:l2 level1 lfo1;tab-stops:list .5in'>Change
+ the names of Departments in a Company</li>
+</ol>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>So, this simple application covers all CRUD operations as
+well as the some relationship manipulation (adding a Department associates that
+Department with the Company).<span style='mso-spacerun:yes'> </span>The sample
+runs on Tomcat 5.5 and uses <st1:City><st1:place>Derby</st1:place></st1:City>
+database.<span style='mso-spacerun:yes'> </span>Access to the database is via
+a DataSource.</p>
+
+<h1>Set Up</h1>
+
+<ol style='margin-top:0in' start=1 type=1>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Download
+ and install the most recent stable version of Tomcat 5.5.<span
+ style='mso-spacerun:yes'> </span>You can find it here: <a
+ href="http://tomcat.apache.org/download-55.cgi">http://tomcat.apache.org/download-55.cgi</a></li>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Down
+ load the most recent official release of <st1:City><st1:place>Derby</st1:place></st1:City>
+ from here: <a href="http://db.apache.org/derby/index.html">http://db.apache.org/derby/index.html</a>.<span
+ style='mso-spacerun:yes'> </span>The only file you’ll need from this
+ download is <span class=SpellE>derby.jar</span></li>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Stop
+ Tomcat</li>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Move the
+ following files (details in appendix) to {<span class=SpellE>Tomcat_Home</span>}/common/lib:</li>
+ <ol style='margin-top:0in' start=1 type=a>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>tuscany-das-rdb-SNAPSHOT.jar</span></li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>sdo-api-SNAPSHOT.jar</span></li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>tuscany-sdo-impl-SNAPSHOT.jar</span></li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>xsd</span>{latest version}.jar</li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE><span class=GramE>ecore</span></span><span class=GramE>-{</span>latest
+ version}..jar</li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE><span class=GramE>ecore</span></span><span class=GramE>-</span>change-{latest
+ version}..jar</li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>ecore-xmi</span>-{latest version}.jar</li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'>common-{latest
+ version}.jar</li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>derby.jar</span></li>
+ </ol>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Add
+ the following files to {<span class=SpellE>Tomcat_Home</span>}/work</li>
+ <ol style='margin-top:0in' start=1 type=a>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>companyWeb-SNAPSHOT.war</span></li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'><span
+ class=SpellE>CompanyAppGbl.xml</span></li>
+ </ol>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Install
+ the canned <st1:City><st1:place>Derby</st1:place></st1:City> database by copying
+ the <span class=SpellE>dastest</span> directory to {<span class=SpellE>Tomcat_Home</span>}/Databases.<span
+ style='mso-spacerun:yes'> </span>The “<span class=SpellE>dastest</span>”
+ directory is found at /java/samples/<span class=SpellE>das/companyweb</span>.<span
+ style='mso-spacerun:yes'> </span>So, just copy this directory, create a
+ “Databases” directory from {Tomcat Home} and drop in the “<span
+ class=SpellE>dastest</span>” folder with all it contents.</li>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Define
+ a DataSource by adding a <span class=SpellE>datasource</span> definition
+ to {<span class=SpellE><span class=codefrag>Tomcat_Home</span></span><span
+ class=codefrag>}/conf/<span class=SpellE>server.xml</span></span>.</li>
+ <ol style='margin-top:0in' start=1 type=a>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'>Find
+ the end-of-section marker <span class=codefrag></<span class=SpellE>GlobalNamingResources</span>></span>
+ and add the following lines just above it: </li>
+ </ol>
+</ol>
+
+<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
+
+<pre><span style='mso-spacerun:yes'> </span><span class=GramE><span
+style='font-size:9.0pt'><!--</span></span><span style='font-size:9.0pt'> Global <span
+class=SpellE>Datasource</span> for </span><st1:City><st1:place><span
+ style='font-size:9.0pt'>Derby</span></st1:place></st1:City><span
+style='font-size:9.0pt'> <span class=SpellE>dastest</span> database --><o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><Resource name="<span
+class=SpellE>jdbc/dastest</span>"<o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><span
+class=GramE>type</span>="<span class=SpellE>javax.sql.DataSource</span>" <span style='mso-spacerun:yes'> </span>auth="Container"<o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><span
+class=GramE>description</span>="</span><st1:City><st1:place><span
+ style='font-size:9.0pt'>Derby</span></st1:place></st1:City><span
+style='font-size:9.0pt'> database for DAS Company sample"<o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><span
+class=SpellE><span class=GramE>maxActive</span></span>="100" <span
+class=SpellE>maxIdle</span>="30" <span class=SpellE>maxWait</span>="10000"<o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span>username="" password="" <o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><span
+class=SpellE><span class=GramE>driverClassName</span></span>="<span
+class=SpellE>org.apache.derby.jdbc.EmbeddedDriver</span>"<o:p></o:p></span></pre><pre><span
+style='font-size:9.0pt'><span style='mso-spacerun:yes'> </span><span style='mso-spacerun:yes'> </span><span
+class=SpellE><span class=GramE>url</span></span>="<span class=SpellE>jdbc:derby:Databases/dastest</span>"/><o:p></o:p></span></pre><pre><span
+style='mso-tab-count:3'> </span></pre>
+
+<ol style='margin-top:0in' start=8 type=1>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'><span
+ style='mso-spacerun:yes'> </span>Start tomcat and </li>
+ <ol style='margin-top:0in' start=1 type=a>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'>go
+ to the manager console <a href="http://localhost:8080/manager/html">http://localhost:8080/manager/html</a></li>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'>Scroll
+ down to the “deploy” section and enter the following:</li>
+ </ol>
+</ol>
+
+<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
+
+<pre style='margin-left:1.0in'><span style='font-size:9.0pt'>Context Path (optional):<span style='mso-spacerun:yes'> </span><span
+style='mso-tab-count:1'> </span>/<span class=SpellE>CompanyApp</span><o:p></o:p></span></pre><pre
+style='margin-left:1.0in'><span style='font-size:9.0pt'>XML Configuration <span
+class=GramE>file</span> URL:<span style='mso-tab-count:1'> </span>work/<span
+class=SpellE>CompanyAppGbl.xml</span><o:p></o:p></span></pre><pre
+style='margin-left:1.0in'><span style='font-size:9.0pt'>WAR or Directory URL:<span style='mso-spacerun:yes'> </span><span
+style='mso-tab-count:1'> </span>work/<span class=SpellE>CompanyApp.war</span><o:p></o:p></span></pre><pre><o:p> </o:p></pre>
+
+<ol style='margin-top:0in' start=8 type=1>
+ <ol style='margin-top:0in' start=3 type=a>
+ <li class=MsoNormal style='mso-list:l3 level2 lfo2;tab-stops:list 1.0in'>Hit
+ the “deploy” button</li>
+ </ol>
+</ol>
+
+<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
+
+<ol style='margin-top:0in' start=9 type=1>
+ <li class=MsoNormal style='mso-list:l3 level1 lfo2;tab-stops:list .5in'>Get to
+ the sample application by clicking the named application in the “path”
+ column of the application <span class=SpellE>sectiom</span> of the manager
+ console.<span style='mso-spacerun:yes'> </span>Alternatively, you can
+ point your browser to http://localhost:8080/CompanyApp/<o:p></o:p></li>
+</ol>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<h1>Sample Architecture</h1>
+
+<p class=MsoNormal>This is a simple, single-page, web application.<span
+style='mso-spacerun:yes'> </span>The main components of this application are:</p>
+
+<ul style='margin-top:0in' type=disc>
+ <li class=MsoNormal style='mso-list:l1 level1 lfo3;tab-stops:list .5in'>The
+ RDB Data Access Service (DAS)</li>
+ <li class=MsoNormal style='mso-list:l1 level1 lfo3;tab-stops:list .5in'>SDO</li>
+ <li class=MsoNormal style='mso-list:l1 level1 lfo3;tab-stops:list .5in'><span
+ class=SpellE>CompanyClient.java</span></li>
+ <li class=MsoNormal style='mso-list:l1 level1 lfo3;tab-stops:list .5in'><span
+ class=SpellE>Company.jsp</span></li>
+ <li class=MsoNormal style='mso-list:l1 level1 lfo3;tab-stops:list .5in'>The
+ canned <st1:City><st1:place>Derby</st1:place></st1:City> database</li>
+</ul>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>The <span class=SpellE><b style='mso-bidi-font-weight:normal'>CompanyClient</b></span>
+uses the <b style='mso-bidi-font-weight:normal'>DAS</b> directly and provides
+high-level services to the <span class=SpellE>jsp</span> such as:</p>
+
+<p class=MsoNormal style='margin-left:.5in'><span class=GramE>public</span>
+final List <span class=SpellE>getCompanies</span>()</p>
+
+<p class=MsoNormal>This is a good place to look for how you might use the DAS
+in your own application.</p>
+
+<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
+
+<p class=MsoNormal>The <span class=SpellE><b style='mso-bidi-font-weight:normal'>Company.jsp</b></span>
+responds to client interaction by invoking services of the <span class=SpellE>CompanyClient</span>.<span
+style='mso-spacerun:yes'> </span>It receives data from the <span class=SpellE>CompanyClient</span>
+as SDO data graphs and manipulates <span class=SpellE>SDOs</span> directly to
+display data.</p>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>The canned <st1:City><st1:place><b style='mso-bidi-font-weight:
+ normal'>Derby</b></st1:place></st1:City><b style='mso-bidi-font-weight:normal'>
+database</b> comes preloaded with Companies and related Departments.<span
+style='mso-spacerun:yes'> </span>The database instance is a simple file
+folder.</p>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>The <b style='mso-bidi-font-weight:normal'>DAS</b> accepts
+directives (commands) from the <span class=SpellE><b style='mso-bidi-font-weight:
+normal'>CompanyClient</b></span><b style='mso-bidi-font-weight:normal'> </b>and
+reads and writes to the derby database instance appropriately.<b
+style='mso-bidi-font-weight:normal'> <o:p></o:p></b></p>
+
+<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><o:p> </o:p></b></p>
+
+<h1>Appendix</h1>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>The following specifies where you can find the dependency
+jars you need to run this sample.<span style='mso-spacerun:yes'> </span>These
+jars are available <b style='mso-bidi-font-weight:normal'>only</b> after you
+have successfully downloaded and build Tuscany/java.<span
+style='mso-spacerun:yes'> </span>Instructions for building can be found here: </p>
+
+<p class=MsoNormal style='margin-left:.5in'><a
+href="https://svn.apache.org/repos/asf/incubator/tuscany/java/BUILDING.txt">https://svn.apache.org/repos/asf/incubator/tuscany/java/BUILDING.txt</a></p>
+
+<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
+
+<p class=MsoNormal><span class=SpellE>Dendendency</span> jar locations:</p>
+
+<ul style='margin-top:0in' type=disc>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>tuscany-das-rdb-SNAPSHOT.jar</span> – /java/<span
+ class=SpellE>das/rdb/target</span></li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>sdo-api-SNAPSHOT.jar</span> – /java/spec/<span class=SpellE>sdo</span>/target</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>tuscany-sdo-impl-SNAPSHOT.jar</span> – /java/<span
+ class=SpellE>sdo/impl/target</span></li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>xsd</span>{latest version}.jar –
+ {user}/.m2/repository/org/eclipse/xsd</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>ecore</span>-{latest version}.jar –
+ {user}/.m2/repository/org/eclipse/emf/ecore</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>ecore</span>-change-{latest version}.jar –
+ {user}/.m2/repository/org/eclipse/emf/ecore-change</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>ecore-xmi</span>-{latest version}.jar <span class=SpellE>jar</span>
+ – {user}/.m2/repository/org/eclipse/emf/ecore-xmi</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'>common-{latest
+ version}.jar <span class=SpellE>jar</span> –
+ {user}/.m2/repository/org/eclipse/emf/common</li>
+ <li class=MsoNormal style='mso-list:l4 level1 lfo4;tab-stops:list .5in'><span
+ class=SpellE>derby.jar</span></li>
+</ul>
+
+<p class=MsoNormal><o:p> </o:p></p>
+
+<p class=MsoNormal>Conventions:</p>
+
+<ul style='margin-top:0in' type=disc>
+ <li class=MsoNormal style='mso-list:l0 level1 lfo5;tab-stops:list .5in'>{<span
+ class=GramE>user</span>} refers the directory where Maven2 is installed on
+ your machine.<span style='mso-spacerun:yes'> </span>On my machine,
+ “{user}” is “C:\Documents and Settings\Administrator”</li>
+ <li class=MsoNormal style='mso-list:l0 level1 lfo5;tab-stops:list .5in'>{<span
+ class=SpellE>Tomcat_Home</span>} refers to the directory that Tomcat is
+ installed on your machine.<span style='mso-spacerun:yes'> </span>On my
+ machine, this is “C:\Program Files\Apache Software Foundation\Tomcat 5.5”</li>
+ <li class=MsoNormal style='mso-list:l0 level1 lfo5;tab-stops:list .5in'>{<span
+ class=GramE>latest</span> version} means the tag associated with the
+ latest version available in the maven2 repository.<span
+ style='mso-spacerun:yes'> </span>For example the version of <span
+ class=SpellE>ecore</span>-{latest version}.jar that I used for testing
+ this sample is “ecore-2.2.0-I200602160000.jar”<o:p></o:p></li>
+</ul>
+
+</div>
+
+</body>
+
+</html>
diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/java/org/apache/tuscany/samples/companyweb/CompanyClient.java b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/java/org/apache/tuscany/samples/companyweb/CompanyClient.java new file mode 100644 index 0000000000..32711609e1 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/java/org/apache/tuscany/samples/companyweb/CompanyClient.java @@ -0,0 +1,133 @@ +package org.apache.tuscany.samples.das.companyweb; + +import java.io.InputStream; +import java.util.ArrayList; +import java.util.Iterator; +import java.util.List; +import java.util.Random; + +import org.apache.tuscany.das.rdb.ApplyChangesCommand; +import org.apache.tuscany.das.rdb.Command; +import org.apache.tuscany.das.rdb.CommandGroup; + +import commonj.sdo.DataObject; + +public class CompanyClient { + + private Random generator = new Random(); + + private CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml")); + + public final List getCompanies() { + + Command read = commandGroup.getCommand("all companies"); + DataObject root = read.executeQuery(); + return root.getList("COMPANY"); + + } + + public final List getCompaniesWithDepartments() { + + Command read = commandGroup.getCommand("all companies and departments"); + DataObject root = read.executeQuery(); + return root.getList("COMPANY"); + } + + public final List getDepartmentsForCompany(int id) { + Command read = commandGroup.getCommand("all departments for company"); + read.setParameterValue("ID", new Integer(id)); + DataObject root = read.executeQuery(); + return root.getList("COMPANY"); + } + + public final void addDepartmentToFirstCompany() { + Command read = commandGroup.getCommand("all companies and departments"); + DataObject root = read.executeQuery(); + DataObject firstCustomer = root.getDataObject("COMPANY[1]"); + + DataObject newDepartment = root.createDataObject("DEPARTMENT"); + newDepartment.setString("NAME", "Default Name"); + firstCustomer.getList("departments").add(newDepartment); + + ApplyChangesCommand apply = commandGroup.getApplyChangesCommand(); + apply.execute(root); + + } + + public final void deleteDepartmentsFromFirstCompany() { + + // This section gets the ID of the first Company just so I can + // demonstrate a parameterized command next + Command readAll = commandGroup.getCommand("all companies and departments"); + DataObject root = readAll.executeQuery(); + int idOfFirstCustomer = root.getInt("COMPANY[1]/ID"); + System.out.println("ID of first company is: " + idOfFirstCustomer); + + // Read a specific company based on the known ID + Command readCust = commandGroup.getCommand("company by id with departments"); + readCust.setParameterValue("ID", new Integer(idOfFirstCustomer)); + root = readCust.executeQuery(); + + // Delete all the comany's departments from the graph + DataObject firstCustomer = root.getDataObject("COMPANY[1]"); + + // Shallow copy of list for deleting. This is required to avoid the + // dreaded + // ConcurrentModificationException since #delete operation also removes + // from the original list + List allDepartments = new ArrayList(firstCustomer.getList("departments")); + + Iterator i = allDepartments.iterator(); + DataObject department; + while (i.hasNext()) { + department = (DataObject) i.next(); + System.out.println("Deleting department named: " + department.getString("NAME")); + department.delete(); + } + + ApplyChangesCommand apply = commandGroup.getApplyChangesCommand(); + apply.execute(root); + + } + + public final void changeFirstCompanysDepartmentNames() { + + // This section gets the ID of the first Company just so I can + // demonstrate a parameterized command next + Command readAll = commandGroup.getCommand("all companies and departments"); + DataObject root = readAll.executeQuery(); + int idOfFirstCustomer = root.getInt("COMPANY[1]/ID"); + System.out.println("ID of first company is: " + idOfFirstCustomer); + + // Read a specific company based on the known ID + Command readCust = commandGroup.getCommand("company by id with departments"); + readCust.setParameterValue("ID", new Integer(idOfFirstCustomer)); + root = readCust.executeQuery(); + + // Modify all the comany's department names + DataObject firstCustomer = root.getDataObject("COMPANY[1]"); + Iterator i = firstCustomer.getList("departments").iterator(); + DataObject department; + while (i.hasNext()) { + department = (DataObject) i.next(); + System.out.println("Modifying department: " + department.getString("NAME")); + department.setString("NAME", getRandomDepartmentName()); + } + + ApplyChangesCommand apply = commandGroup.getApplyChangesCommand(); + apply.execute(root); + + } + + // Utilities + + private String getRandomDepartmentName() { + int number = generator.nextInt(1000) + 1; + return "Dept-" + number; + } + + private InputStream getConfig(String fileName) { + return getClass().getClassLoader().getResourceAsStream(fileName); + } + +} diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/resources/CompanyConfig.xml b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/resources/CompanyConfig.xml new file mode 100644 index 0000000000..dc28804336 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/resources/CompanyConfig.xml @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="UTF-8"?> +<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 = :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 = :ID" kind="Select"/> + + + <ConnectionProperties dataSource="java:comp/env/jdbc/dastest"/> + + +<!-- + <ConnectionProperties driverClassName="org.apache.derby.jdbc.EmbeddedDriver" + driverURL="jdbc:derby:dastest"/> +--> + <Table name="COMPANY"> + <Column name="ID" primaryKey="true" generated="true"/> + </Table> + + <Table name="DEPARTMENT"> + <Column name="ID" primaryKey="true" generated="true"/> + </Table> + + <Relationship name="departments" primaryKeyTable="COMPANY" foreignKeyTable="DEPARTMENT" many="true"> + <KeyPair primaryKeyColumn="ID" foreignKeyColumn="COMPANYID"/> + </Relationship> + + +</Config>
\ No newline at end of file diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/Company.jsp b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/Company.jsp new file mode 100644 index 0000000000..c064f0a4fe --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/Company.jsp @@ -0,0 +1,151 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ --%>
+
+<html>
+<head>
+<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
+
+ pageEncoding="ISO-8859-1"
+
+ import="org.apache.tuscany.samples.das.companyweb.CompanyClient"
+ import="commonj.sdo.*"
+%>
+
+<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>Company Test</title>
+</head>
+<body>
+
+<H2>Tuscany DAS Companies WEB Example</H2>
+
+
+<form>
+<input type="submit" id="doFill" name="doFill" value="All Companies">
+<input type="submit" id="doFillAll" name="doFillAll" value="All Companies/Departments">
+<input type="submit" id="doAddDepartment" name="doAddDepartment" value="Add department to first company">
+<input type="submit" id="doChangeDepartmentNames" name="doChangeDepartmentNames" value="Change Company(1) Dept names">
+<input type="submit" id="doDeleteDepartments" name="doDeleteDepartments" value="Delete Company(1) Depts">
+<hr>
+
+<!-- Do Fill -->
+<%if(request.getParameter("doFill") != null){%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>Name</th>
+ </tr>
+ </thead>
+ <tbody>
+
+ <%
+ java.util.Iterator i = (new CompanyClient()).getCompaniesWithDepartments().iterator();
+ while (i.hasNext()) {
+ DataObject company = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=company.getInt("ID")%></td>
+ <td><%=company.getString("NAME")%></td>
+ <tr>
+ <%
+ }
+ %>
+
+ </tbody>
+</table>
+<%}%>
+
+
+<!-- Do Add Department -->
+<%
+if(request.getParameter("doAddDepartment") != null){
+
+ (new CompanyClient()).addDepartmentToFirstCompany();
+
+}
+%>
+
+<!-- Do Delete Departments from first company -->
+<%
+if(request.getParameter("doDeleteDepartments") != null){
+
+ (new CompanyClient()).deleteDepartmentsFromFirstCompany();
+}
+%>
+
+<!-- Do Change First Company's Department Names -->
+<%
+if(request.getParameter("doChangeDepartmentNames") != null){
+
+ (new CompanyClient()).changeFirstCompanysDepartmentNames();
+}
+%>
+
+
+<!-- Do FillAll -->
+<%if(request.getParameter("doFill") == null) {%>
+
+<table border>
+ <thead>
+ <tr>
+ <th>ID</th>
+ <th>Name</th>
+ <th>Department_ID</th>
+ <th>Department_Name</th>
+ </tr>
+ </thead>
+ <tbody>
+
+ <%
+ java.util.Iterator i = (new CompanyClient()).getCompaniesWithDepartments().iterator();
+ while (i.hasNext()) {
+ DataObject company = (DataObject)i.next();
+ %>
+ <tr>
+ <td><%=company.getInt("ID")%></td>
+ <td><%=company.getString("NAME")%></td>
+ <tr>
+
+
+
+ <%
+ java.util.Iterator j = company.getList("departments").iterator();
+ while (j.hasNext()) {
+ DataObject department = (DataObject)j.next();
+ %>
+ <tr>
+ <td></td><td></td><td><%=department.getInt("ID")%></td>
+ <td><%=department.getString("NAME")%></td>
+ <tr>
+ <%
+ }
+ %>
+ <%
+ }
+ %>
+
+ </tbody>
+</table>
+<%}%>
+
+
+
+</form>
+</body>
+</html>
diff --git a/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/WEB-INF/web.xml b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/WEB-INF/web.xml new file mode 100644 index 0000000000..2908daece9 --- /dev/null +++ b/sca-java-1.x/tags/java-stable-20060304/samples/das/companyweb/src/main/webapp/WEB-INF/web.xml @@ -0,0 +1,27 @@ +<?xml version="1.0" encoding="ISO-8859-1"?> +<!-- + Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable. + + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. + --> +<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web +Application 2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd"> + +<web-app> + <display-name>Tuscany DAS sample Company WEB</display-name> + + <welcome-file-list id="WelcomeFileList"> + <welcome-file>Company.jsp</welcome-file> + </welcome-file-list> + +</web-app> |