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

[Evanthika Amarasiri (JIRA)]

     [ http://www.wso2.org/jira/browse/WSFC-69?page=all ]

Evanthika Amarasiri closed WSFC-69.
-----------------------------------

    Resolution: Fixed

The IF_EXISTS command was added to the SQLight bat file. The issue can be closed

> 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