[wsf-c-dev] [jira] Closed: (WSFC-39) IF_EXISTS command needed in the file mysql_schema.txt file located inside WSF_C_HOME\sandesha2c\config

[Evanthika Amarasiri (JIRA)]

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

Evanthika Amarasiri closed WSFC-39.
-----------------------------------

    Assignee:     (was: Samisa Abeysinghe)

IF EXISTS added to the mysql_schema.txt file

> IF_EXISTS command needed in the file mysql_schema.txt file located inside WSF_C_HOME\sandesha2c\config
> ------------------------------------------------------------------------------------------------------
>
>                 Key: WSFC-39
>                 URL: http://www.wso2.org/jira/browse/WSFC-39
>             Project: WSO2 WSF/C
>          Issue Type: Bug
>          Components: Apache Sandesha/C (RM)
>    Affects Versions: 1.0alpha2
>         Environment: Microsoft Visual Studio 8, MySQL Server 5.0, 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 MySQL enabled. Therefore, first install MySQL, set the correct paths in the config file and run the commands specified in the "create_mysql_user.txt" file
> 2. Next run the command "init_mysql.bat" and you will be given an error message saying that the sandesha2 database does not exist. 
> The reason for this is that the first command in the "mysql_schema.txt" is to drop databases [E.g.:- drop database sandesha2_svr_db; drop database sandesha2_client_db;] but since my system is a fresh one, and no such databases exist, the script fails.
> 3. Therefore change the "mysql_schema.txt" where it drops the 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