[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3827.
---------------------------------
> multi-source view insert throwing TEIID30492 error
> --------------------------------------------------
>
> Key: TEIID-3827
> URL: https://issues.jboss.org/browse/TEIID-3827
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.3
> Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> MySQL 5.7 and Postgres 9.4
> 64-bit Windows 7 environment
> Reporter: Steve Tran
> Assignee: Steven Hawkins
> Fix For: 8.12.3, 8.13
>
> Attachments: joined_vdb.vdb
>
>
> I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error.
> {quote}
> insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345)
> org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement.
> {quote}
> I updated my INSERT tab on the EBL transformation page with the following.
> {code}FOR EACH ROW
> BEGIN ATOMIC
> INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint);
> INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring);
> END
> {code}
> Postgres table
> {code}
> CREATE TABLE testp
> (
> idtestp integer NOT NULL,
> randomint integer,
> CONSTRAINT pk_id PRIMARY KEY (idtestp)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE testp
> OWNER TO postgres;
> {code}
> MySQL table
> {code}
> CREATE TABLE `testm` (
> `idtestm` int(11) NOT NULL AUTO_INCREMENT,
> `randomstring` varchar(45) DEFAULT NULL,
> PRIMARY KEY (`idtestm`),
> UNIQUE KEY `idtestm_UNIQUE` (`idtestm`)
> ) ENGINE=InnoDB DEFAULT CHARSET=tis620;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIID-3036) Update CXF to current version (3.0.0)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3036?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3036.
---------------------------------
> Update CXF to current version (3.0.0)
> -------------------------------------
>
> Key: TEIID-3036
> URL: https://issues.jboss.org/browse/TEIID-3036
> Project: Teiid
> Issue Type: Sub-task
> Components: Embedded
> Affects Versions: 8.8
> Reporter: Gary Gregory
> Assignee: Ramesh Reddy
> Fix For: 8.13
>
>
> In the same vein as TEIID-3030, we embed CXF and Teiid in our server. We use CXF 2.7.10 and are about to update to 3.0.0. At worse, we'll go to 2.7.11 as an interim step to 3.0.0.
> Teiid embedded delivers CXF 2.6.6 for web services support.
> It would be great if we could get Teiid to the latest and greatest from CXF so we can all live in the same space without being forced to deal with any incompatibilities or class loader hacks.
> Thank you,
> Gary
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months