[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-89) Relatively simple/useful feature request within SchemaExport...

[<leg...@at...>]

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Thu, 11 Dec 2003 12:58 AM

Use SchemaUpdate
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-89


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-89
    Summary: Relatively simple/useful feature request within SchemaExport...
       Type: New Feature

     Status: Closed
   Priority: Minor
 Resolution: REJECTED

    Project: Hibernate2
 Components: 
             toolset
   Versions:
             2.0rc2

   Assignee: 
   Reporter: Alex Lorbeer

    Created: Mon, 19 May 2003 5:19 PM
    Updated: Thu, 11 Dec 2003 12:58 AM

Description:
I have run into somewhat of a "blocker" while using the SchemaExport tool...

The project I am working on deals with a lot of dynamically generated tables. To avoid name collisions between clients, different schemas are created to hold each client's generated tables. There are also a set of non-dynamic tables that exist in the "global" schema that each client schema references.

I am using Hibernate mapping files and the SchemaExport tool to create all of the above mentioned tables. The problem is, I don't want to build the ENTIRE set of tables upon the addition of a new client. It seems that the SchemaExport tool doesn't allow for the generation of SPECIFIC tables... it always assumes you need to generate the ENTIRE set of tables. Also, it would be VERY useful to be able to specify the target schema name upon the execution of SchemaExport.

Could there be an additional set of methods in SchemaExport to support this? For example...

    // Create the specified "qualified" tables names (and associated indexes, foreign key constraints, etc...).
    public void create(boolean script, boolean export, List tableNames)
    throws HibernateException;

    // Create the specified "unqualified" tables names (and associated indexes, foreign key constraints, etc...) within the specified schema.
    public void create(boolean script, boolean export, List tableNames, String schemaName)
    throws HibernateException;

    // Drop the specified "qualified" tables names (and associated indexes, foreign key constraints, etc...).
    public void drop(boolean script, boolean export, List tablesNames)
    throws HibernateException;

    // Drop the specified "unqualified" tables names (and associated indexes, foreign key constraints, etc...) within the specified schema.
    public void drop(boolean script, boolean export, String schemaName, List tablesNames)
    throws HibernateException;

    // Drop all generated tables (and associated indexes, foreign key constraints, etc...) within the specified schema.
    public void drop(boolean script, boolean export, String schemaName)
    throws HibernateException;

Thank you!


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira