[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2458:
----------------------------------------
Debugging JDBC Importer, there's a call in JdbcCatalogImpl.addSchemaChildren() to get schema children from SybDatabaseMetadata.getSchema() that's throwing an exception:
*java.sql.SQLException: JZ0SB: Parameter index out of range: 1.*
As a result, the schema isn't found and not set on the NIS.
> Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)
> -------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2458
> URL: https://issues.jboss.org/browse/TEIIDDES-2458
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.1
> Environment: JBDS: 8.0.2GA
> TD: 9.0.1.Final
> OS: Fedora 20
> java: oracle 1.7
> JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502)
> Sybase DB: ASE 15.0.3/EBF
> Reporter: Juraj Duráni
> Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png
>
>
> I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2497) Incorrect "Name in Source" when importing from JDBC Database using Informix
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2497?page=com.atlassian.jira.plu... ]
Ramesh Reddy updated TEIIDDES-2497:
-----------------------------------
Issue Type: Bug (was: Enhancement)
> Incorrect "Name in Source" when importing from JDBC Database using Informix
> ---------------------------------------------------------------------------
>
> Key: TEIIDDES-2497
> URL: https://issues.jboss.org/browse/TEIIDDES-2497
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Bruno Machado
> Assignee: Barry LaFond
> Labels: designer, informix, metadata, teiid
>
> When importing from JDBC Database using a Informix connection, an incorrect "Name in source" metadata is set as "catalog":"schema":"table-name" instead of "catalog":"schema"."table-name", the delimiter between schema and table-name is set to ':' but Informix uses '.'.
> The ':' character must be replaced by a '.' between schema and table name when importing informix tables using Import From JDBC Database.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2497) Incorrect "Name in Source" when importing from JDBC Database using Informix
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2497?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2497:
----------------------------------------
Do you know of a RH test informix DB available?
> Incorrect "Name in Source" when importing from JDBC Database using Informix
> ---------------------------------------------------------------------------
>
> Key: TEIIDDES-2497
> URL: https://issues.jboss.org/browse/TEIIDDES-2497
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Bruno Machado
> Assignee: Barry LaFond
> Labels: designer, informix, metadata, teiid
>
> When importing from JDBC Database using a Informix connection, an incorrect "Name in source" metadata is set as "catalog":"schema":"table-name" instead of "catalog":"schema"."table-name", the delimiter between schema and table-name is set to ':' but Informix uses '.'.
> The ':' character must be replaced by a '.' between schema and table name when importing informix tables using Import From JDBC Database.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2552) REST connection profile wizard creates URL with parameters in wrong order
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2552?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2552:
--------------------------------
Fix Version/s: 9.2
9.0.3
(was: 9.0.2 Beta2)
> REST connection profile wizard creates URL with parameters in wrong order
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2552
> URL: https://issues.jboss.org/browse/TEIIDDES-2552
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 9.2, 9.0.3
>
> Attachments: Newconnectionprofile_001.png
>
>
> When defining parameters for REST connection profile, they are added to the URL in the order they are defined. This results in wrong URL in case a Query parameter is defined before a URI parameter.
> The URI parameters should always be added to the URL before the Query parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2553) Changing parameter types in REST connection results in wrong URL
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2553?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2553:
--------------------------------
Fix Version/s: 9.2
9.0.3
(was: 9.0.2 Beta2)
> Changing parameter types in REST connection results in wrong URL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2553
> URL: https://issues.jboss.org/browse/TEIIDDES-2553
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Fix For: 9.2, 9.0.3
>
>
> Changing the type of a parameter in the REST connection profile causes the generated URL to be wrong. Also, the Preview URL is not updated after changing the type, only after some other action (testing connection, changing the default value etc).
> Furthermore, removing the paramters does not work if the type of the parameter has been changed.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2497) Incorrect "Name in Source" when importing from JDBC Database using Informix
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2497?page=com.atlassian.jira.plu... ]
Debbie Steigner commented on TEIIDDES-2497:
-------------------------------------------
Is there an eta on when this will be fixed?
> Incorrect "Name in Source" when importing from JDBC Database using Informix
> ---------------------------------------------------------------------------
>
> Key: TEIIDDES-2497
> URL: https://issues.jboss.org/browse/TEIIDDES-2497
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Bruno Machado
> Assignee: Barry LaFond
> Labels: designer, informix, metadata, teiid
>
> When importing from JDBC Database using a Informix connection, an incorrect "Name in source" metadata is set as "catalog":"schema":"table-name" instead of "catalog":"schema"."table-name", the delimiter between schema and table-name is set to ':' but Informix uses '.'.
> The ':' character must be replaced by a '.' between schema and table name when importing informix tables using Import From JDBC Database.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2553) Changing parameter types in REST connection results in wrong URL
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2553?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2553:
--------------------------------
Fix Version/s: 9.0.2 Beta2
> Changing parameter types in REST connection results in wrong URL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2553
> URL: https://issues.jboss.org/browse/TEIIDDES-2553
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Fix For: 9.0.2 Beta2
>
>
> Changing the type of a parameter in the REST connection profile causes the generated URL to be wrong. Also, the Preview URL is not updated after changing the type, only after some other action (testing connection, changing the default value etc).
> Furthermore, removing the paramters does not work if the type of the parameter has been changed.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2553) Changing parameter types in REST connection results in wrong URL
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2553?page=com.atlassian.jira.plu... ]
Ted Jones reassigned TEIIDDES-2553:
-----------------------------------
Assignee: Ted Jones
> Changing parameter types in REST connection results in wrong URL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2553
> URL: https://issues.jboss.org/browse/TEIIDDES-2553
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Fix For: 9.0.2 Beta2
>
>
> Changing the type of a parameter in the REST connection profile causes the generated URL to be wrong. Also, the Preview URL is not updated after changing the type, only after some other action (testing connection, changing the default value etc).
> Furthermore, removing the paramters does not work if the type of the parameter has been changed.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2552) REST connection profile wizard creates URL with parameters in wrong order
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2552?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-2552:
--------------------------------
Fix Version/s: 9.0.2 Beta2
> REST connection profile wizard creates URL with parameters in wrong order
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2552
> URL: https://issues.jboss.org/browse/TEIIDDES-2552
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 9.0.2 Beta2
>
> Attachments: Newconnectionprofile_001.png
>
>
> When defining parameters for REST connection profile, they are added to the URL in the order they are defined. This results in wrong URL in case a Query parameter is defined before a URI parameter.
> The URI parameters should always be added to the URL before the Query parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2552) REST connection profile wizard creates URL with parameters in wrong order
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2552?page=com.atlassian.jira.plu... ]
Ted Jones reassigned TEIIDDES-2552:
-----------------------------------
Assignee: Ted Jones
> REST connection profile wizard creates URL with parameters in wrong order
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2552
> URL: https://issues.jboss.org/browse/TEIIDDES-2552
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.2 Beta2
> Reporter: Andrej Šmigala
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 9.0.2 Beta2
>
> Attachments: Newconnectionprofile_001.png
>
>
> When defining parameters for REST connection profile, they are added to the URL in the order they are defined. This results in wrong URL in case a Query parameter is defined before a URI parameter.
> The URI parameters should always be added to the URL before the Query parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 6 months