[
https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-4666:
------------------------------------
Look at TEIID-3216 and it mentions:
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)
Is this the case with this issue that your spreadsheet doesn't have column headers?
Google translator throws SpreadsheetOperationException for query
DELETE FROM table
----------------------------------------------------------------------------------
Key: TEIID-4666
URL:
https://issues.jboss.org/browse/TEIID-4666
Project: Teiid
Issue Type: Feature Request
Affects Versions: 8.12.8.6_3
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml
Query "DELETE FROM smalla" where smalla is table throws exception:
07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker
process failed for atomic-request=IlMZP21M8Gwr.8.0.2:
org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting
spreadsheet feed. Possibly bad authentication or connection problems.
com.google.gdata.util.InvalidEntryException: Bad Request
Invalid query parameter value for sq.
Please see server.log, standalone.xml and vdb for other information.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)