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

["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.