You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Peter Millington (JIRA)" <ji...@apache.org> on 2005/10/12 11:23:11 UTC
[jira] Created: (DDLUTILS-28) Capture and creation of non-table entities - constraints, triggers, stored procedures and others
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
Assigned to: 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
[jira] Updated: (DDLUTILS-28) Capture and creation of non-table
entities - constraints, triggers, stored procedures and others
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-28?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Dudziak updated DDLUTILS-28:
-----------------------------------
Fix Version/s: (was: 1.1)
1.2
> Capture and creation of non-table entities - constraints, triggers, stored procedures and others
> ------------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-28
> URL: https://issues.apache.org/jira/browse/DDLUTILS-28
> Project: DdlUtils
> Issue Type: New Feature
> Components: Core (No specific database)
> Environment: SQL Server, Oracle
> Reporter: Peter Millington
> Assignee: Thomas Dudziak
> Fix For: 1.2
>
>
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DDLUTILS-28) Capture and creation of non-table
entities - constraints, triggers, stored procedures and others
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-28?page=all ]
Thomas Dudziak updated DDLUTILS-28:
-----------------------------------
Component: Core (No specific database)
> 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
> Components: Core (No specific database)
> Environment: SQL Server, Oracle
> Reporter: Peter Millington
> Assignee: Thomas Dudziak
> Fix For: 1.1
>
> 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
[jira] Commented: (DDLUTILS-28) Capture and creation of non-table entities - constraints, triggers, stored procedures and others
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ 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
[jira] Updated: (DDLUTILS-28) Capture and creation of non-table
entities - constraints, triggers, stored procedures and others
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-28?page=all ]
Thomas Dudziak updated DDLUTILS-28:
-----------------------------------
Fix Version: 1.1
> 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
> Fix For: 1.1
>
> 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
[jira] Commented: (DDLUTILS-28) Capture and creation of non-table
entities - constraints, triggers, stored procedures and others
Posted by "Achille Carette (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-28?page=comments#action_12370667 ]
Achille Carette commented on DDLUTILS-28:
-----------------------------------------
I would say that being independent of the database does not mean support only a (sub)set of common features. It means being able to flexibly adapt to various implementations.
This means that (for us at least), the schema definition file(s) should contain only once what is common to all databases (the database structure), but should also provide a way to define database-specific elements.
I see four points:
(1) What is to be defined in the schema dtd (for example, should the dtd define elements for sequences and stored procedures ?).
(1.1) The xml schema used is Turbine's one. What if DdlUtils needs more or different elements ? (DdlUtils needs informations an ORM does not)
(2) How to permit the inclusion of database-specific definitions in the schma definition file(s) ?
(3) How to provide a way to get the xml schema definition file(s) from an existing database, containing the non standard elements.
> 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