[wsf-c-dev] [jira] Created: (WSFC-69) IF EXISTS command needed in the sqlite_schema.bat file located inside WSF_C_HOME\sandesha2c\config

[Evanthika Amarasiri (JIRA)]

IF EXISTS command needed in the sqlite_schema.bat file located inside WSF_C_HOME\sandesha2c\config
--------------------------------------------------------------------------------------------------

                 Key: WSFC-69
                 URL: http://www.wso2.org/jira/browse/WSFC-69
             Project: WSO2 WSF/C
          Issue Type: Bug
          Components: Build System / Windows
    Affects Versions: 1.0alpha2
         Environment: Windows XP
            Reporter: Evanthika Amarasiri
            Priority: Minor
             Fix For: 1.0.0


Below are the steps to reproduce the issue

1. Assume that you need to build WSF/C with SQLight enabled. Therefore, first install SQLight , set the correct paths in the config file
2. Next run the command "sqlite_schema.bat" and you will be given an error messages as below 
****************************************************************************************************************************************************************
C:\WSO2-Projects\WSF-C\Releases\1.0\source\wso2-wsf-c-src-1.0RC1\sandesha2c\config>sqlite3 sandesha2_svr_db "drop table create_seq;"
SQL error: no such table: create_seq

C:\WSO2-Projects\WSF-C\Releases\1.0\source\wso2-wsf-c-src-1.0RC1\sandesha2c\config>sqlite3 sandesha2_svr_db "drop table  invoker;"
SQL error: no such table: invoker

C:\WSO2-Projects\WSF-C\Releases\1.0\source\wso2-wsf-c-src-1.0RC1\sandesha2c\config>sqlite3 sandesha2_svr_db "drop table  sender"
SQL error: no such table: sender.................
****************************************************************************************************************************************************************

The reason for this is that the first command in the "sqlite_schema.bat" is to drop some tables but since my system is a fresh one, and no such tables exist, the script fails.

3. Therefore change the "sqlite_schema.bat" where it drops the tables/databases only if they exists in the system 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://www.wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira