[JBoss JIRA] (TEIIDDES-2493) Check for spaces in the parent directory Flat File connection importer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2493?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2493.
------------------------------------
Assignee: Barry LaFond (was: Mark Drilling)
Resolution: Done
Resolved as part of TEIIDDES-2795 via a new validation rule that checks for spaces in URL properties in source models.
> Check for spaces in the parent directory Flat File connection importer
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2493
> URL: https://issues.jboss.org/browse/TEIIDDES-2493
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 11.0.2
>
>
> Add a check to make sure there are no spaces in the ParentDirectory or root directory path when Flat File Connection Profile is chosen.
> ====================
> The problem is manifested on the server when attempting to query the datasource. On datasource creation, the resource adapter is written to the standalone.xml like this.
> {code:java}
> <config-property name="ParentDirectory">
> /home/mdrilling/My Dir/data
> </config-property>
> {code}
> The embedded space in the ParentDirectory property value is problematic.
> Need to determine whether to (1) disallow a path with spaces or (2) allow it, replacing the space with the appropriate control code ie {code:java} {code} - like this
> {code:java}
> <config-property name="ParentDirectory">
> /home/mdrilling/My Dir/data
> </config-property>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-3015) Importing Flat File with "-" character in one column of the header
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3015?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-3015.
------------------------------------
Resolution: Done
11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/e7fcd2a266753c60b...
> Importing Flat File with "-" character in one column of the header
> -------------------------------------------------------------------
>
> Key: TEIIDDES-3015
> URL: https://issues.jboss.org/browse/TEIIDDES-3015
> Project: Teiid Designer
> Issue Type: Bug
> Environment: CentOs 7 + Teiid 9.1.2 with Wildfly 10.0.0.Final + Eclipse Neon with Designer 11.
> Reporter: Pedro Inácio
> Assignee: Barry LaFond
> Fix For: 11.0.2
>
>
> Trying to create a simple Flat File View Model from aCSV file with the following content:
> {code:java}
> "a-a","b"
> 1,2
> 3,4
> {code}
> Teiid server gives the following exception
> {noformat}
> [org.teiid.RUNTIME] (Worker6_async-teiid-threads6) TEIID50036 VDB PREVIEW-80ce0d21-f22d-431f-bd12-89ac57ac9418.1 model "ViewModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10.
> 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[*]-[*]a string" at line 3, column 10.
> 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:798)
> 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:360)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:411)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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[*]-[*]a string" at line 3, column 10.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-3015) Importing Flat File with "-" character in one column of the header
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3015?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-3015:
--------------------------------------
Assignee: Barry LaFond
> Importing Flat File with "-" character in one column of the header
> -------------------------------------------------------------------
>
> Key: TEIIDDES-3015
> URL: https://issues.jboss.org/browse/TEIIDDES-3015
> Project: Teiid Designer
> Issue Type: Bug
> Environment: CentOs 7 + Teiid 9.1.2 with Wildfly 10.0.0.Final + Eclipse Neon with Designer 11.
> Reporter: Pedro Inácio
> Assignee: Barry LaFond
> Fix For: 11.0.2
>
>
> Trying to create a simple Flat File View Model from aCSV file with the following content:
> {code:java}
> "a-a","b"
> 1,2
> 3,4
> {code}
> Teiid server gives the following exception
> {noformat}
> [org.teiid.RUNTIME] (Worker6_async-teiid-threads6) TEIID50036 VDB PREVIEW-80ce0d21-f22d-431f-bd12-89ac57ac9418.1 model "ViewModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10.
> 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[*]-[*]a string" at line 3, column 10.
> 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:798)
> 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:360)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:411)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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[*]-[*]a string" at line 3, column 10.
> Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...
> at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
> ... 13 more
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months