db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-28) Capture and creation of non-table entities - constraints, triggers, stored procedures and others
Date Wed, 12 Oct 2005 09:39:06 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-28?page=comments#action_12331875 ] 

Thomas Dudziak commented on DDLUTILS-28:
----------------------------------------

I don't know, there is no platform independent way to support sequences, stored procedures
etc. And the aim of DdlUtils is to enable the app to be database independent. Besides, I'm
not sure, that I get enough info from the JDBC driver about these entities. Eg. I doubt that
the Oracle JDBC driver gives the definition of a stored procedure. And in the end, you can
always use Ant's sql task to execute database-specific commands.
However, there might be a few common cases that can be supported in a generic way across several
databases.
As for entities that are incompatible between database types, DdlUtils maps them (using default
mappings) to their JDBC counterparts (eg. JDBC types for database specific types), and for
these, adding support for overriding should be doable. At the Api level, this already possible
(though not documented yet in the user guide).


> Capture and creation of non-table entities - constraints, triggers, stored procedures
and others
> ------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-28
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-28
>      Project: DdlUtils
>         Type: New Feature
>  Environment: SQL Server, Oracle
>     Reporter: Peter Millington
>     Assignee: Thomas Dudziak

>
> Database build includes many non-table items - commonly constraints, triggers, stored
procedures and others which may be database dependant (Oracle sequences as an example).
> Even the the common entities are generally not transportable between database types.
 The schema should allow multiple versions of each item to be created, one per database type
which the user requires to support.
> Can the ddl-utils package use user-customisable sql templates to create non-standard
items from (new) generic XML tags?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message