You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Eric Cournarie (JIRA)" <em...@incubator.apache.org> on 2011/02/01 09:07:28 UTC
[jira] Created: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
---------------------------------------------------------------------
Key: EMPIREDB-101
URL: https://issues.apache.org/jira/browse/EMPIREDB-101
Project: Empire-DB
Issue Type: Bug
Components: Core
Affects Versions: empire-db-2.0.6-incubating
Reporter: Eric Cournarie
To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Closed: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Posted by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis De Brabandere closed EMPIREDB-101.
------------------------------------------
Resolution: Fixed
I added this IF NOT EXISTS, don't think we need a argument for that
> Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
> ---------------------------------------------------------------------
>
> Key: EMPIREDB-101
> URL: https://issues.apache.org/jira/browse/EMPIREDB-101
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.6-incubating
> Reporter: Eric Cournarie
> Assignee: Francis De Brabandere
> Fix For: empire-db-2.1.0-incubating
>
>
> To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Posted by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989089#comment-12989089 ]
Francis De Brabandere commented on EMPIREDB-101:
------------------------------------------------
Not sure about what we are talking about here. Would you mind posting the code where you have this issue?
> Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
> ---------------------------------------------------------------------
>
> Key: EMPIREDB-101
> URL: https://issues.apache.org/jira/browse/EMPIREDB-101
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.6-incubating
> Reporter: Eric Cournarie
>
> To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Posted by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis De Brabandere updated EMPIREDB-101:
-------------------------------------------
Fix Version/s: empire-db-2.1.0-incubating
> Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
> ---------------------------------------------------------------------
>
> Key: EMPIREDB-101
> URL: https://issues.apache.org/jira/browse/EMPIREDB-101
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.6-incubating
> Reporter: Eric Cournarie
> Fix For: empire-db-2.1.0-incubating
>
>
> To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Posted by "Francis De Brabandere (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Francis De Brabandere reassigned EMPIREDB-101:
----------------------------------------------
Assignee: Francis De Brabandere
> Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
> ---------------------------------------------------------------------
>
> Key: EMPIREDB-101
> URL: https://issues.apache.org/jira/browse/EMPIREDB-101
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.6-incubating
> Reporter: Eric Cournarie
> Assignee: Francis De Brabandere
> Fix For: empire-db-2.1.0-incubating
>
>
> To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (EMPIREDB-101) Create DDL Script on MySQL should
state CREATE DATABASE IF NOT EXISTS
Posted by "Eric Cournarie (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12989237#comment-12989237 ]
Eric Cournarie commented on EMPIREDB-101:
-----------------------------------------
When connecting to MySQL, the schema should have been created before. The URL is something like jdbc:mysql://localhost:3306/testing, where testing is my schema name.
If I use getCreateDDLScript to create the tables, the script adds the CREATE DATABASE statement, which fails if you do not specifiy IF NOT EXIST. The other solution would be the getCreateDDLScript method to take another boolean argument requesting to include or not the create database statement.
You may check the sample attachment I have included in DBEMPIRE-100.
> Create DDL Script on MySQL should state CREATE DATABASE IF NOT EXISTS
> ---------------------------------------------------------------------
>
> Key: EMPIREDB-101
> URL: https://issues.apache.org/jira/browse/EMPIREDB-101
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.0.6-incubating
> Reporter: Eric Cournarie
>
> To connect to MySQL, the schema should be created first. So when using getCreateDDLScript, it fails complaining the schema already exist. Adding IF NOT EXIST solves the problem.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira