7:34 a.m.
PostgreSQL is missing in the DDL export menu
--------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
With external materialization user/customer will generate DDL files for his DB system.
JBoss SOA Platform will ship with PostgreSQL support, but this DB system is missing in
menu Export->Teiid designer-> Data Definition language file. So customer has no way
how to generate correct DDL files for his use - customer have to create these files
manually.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:53 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) PostgreSQL is missing in the DDL export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Boris Belovic updated TEIIDDES-721:
-----------------------------------
Priority: Blocker (was: Major)
PostgreSQL is missing in the DDL export menu
--------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Priority: Blocker
With external materialization user/customer will generate DDL files for his DB system.
JBoss SOA Platform will ship with PostgreSQL support, but this DB system is missing in
menu Export->Teiid designer-> Data Definition language file. So customer has no way
how to generate correct DDL files for his use - customer have to create these files
manually.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:07 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supperted databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Boris Belovic updated TEIIDDES-721:
-----------------------------------
Summary: Several supperted databases missing in Teiid designer export menu (was:
PostgreSQL is missing in the DDL export menu)
Description:
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
was:With external materialization user/customer will generate DDL files for his DB
system. JBoss SOA Platform will ship with PostgreSQL support, but this DB system is
missing in menu Export->Teiid designer-> Data Definition language file. So customer
has no way how to generate correct DDL files for his use - customer have to create these
files manually.
Several supperted databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Priority: Blocker
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:15 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Boris Belovic updated TEIIDDES-721:
-----------------------------------
Summary: Several supported databases missing in Teiid designer export menu (was:
Several supperted databases missing in Teiid designer export menu)
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Priority: Blocker
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:32 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Boris Belovic commented on TEIIDDES-721:
----------------------------------------
Ok, I check this in JDBS 4 Beta 2 (was using Teiid 7.1), but anyway PostgreSQL is missing
in the list.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Priority: Blocker
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:14 a.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIIDDES-721:
--------------------------------------
some Postgres differences from MySQL:
Differences:
1. Creating primary key:
example:
postres: POLICYUID NUMERIC(10) NOT NULL CONSTRAINT PK_AUTHPOLICIES UNIQUE
where: PK_AUTHPOLICIES is a user assigned name
mysql: POLICYUID NUMERIC(10) NOT NULL PRIMARY KEY
2. Foreign key reference
example:
postgres: POLICYUID NUMERIC(10) NOT NULL CONSTRAINT FK_ATHPLCY_PLCYUID
REFERENCES AUTHPOLICIES (POLICYUID) ,
where: FK_ATHPLCY_PLCYUID is a user assigned name
mysql: POLICYUID NUMERIC(10) NOT NULL REFERENCES AUTHPOLICIES (POLICYUID) ,
3. Setting a default
example:
posgres: MULTI_SOURCED CHAR(1) DEFAULT ('0') NULL,
mysql: MULTI_SOURCED CHAR(1) DEFAULT '0',
But depending on everything that the xslt is trying to support, there are probably
others.
See: http://www.postgresql.org/docs/current/interactive/sql-createtable.html
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Priority: Blocker
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:38 a.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Barry LaFond updated TEIIDDES-721:
----------------------------------
Assignee: Barry LaFond
Fix Version/s: 7.1.1
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:02 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://jira.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plugin...
]
Barry LaFond commented on TEIIDDES-721:
---------------------------------------
The DDL export feature has been in existence for 8+ years and probably hasn't changed
much or been checked for updates for any of the currently supported databases.
Though the framework is pretty straight forward and allows for adding DB's just by
adding XSLT files there are a number of critical issues with data-type translations that
are KEY to making this a robust feature.
We would probably want to re-visit the framework and find some way to make it clearer how
to introduce new DB's to the mix and bring data-type conversion into a more visible,
understandable and implementable framework.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://jira.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:50 p.m.
New subject: [JBoss JIRA] Work started: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Work on TEIIDDES-721 started by Barry LaFond.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:52 p.m.
New subject: [JBoss JIRA] Work logged: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond logged work on TEIIDDES-721:
-----------------------------------------
Author: Barry LaFond
Created on: 04/Jan/11 1:51 PM
Start Date: 04/Jan/11 1:49 PM
Worklog Time Spent: 3 hours
Work Description: Added PostgreSQL xslt. Also fixed importing from postgres that was
allowing invalid character lengths and numeric precisions beyond both Teiid's
capabilities and Postgres
Issue Time Tracking
-------------------
Remaining Estimate: 0 minutes
Time Spent: 3 hours
Worklog Id: (was: 12423640)
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1, 7.3
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:52 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-721:
----------------------------------
Fix Version/s: 7.3
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1, 7.3
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:54 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-721:
----------------------------------
Fix Version/s: (was: 7.1.1)
Added PostgreSQL Export support.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.3
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:54 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-721:
---------------------------------------
This is all we'll do for 7.1.1. Pushing to 7.3 to add Sybase and maybe other DB
support
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.3
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:06 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond updated TEIIDDES-721:
----------------------------------
Fix Version/s: 7.1.1
(was: 7.3)
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:08 p.m.
New subject: [JBoss JIRA] Resolved: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond resolved TEIIDDES-721.
-----------------------------------
Resolution: Done
Sybase is covered with TEIIDDES_731, so this issue is resolved.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:08 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-721) Several supported databases missing in Teiid designer export menu
[
https://issues.jboss.org/browse/TEIIDDES-721?page=com.atlassian.jira.plug...
]
Barry LaFond commented on TEIIDDES-721:
---------------------------------------
Note that the Labels for each DDL export option have changed to NOT include the version
number. Each description contains the base version (i.e. 7.x) and above.
Several supported databases missing in Teiid designer export menu
------------------------------------------------------------------
Key: TEIIDDES-721
URL: https://issues.jboss.org/browse/TEIIDDES-721
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1
Reporter: Boris Belovic
Assignee: Barry LaFond
Priority: Blocker
Fix For: 7.1.1
Time Spent: 3 hours
Remaining Estimate: 0 minutes
With external materialization user / customer generates DDL files for creating
materialized tables. These files contain SQL statements which will create tables with all
necessary columns. Teiid designer misses support for several DB engines, which are
supported with SOA-P 5.1. This causes that appropriate DDL files can't be generated
for these databases.
Missing databases are:
PostgreSQL 8.2 and 8.3
DB2 - 9.7
Oracle 10g and Oracle 11g
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5116
days inactive
5152
days old
teiid-designer-issues@lists.jboss.org
15 comments
3 participants
participants (3)
-
Barry LaFond (JIRA) -
Boris Belovic (JIRA)
-
Van Halbert (JIRA)