Hi Harold, On Fri, Mar 13, 2009 at 9:23 AM, Harold Carr <[email protected]> wrote:
> Hello all, > > Questions on the DB portion of installation guide: > > > http://cwiki.apache.org/confluence/display/STONEHENGE/Stonehenge+PHP+and+WSAS+Stocktrader+Installation+Guide#StonehengePHPandWSASStocktraderInstallationGuide-database > > That sections says "Table scripts can be obtained from here": > > https://svn.apache.org/repos/asf/incubator/stonehenge/trunk/stocktrader/php/resources/db_scripts/ These scripts creates tables needed by PHP configuration service. These scripts are only used by WSO2 StockTrader implementation. It is used to change server combination dynamically, using PHP Configuration service. It assumes, you have already created database and other tables needed by stock trader business services and order processor services. > > > That has two scripts: > > - InsertScript.sql > - Table Creation.sql > > That sections says 'Run "Table Creation.sql" and "InsertScript.sql" > > It seems, looking at the scripts (note: I do not have SQL experience), it > seems they > might expect services to be running and possibly other files to exist. Services need not be running. It just inserts service end points. What do you mean by other files exist?? > > > Could someone give more information about how to proceed in this section? > > > ------------------------- > > Related, but hopefully orthogonal: > > How do those above scripts relate to: > > contrib/stocktrader/dotnet/Setup/DataLoad/CreateInsertXMLHoldingProc.sql > contrib/stocktrader/dotnet/Setup/StockTraderDB/Holding.xml They don't have any relationship. They are in the same database, that's all. > > > It seems the CreateInsertXMLHoldingProc script loads up the data from > Holding.xml > > There's plenty of data in their (and similarly for Account, AccountProfile, > Orders and Quote). > > Do the InsertScript and Table Creation scripts accomplish the same thing? These table creation scripts/insert scripts creates tables needed by business services and order processor services. Regards, Shankar > > > Thanks, > Harold > -- S.Uthaiyashankar Software Architect WSO2 Inc. http://wso2.com/ - "The Open Source SOA Company"
