OR insert data to a MySQL table from CSV using Teiid. I already have the JDBC and flat-file connections in place and I can preview data from both tables in Teiid designer.

Much appreciated Stephen.

This is what I have:

1. A relational view model holding a table that has fields of interest (fields that hold records from two tables -MySQL and textfile-.

2. A select query on select tab - which works well when i hit preview data button

SELECT field1, field2

FROM table1

UNION ALL

SELECT filed1, field2

FROM table2

3. On insert tab, I have

CREATE VIRTUAL PROCEDURE

BEGIN

INSERT INTO table1 (field1,field2)

SELECT field1,field2

FROM table2

WHERE ......

No 3 has no errors

After the above, I don't know where to go to, in Teiid designer, to have the data inserted into MySQL

Thanks Ramesh, let me try it out.

Hi

I get the error below when i execute an insert query on VDB...any ideas....

TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Model_ltcperson: 1366 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: INSERT INTO `ltcdb_prod`.`ltcperson` (`ltcPersonID`, `FirstName`, `LastName`, `CreatedBy`, `CreatedDate`) VALUES ('9000', 'Usert', 'Testt', 'Morgan', '02122014')]

Cheers

Thanks Stephen and Ramesh.

I was able to insert data after trying on a local scaled down database as opposed to a remote MySQL complex MySQL.

Could be connection problems or validation issues.

i will find out.