[JBoss JIRA] (TEIIDDES-2859) DDL doesn't contain INSERT and DELETE transformation
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2859:
--------------------------------------
Summary: DDL doesn't contain INSERT and DELETE transformation
Key: TEIIDDES-2859
URL: https://issues.jboss.org/browse/TEIIDDES-2859
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs, Import/Export, Transformations
Affects Versions: 10.0.1
Environment: Fedora 23
Reporter: Matej Kralik
Attachments: RestProject.zip
When I want export view model to the DDL, DLL doesn't contain INSERT and UPDATE transformation which are in the view table.
I looked at the [documentation|https://docs.jboss.org/author/display/teiid812final/DDL+Met...] and in my opinion, DDL should contain two triggers.
CREATE TRIGGER ON ProductsInfo INSTEAD OF INSERT AS
<transformation>
and
CREATE TRIGGER ON ProductsInfo INSTEAD OF DELETE AS
<transformation>
When I write this trigger on the DDL, teiid DDL importer ignores them
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2858) Column whose have specific name in not correctly parsed in the DDL
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2858:
--------------------------------------
Summary: Column whose have specific name in not correctly parsed in the DDL
Key: TEIIDDES-2858
URL: https://issues.jboss.org/browse/TEIIDDES-2858
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview, Dynamic VDBs
Affects Versions: 10.0.1
Environment: Fedora 23
Reporter: Matej Kralik
Attachments: remoteXML.zip, screenshot1.png, screenshot2.png
When I wanted preview date from the table which contains column with specific name, server shows me this error:
TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9.
Was expecting: "constraint" | "foreign" | "primary" | "unique" | id
I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks.
"YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE')
When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2)
A similar situation is when I generated dynamic VDB.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2852) Import from Infinispan issue
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2852?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2852:
-----------------------------------
Fix Version/s: 10.0.2
> Import from Infinispan issue
> ----------------------------
>
> Key: TEIIDDES-2852
> URL: https://issues.jboss.org/browse/TEIIDDES-2852
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
> Attachments: Screen Shot 2016-06-03 at 15.38.12.png, Screen Shot 2016-06-03 at 15.38.17.png, Screen Shot 2016-06-06 at 14.51.05 (3).png
>
>
> If I want to import from Infinispan (remote-cache) using Teiid Connection import in TD and I have a resource adapter defined like this:
> {code:xml}
> <resource-adapter id="infinispan-remote-cache-ds">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <transaction-support>LocalTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSL" enabled="true" use-java-context="true" pool-name="infinispan-remote-cache-ds">
> <config-property name="ProtobufDefinitionFile">
> /org/jboss/qe/jdg/remote/protobuf/SmallA.proto
> </config-property>
> <config-property name="RemoteServerList">
> dvqe01.mw.lab.eng.bos.redhat.com:11322
> </config-property>
> <config-property name="MessageMarshallers">
> org.jboss.qe.jdg.pojo.SmallA:org.jboss.qe.jdg.remote.marshaller.SmallAMarshaller
> </config-property>
> <config-property name="CacheTypeMap">
> smallARemotecache:org.jboss.qe.jdg.pojo.SmallA;intKey
> </config-property>
> <config-property name="Module">
> org.jboss.qe.jdg.pojos
> </config-property>
> <config-property name="MessageDescriptor">
> org.jboss.qe.jdg.remote.protobuf.SmallA
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> I am getting this error in TD - see attached screenshot.
> And I cannot continue through the wizard.
> I have to add another resource adapter that works like a driver for the previous one. The configuration looks like this:
> {code:xml}
> <resource-adapter id="infinispan-remote-driver">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> </resource-adapter>
> {code}
> After adding this^ "driver" everything works.
> Is this a TD bug? or is it supposed to work this way ?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2852) Import from Infinispan issue
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2852?page=com.atlassian.jira.plu... ]
Van Halbert reassigned TEIIDDES-2852:
-------------------------------------
Assignee: Barry LaFond
> Import from Infinispan issue
> ----------------------------
>
> Key: TEIIDDES-2852
> URL: https://issues.jboss.org/browse/TEIIDDES-2852
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.1
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Attachments: Screen Shot 2016-06-03 at 15.38.12.png, Screen Shot 2016-06-03 at 15.38.17.png, Screen Shot 2016-06-06 at 14.51.05 (3).png
>
>
> If I want to import from Infinispan (remote-cache) using Teiid Connection import in TD and I have a resource adapter defined like this:
> {code:xml}
> <resource-adapter id="infinispan-remote-cache-ds">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <transaction-support>LocalTransaction</transaction-support>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSL" enabled="true" use-java-context="true" pool-name="infinispan-remote-cache-ds">
> <config-property name="ProtobufDefinitionFile">
> /org/jboss/qe/jdg/remote/protobuf/SmallA.proto
> </config-property>
> <config-property name="RemoteServerList">
> dvqe01.mw.lab.eng.bos.redhat.com:11322
> </config-property>
> <config-property name="MessageMarshallers">
> org.jboss.qe.jdg.pojo.SmallA:org.jboss.qe.jdg.remote.marshaller.SmallAMarshaller
> </config-property>
> <config-property name="CacheTypeMap">
> smallARemotecache:org.jboss.qe.jdg.pojo.SmallA;intKey
> </config-property>
> <config-property name="Module">
> org.jboss.qe.jdg.pojos
> </config-property>
> <config-property name="MessageDescriptor">
> org.jboss.qe.jdg.remote.protobuf.SmallA
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> I am getting this error in TD - see attached screenshot.
> And I cannot continue through the wizard.
> I have to add another resource adapter that works like a driver for the previous one. The configuration looks like this:
> {code:xml}
> <resource-adapter id="infinispan-remote-driver">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> </resource-adapter>
> {code}
> After adding this^ "driver" everything works.
> Is this a TD bug? or is it supposed to work this way ?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2857) Data Roles Editor creating duplicate rows
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2857?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2857:
----------------------------------------
[~sqtran] This was fixed in 10.0 via TEIIDDES-2821 but not backported/included in 9.0.7
> Data Roles Editor creating duplicate rows
> -----------------------------------------
>
> Key: TEIIDDES-2857
> URL: https://issues.jboss.org/browse/TEIIDDES-2857
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6
> Environment: Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> 64-bit Windows 7
> Reporter: Steve Tran
> Attachments: Capture.PNG
>
>
> Editing a role in the VDB Role Editor results in duplicate roles being created. Looks like a rendering issue only since closing and reopening the VDB editor seems to display the correct number of rows for the data roles.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2857) Data Roles Editor creating duplicate rows
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2857?page=com.atlassian.jira.plu... ]
Steve Tran commented on TEIIDDES-2857:
--------------------------------------
Duplicates/Relates to an existing ticket. According to the older ticket, it should have been already fixed, but that's not the behavior I'm seeing in the latest 9.0.6 version.
> Data Roles Editor creating duplicate rows
> -----------------------------------------
>
> Key: TEIIDDES-2857
> URL: https://issues.jboss.org/browse/TEIIDDES-2857
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6
> Environment: Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> 64-bit Windows 7
> Reporter: Steve Tran
> Attachments: Capture.PNG
>
>
> Editing a role in the VDB Role Editor results in duplicate roles being created. Looks like a rendering issue only since closing and reopening the VDB editor seems to display the correct number of rows for the data roles.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2857) Data Roles Editor creating duplicate rows
by Steve Tran (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2857?page=com.atlassian.jira.plu... ]
Steve Tran updated TEIIDDES-2857:
---------------------------------
Attachment: Capture.PNG
> Data Roles Editor creating duplicate rows
> -----------------------------------------
>
> Key: TEIIDDES-2857
> URL: https://issues.jboss.org/browse/TEIIDDES-2857
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.6
> Environment: Teiid Designer 9.0.6.Final-v20160316-1409-B1242 org.teiid.designer.feature.feature.group JBoss by Red Hat, Inc.
> 64-bit Windows 7
> Reporter: Steve Tran
> Attachments: Capture.PNG
>
>
> Editing a role in the VDB Role Editor results in duplicate roles being created. Looks like a rendering issue only since closing and reopening the VDB editor seems to display the correct number of rows for the data roles.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months