[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by João Matos (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
João Matos edited comment on TEIIDDES-2913 at 9/7/16 1:16 PM:
--------------------------------------------------------------
Hi Barry,
thanks for the quick reply. Your solution worked, I am able to create the following table t:
SELECT
A."a b" AS """a b""", A.cd, A."xpto 123" AS """xpto 123""", A.x
FROM
(EXEC novosm.getTextFiles('a.csv')) AS f, TEXTTABLE(f.file COLUMNS "a b" string, cd string, "xpto 123" string, x string HEADER) AS A
However, I am not able of creating a second table that reads the one column ("a b") from the first one, e.g.:
SELECT
nvm.t."""a b""" AS """""a b"""""
FROM
nvm.t
I get the error:
Lexical error. Character is not a valid token: " : org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "VIEW test ( [*]\"[*] b\"" at line 3, column 9.
Lexical error. Character is not a valid token: "
at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "VIEW test ( [*]\"[*] b\"" at line 3, column 9.
Lexical error. Character is not a valid token: "
at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
... 13 more
am I missing something? Thanks
was (Author: jmatos):
Hi Barry,
thanks for the quick reply. Your solution worked, I am able to create the following table t:
SELECT
A."a b" AS """a b""", A.cd, A."xpto 123" AS """xpto 123""", A.x
FROM
(EXEC novosm.getTextFiles('a.csv')) AS f, TEXTTABLE(f.file COLUMNS "a b" string, cd string, "xpto 123" string, x string HEADER) AS A
However, I am not able of creating a second table that reads the one column ("a b") from the first one, e.g.:
SELECT
nvm.t."""a b"""
FROM
nvm.t
am I missing something? Thanks
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by João Matos (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
João Matos commented on TEIIDDES-2913:
--------------------------------------
Hi Barry,
thanks for the quick reply. Your solution worked, I am able to create the following table t:
SELECT
A."a b" AS """a b""", A.cd, A."xpto 123" AS """xpto 123""", A.x
FROM
(EXEC novosm.getTextFiles('a.csv')) AS f, TEXTTABLE(f.file COLUMNS "a b" string, cd string, "xpto 123" string, x string HEADER) AS A
However, I am not able of creating a second table that reads the one column ("a b") from the first one, e.g.:
SELECT
nvm.t."""a b"""
FROM
nvm.t
am I missing something? Thanks
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2913:
----------------------------------------
The current Designer is creating virtual table column names that are unquoted. The resulting SELECT SQL ends up with:
SELECT
A."a b", A.cd, A."xpto 123", A.x
Double quoting the "a b" and "xpto 123" column names in the properties editor, saving, then using the T-Editor reconciler to fix the SQL ends up with:
SELECT
A."a b" AS """a b""", A.cd, A."xpto 123" AS """xpto 123""", A.x
Preview data worked fine after those changes
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Steven Hawkins reassigned TEIIDDES-2913:
----------------------------------------
Assignee: (was: Steven Hawkins)
Teiid supports the use of a quoted identifier to define a text table column, which accounts for all cases except for when the header name has a '.' character. TEIID-3346 added an option to separately define the HEADER column name as a string literal, which can be used in any case.
TEIID-3346 support should be added to designer if it's not already there.
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2913) Special characters in column names when importing CSV files
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2913?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-4429 to TEIIDDES-2913:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2913 (was: TEIID-4429)
Affects Version/s: (was: 9.0.3)
> Special characters in column names when importing CSV files
> -----------------------------------------------------------
>
> Key: TEIIDDES-2913
> URL: https://issues.jboss.org/browse/TEIIDDES-2913
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Linux Centos VM, 9.0.3 With WildFly, TEIID Designer 10.1, JBDS 9.1.0 GA
> Reporter: João Matos
> Assignee: Steven Hawkins
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
>
> Hi,
> I've been dwelling with this problem for quite some time and still can't figure out what is wrong, can you help me out (thanks in advance)? Every time I import a CSV file with TEIID designer, in which the column names contain anything that is not a letter/number/underscore (e.g. a white space), I get the following exception when attempting to preview data:
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
> at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:776)
> at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
> at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:398)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:449)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a [*]b[*] string(" at line 3, column 11.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2912) NPE when selecting project in Create Relational Model from WS wizard
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2912?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2912:
---------------------------------------
Labels: (was: user)
> NPE when selecting project in Create Relational Model from WS wizard
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2912
> URL: https://issues.jboss.org/browse/TEIIDDES-2912
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Priority: Optional
> Attachments: Screenshot from 2016-09-06 14-53-25.png
>
>
> NPE is thrown in dialog _Creating Relational Model from Web Service_ when trying to select project (at 2nd page - Models Definition). This occours only when *+none+* project in Model Explorer was selected before import wizard. Combo box is filled with project name successfully, but immediately after that NPE is thrown. (see attachment)
> (note everything's ok if some project is selected before import wizard)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2912) NPE when selecting project in Create Relational Model from WS wizard
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2912?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2912:
---------------------------------------
Labels: user (was: )
> NPE when selecting project in Create Relational Model from WS wizard
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2912
> URL: https://issues.jboss.org/browse/TEIIDDES-2912
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Priority: Optional
> Attachments: Screenshot from 2016-09-06 14-53-25.png
>
>
> NPE is thrown in dialog _Creating Relational Model from Web Service_ when trying to select project (at 2nd page - Models Definition). This occours only when *+none+* project in Model Explorer was selected before import wizard. Combo box is filled with project name successfully, but immediately after that NPE is thrown. (see attachment)
> (note everything's ok if some project is selected before import wizard)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2912) NPE when selecting project in Create Relational Model from WS wizard
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2912?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2912:
---------------------------------------
Priority: Optional (was: Major)
> NPE when selecting project in Create Relational Model from WS wizard
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2912
> URL: https://issues.jboss.org/browse/TEIIDDES-2912
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Priority: Optional
> Attachments: Screenshot from 2016-09-06 14-53-25.png
>
>
> NPE is thrown in dialog _Creating Relational Model from Web Service_ when trying to select project (at 2nd page - Models Definition). This occours only when *+none+* project in Model Explorer was selected before import wizard. Combo box is filled with project name successfully, but immediately after that NPE is thrown. (see attachment)
> (note everything's ok if some project is selected before import wizard)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months
[JBoss JIRA] (TEIIDDES-2861) Import DDL option is confusing
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2861?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2861.
------------------------------------
Resolution: Rejected
[~van.halbert] There is a problem with importing dynamic VDB containing extension properties because it won't contain extension namespaces like you'd have when defining a complete DDL model definition. In addition, there's no way to determine the actual datatype of any of the extension values.
Confusion around DDL file and "ddl in -vdb.xml" is covered in earlier comment
> Import DDL option is confusing
> ------------------------------
>
> Key: TEIIDDES-2861
> URL: https://issues.jboss.org/browse/TEIIDDES-2861
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0.1
> Reporter: Van Halbert
> Attachments: jdg-remote-cache-mat-vdb.xml, portfolio-vdb.xml
>
>
> Have the following comments when trying to use the DDL importer to import a dynamic vdb:
> - It refers to everything as DDL, when dynamic vdb is not
> - the file chooser defaults to DDL, when maybe it should have an option for .xml
> - on the importer, there's a Mode type. When importing dynamic VDB's, this shouldn't apply, because the dynamic vdb can have both virtual and source models.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 7 months