I am not sure if they are the same but the outcome should be usable from all the stocktraders. I believe (read: good-guess) the two sets of scripts are functional equivalent at the high level. There are Oracle and MSSQL scripts in the dotnet but notDB2 or MYSQ. MYSQL would be cool to add. I bet the WSO2 guys have already done that.
-----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Friday, March 06, 2009 10:03 AM To: [email protected] Subject: How to create/populate the DB? [was: RFI: building, installing, running WSO2/Java version] Hello Shankar, Drew et al: We have decided not to have the students attempt to run the WSO2/Java version at this time. There are too many prerequisites (i.e., .NET version for the data, WSO2/PHP version for configuration). Instead, we are going to look at independently creating/populating the database. So now onto some questions. Shankar wrote: > Ideally, we have to extract table creation scripts and put it as common for > all the stonehenge stock trader projects. Drew wrote: > Those sql seeding scripts are in dotnet/setup. They are untested by me and > were included for completeness. Shankar pointed to the wiki for installation: http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide which in turns points to scripts for creating DB tables: https://svn.apache.org/repos/asf/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/ But Drew points to DB scripts in dotnet/setup. QUESTION: is there a document that lists all the DB tables? QUESTION: is there (or can someone) provide a mapping from such a document to the current code that sets this up? Our idea is to write code that is completely independent of the demo to do the table setup and initial population. Thanks, Harold
