[JBoss JIRA] (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-987?page=com.atlassian.jira.plug... ]
Matus Makovy closed TEIIDDES-987.
---------------------------------
TD JIRA Clean up - resultion is Out of date, so I am closing this issue
> Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-987
> URL: https://issues.jboss.org/browse/TEIIDDES-987
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Editors, Transformations
> Affects Versions: 7.4
> Reporter: Barry LaFond
> Fix For: Future
>
>
> Designer includes "Generate xxxx procedures" options in the New Model Wizard.
> Also have a RestEasy use-case that requires getXXXX virtual procedures that contain SQL like:
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT XMLELEMENT(NAME parts, XMLAGG(XMLELEMENT(NAME part, XMLFOREST(VirtualParts_Supplier.PARTS.PART_ID, VirtualParts_Supplier.PARTS.PART_NAME, VirtualParts_Supplier.PARTS.PART_COLOR, VirtualParts_Supplier.PARTS.PART_WEIGHT)))) AS result FROM VirtualParts_Supplier.PARTS WHERE VirtualParts_Supplier.getParts.partId_in = VirtualParts_Supplier.PARTS.PART_ID;
> END
> Would be nice to have a framework where "wizards" can be accessed to create/edit the content of this SQL if the basic structure is a Set Query (SELECT * FROM XXX)for these specific use-cases.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 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:
--------------------------------------
I tried versions 10.0.0.Beta1 and 10.0.0.Beta3 of TEIID Designer and this problem does not occur. Apparently the bug was introduced afterwards.
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 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:
--------------------------------------
I don't think so, all my steps are enumerated above.
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 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 commented on TEIIDDES-2913:
------------------------------------------
I'm asking did you create the DDL, or was Designer doing that in response to you doing a preview on a view?
You should be able to easily define a view in Designer with the SQL you are showing above - just add a view to the model and paste the SQL into the transformation editor.
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 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 [~shawkins],
I'm not sure I understood your question. After I submitted this issue, Barry mentioned that previewing works fine if we escape the double-quoted strings, e.g.:
SELECT
A."a b" AS """a b""", A.cd, A."xpto 123" AS """xpto 123""", A.x
FROM
(EXEC dummy_sourcemodel.getTextFiles('a.csv')) AS f, TEXTTABLE(f.file COLUMNS "a b" string, cd string, "xpto 123" string, x string HEADER) AS A
Although that works fine, I was wondering how do I create a new view/table that has one column from table A (e.g. a new table B that exposes column "a b" of table A)
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2838) Setting connection profile to imported model won't set data source (issues with Preview)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2838?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2838.
------------------------------------
Resolution: Done
10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/53dc71ec0e656e4cb...
* Added check for empty JNDI during set connection profile. If NULL
pop-up dialog to set it... or keep null
* now allows JNDI name to be empty (null)
* setting connection profile props removes the JNDI name, so now
caching if not null and re-setting it.
> Setting connection profile to imported model won't set data source (issues with Preview)
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2838
> URL: https://issues.jboss.org/browse/TEIIDDES-2838
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.2
>
> Attachments: Screen Shot 2016-05-09 at 16.35.06.png, Screen Shot 2016-05-09 at 16.54.45.png
>
>
> I imported an existing project into TD with 2 source models and 1 view model.
> After I set a connection profile to source model (via Modeling -> Set connection profile) it appears that Data Source is not set. As a result of this when I hit preview (Modeling -> Preview data) on some table in this model, it fails. Because the jndi-name in the dynamic vdb is set to null.
> See screenshots
> I am setting the priority to critical, because this used to work before.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 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 edited comment on TEIIDDES-2913 at 9/8/16 10:37 AM:
-------------------------------------------------------------------
[~jmatos] The exception you are showing is coming from a view definition that contains invalid escaping. The snippet shows *VIEW test ( \"* which should not be using \ escaping. How was this DDL created?
was (Author: shawkins):
[~jmatos] The exception you are showing is coming from a view definition that contains invalid escaping. The snippet shows *VIEW test ( \"* which should be using \ escaping. How was this DDL created?
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 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 commented on TEIIDDES-2913:
------------------------------------------
[~jmatos] The exception you are showing is coming from a view definition that contains invalid escaping. The snippet shows *VIEW test ( \"* which should be using \ escaping. How was this DDL created?
> 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: Barry LaFond
> Labels: QueryParserException, TEIID30386, TEIID31100, csv, designer, import, jbds, preview, teiid, wildfly
> Fix For: 10.0.2
>
>
> 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)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2585) Teiid designer giving String index out of range
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2585?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2585.
----------------------------------
This works with TD 10.0.2.Alpha1.
I'll close the issue.
TD JIRA clean up
> Teiid designer giving String index out of range
> -----------------------------------------------
>
> Key: TEIIDDES-2585
> URL: https://issues.jboss.org/browse/TEIIDDES-2585
> Project: Teiid Designer
> Issue Type: Bug
> Environment: Windows 7 with teiid 8.11.0.Beta3
> Reporter: Jayesh Garg
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 9.1, 9.2
>
> Attachments: parts-project-example.zip
>
>
> I am using Teiid Designer version 9.1.0(Both Eclipse and JBDS) along with Teiid Beta version teiid-8.11.0.Beta3. I just opened an example project PartsProject.zip(attached) and it starts giving me the below error. I am not sure what is wrong here. Can you please guide?
>
> java.lang.StringIndexOutOfBoundsException: String index out of range: 1
> at java.lang.String.charAt(String.java:658)
> at java.util.regex.Matcher.appendReplacement(Matcher.java:762)
> at java.util.regex.Matcher.replaceAll(Matcher.java:906)
> at java.lang.String.replaceAll(String.java:2162)
> at org.teiid.query.metadata.SystemMetadata.<init>(SystemMetadata.java:90)
> at org.teiid.query.metadata.SystemMetadata.getInstance(SystemMetadata.java:66)
> at org.teiid.query.function.metadata.FunctionMetadataValidator.validateFunctionMethods(FunctionMetadataValidator.java:72)
> at org.teiid.query.function.SystemFunctionManager.getSystemFunctions(SystemFunctionManager.java:77)
> at org.teiid.runtime.client.query.QueryService.createFunctionLibrary(QueryService.java:137)
> at org.teiid.designer.udf.UdfManager.getSystemFunctionLibrary(UdfManager.java:372)
> at org.teiid.query.ui.sqleditor.sql.SqlSyntax.init(SqlSyntax.java:93)
> at org.teiid.query.ui.sqleditor.sql.SqlSyntax.<init>(SqlSyntax.java:61)
> at org.teiid.query.ui.sqleditor.sql.SqlCompletionProcessor.<init>(SqlCompletionProcessor.java:39)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlSourceViewerConfiguration.getContentAssistant(SqlSourceViewerConfiguration.java:64)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlTextViewer.<init>(SqlTextViewer.java:84)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlDisplayPanel.init(SqlDisplayPanel.java:75)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlDisplayPanel.<init>(SqlDisplayPanel.java:60)
> at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.createDialogArea(AbstractLanguageObjectBuilder.java:257)
> at org.eclipse.jface.dialogs.Dialog.createContents(Dialog.java:768)
> at org.eclipse.jface.window.Window.create(Window.java:435)
> at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1101)
> at org.teiid.designer.ui.common.widget.Dialog.create(Dialog.java:109)
> at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.create(AbstractLanguageObjectBuilder.java:114)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.getExpressionBuilder(SqlEditorPanel.java:1149)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.showExpressionBuilder(SqlEditorPanel.java:1196)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanelWrapper.showExpressionBuilder(SqlEditorPanelWrapper.java:123)
> at org.teiid.designer.transformation.ui.editors.sqleditor.actions.LaunchExpressionBuilder.doRun(LaunchExpressionBuilder.java:50)
> at org.teiid.designer.ui.common.actions.AbstractAction$1.run(AbstractAction.java:544)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2$1.run(UiBusyIndicator.java:206)
> at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
> at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
> at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.executeRunnable(UiBusyIndicator.java:227)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhileInternal(UiBusyIndicator.java:159)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator.showWhile(UiBusyIndicator.java:116)
> at org.teiid.designer.ui.common.actions.AbstractAction.run(AbstractAction.java:547)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:519)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)
> at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:462)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:135)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months