-
1. Re: Insert multiple rows to datasource through Teiid
rareddy Feb 13, 2013 3:41 PM (in response to jane_lj)It if translator supports Bulk Inserts then it pushes as single command, if not supported then executed as multiple commands. See "supportsBulkUpdate" on ExecutionFactory class. Also see TestJDBCUpdateExecution class for example as to how JDBC translator is supporting it.
-
2. Re: Insert multiple rows to datasource through Teiid
shawkins Feb 13, 2013 3:50 PM (in response to rareddy)1 of 1 people found this helpfulbulk is the prefered, but if supportsBatchedUpdates is supported the engine will issue a org.teiid.language.BatchedUpdates command that contains multiple inserts, and then as Ramesh says it will revert to single row inserts.
When bulk is supported the pushdown insert will contain org.teiid.language.Parameter expressions in place of the values, which will reference the rows available from the org.teiid.language.BatchedCommand.getParameterValues().
-
3. Re: Insert multiple rows to datasource through Teiid
jane_lj Feb 14, 2013 3:57 PM (in response to jane_lj)Thanks a lot, Ramesh and steven.
I have taken a look at the code of TestJDBCUpdateExecution, it helps.
One more question here, if I set both supportsBatchedUpdates and supportBulkUpdate to false, what will happen? For this case, can my tranlator just handle single row insert?
Thanks.
-
4. Re: Insert multiple rows to datasource through Teiid
shawkins Feb 14, 2013 5:14 PM (in response to jane_lj)Yes, single row is the default.
Steve