You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "David Beer (JIRA)" <ji...@apache.org> on 2009/02/19 23:54:01 UTC

[jira] Created: (OPENJPA-929) Scheam generation from schema tool

Scheam generation from schema tool
----------------------------------

                 Key: OPENJPA-929
                 URL: https://issues.apache.org/jira/browse/OPENJPA-929
             Project: OpenJPA
          Issue Type: New Feature
    Affects Versions: 1.1.0
            Reporter: David Beer


when using the openjpa tool and specifying the schema it would be nice if the schema generation tool could create the schema in the database if it doesn't exist.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (OPENJPA-929) Scheam generation from schema tool

Posted by "Milosz Tylenda (JIRA)" <ji...@apache.org>.

    [ https://issues.apache.org/jira/browse/OPENJPA-929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675533#action_12675533 ] 

Milosz Tylenda commented on OPENJPA-929:
----------------------------------------

A few notes for potential implementor:
- DB2 and Derby create schema implicitly if CREATE TABLE refers to it.
- PostgreSQL needs explicit CREATE SCHEMA.
- On Oracle a schema is in fact a user name.
- MySQL does not support schemas. In CREATE TABLE schema.table(...) "schema" is a database name.
- Firebird does not support schemas and seems to reject CREATE TABLE schema.table(...).


> Scheam generation from schema tool
> ----------------------------------
>
>                 Key: OPENJPA-929
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-929
>             Project: OpenJPA
>          Issue Type: New Feature
>    Affects Versions: 1.1.0
>            Reporter: David Beer
>
> when using the openjpa tool and specifying the schema it would be nice if the schema generation tool could create the schema in the database if it doesn't exist.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.