[teiid-issues] [JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
Filip Elias (JIRA)
issues at jboss.org
Tue Nov 25 10:16:40 EST 2014
[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13022801#comment-13022801 ]
Filip Elias commented on TEIID-3216:
------------------------------------
Currently I add into the update count array the number of actual updated rows + I log warning if some rows haven't been updated.
When should I add -3 (Statement.EXECUTE_FAILED) or -2 (Statement.SUCCESS_NO_INFO) into the update count array? I am not using batched update.
> Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
> ----------------------------------------------------------------------------
>
> Key: TEIID-3216
> URL: https://issues.jboss.org/browse/TEIID-3216
> Project: Teiid
> Issue Type: Task
> Components: Misc. Connectors
> Reporter: Filip Elias
> Assignee: Filip Elias
> Fix For: Open To Community
>
>
> Current plan is to use list-based feed of the Google Data API[1].
> There are three known issues:
> performance - to delete/update 100 rows Teiid must generate 100 http requests
> consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't.
> headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet)
> Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers.
> [1] https://developers.google.com/google-apps/spreadsheets/
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
More information about the teiid-issues
mailing list