[JBoss JIRA] (TEIIDDES-3040) Source function in a virtual view, it expects an Object type as the result
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3040?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3040:
-----------------------------------
Fix Version/s: 11.1
> Source function in a virtual view, it expects an Object type as the result
> --------------------------------------------------------------------------
>
> Key: TEIIDDES-3040
> URL: https://issues.jboss.org/browse/TEIIDDES-3040
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Colin Mondesir
> Assignee: Barry LaFond
> Fix For: 11.1, 11.0.2
>
> Attachments: example.zip
>
>
> On a physical model, I have created a Source Function INSTR with the following parameters:
> IN char1 string
> IN char2 string
> RETURN result Integer
> When I use this source function in a virtual view, it expects an Object type as the result of this function. No way to force with an Integer type. So I create an Object column to store this result. But then I create a VDB and I want to deploy it, it tells me that it expects a Integer result and not an Object.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-3044) Add new Model Editor tab
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3044?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3044:
-----------------------------------
Fix Version/s: 11.1
(was: 11.2)
> Add new Model Editor tab
> ------------------------
>
> Key: TEIIDDES-3044
> URL: https://issues.jboss.org/browse/TEIIDDES-3044
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Editors, Modeling
> Affects Versions: 11.1
> Reporter: Barry LaFond
> Priority: Critical
> Fix For: 11.1
>
> Attachments: Designer 11.1 New Features.pdf, create-data-service-action.png, create-data-service-dialog.png, new-designer-perspective.png
>
>
> Teiid Designer is an Eclipse application. We've gotten lots of feedback that the workflow is based on a developer paradigm and not necessarily a data-source/data-service paradigm.
> The Model Explorer/Tree view + Properties View + Description View paired up with the Diagram and Table Editor pages do not provide a coherent UI for editing models. Users are required to select an object in the tree or diagram in order to find out what actions are available for that object, whether a Model or a model child (table, view, column, etc.)
> One solution is to create a Model Editor page/tab which provides a more model-centric approach to editing a model and providing such actions.
> The attached screen cap shows an initial approach which displays a tree view of the model contents and associated Actions, Properties and Description editor tabs which allow managing the majority of the workflow actions and steps.
> Prototype KIT is available at: http://download.jboss.org/teiid/designer/11.0/teiid-designer-neon-prototy...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2880:
-----------------------------------
Fix Version/s: 11.1
> New preview not working with table that calls UDF function
> -----------------------------------------------------------
>
> Key: TEIIDDES-2880
> URL: https://issues.jboss.org/browse/TEIIDDES-2880
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Fix For: 11.1, 11.0.2
>
> Attachments: view.xmi
>
>
> I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this:
> {code:SQL}
> SELECT
> udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT
> FROM
> hsqldbParts.PARTS
> {code}
> When I hit Preview Data on that table, the dynamic VDB that is generated looks like this:
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1">
> <description>Importer VDB</description>
> <property name="UseConnectorMetadata" value="true" />
> <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" />
> <model name="view" type="VIRTUAL" visible="true">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW tab (
> NAME_WEIGHT string
> )
> AS
> select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS;
> ]]></metadata>
> </model>
> <model name="hsqldbParts" type="PHYSICAL" visible="true">
> <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" />
> <metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE PARTS (
> PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'),
> PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'),
> PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'),
> PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'),
> CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID)
> ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"')
> ]]></metadata>
> </model>
> </vdb>
> {code}
> If I see correctly, the UDF procedure is not in the dynamic VDB.
> I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved.
> But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function)
> View model attached
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-3046) Unable to preview data of file-based data source when the JNDI name already exist on the server runtime
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3046?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3046:
-----------------------------------
Fix Version/s: 11.1
> Unable to preview data of file-based data source when the JNDI name already exist on the server runtime
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-3046
> URL: https://issues.jboss.org/browse/TEIIDDES-3046
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: MacOS
> Red Hat JBoss Developer Studio 10.3.0.GA with JBoss Developer Studio Integration Stack 10.0.2 installed
> Reporter: Cojan van Ballegooijen
> Assignee: Barry LaFond
> Fix For: 11.1, 11.0.2
>
> Attachments: Screen Shot 2017-03-01 at 10.16.26.png, Screen Shot 2017-03-01 at 10.16.46.png
>
>
> If a data source is already created on the JDV server runtime unable to preview data on the models.
> Workaround is to add these models into a VDB, deploy/execute VDB but Preview data should work despite the fact that the datasource JNDI names already exists on the server side.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 5 months