[teiid-issues] [JBoss JIRA] (TEIID-2949) Issues querying Google Spreadsheet

Issues querying Google Spreadsheet ---------------------------------- Key: TEIID-2949 URL: https://issues.jboss.org/browse/TEIID-2949 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.4.1 Reporter: Van Halbert Assignee: Steven Hawkins Priority: Blocker Issue querying google spreadsheet: Steps to Reproduce: 1. configure resource adaptor for google in standalone.xml <resource-adapter id="google"> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/> <transaction-support>NoTransaction</transaction-support> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google"> <config-property name="AuthMethod"> ClientLogin </config-property> <config-property name="SpreadsheetName"> testsheet </config-property> <config-property name="BatchSize"> 4096 </config-property> <config-property name="Username"> hokuda.test(a)gmail.com </config-property> <config-property name="Password"> passpassw </config-property> </connection-definition> </connection-definitions> </resource-adapter> 2. deploy dynamic vdb <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="test" version="1"> <description>Dynamic Google Spreadsheet VDB</description> <model name="google"> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/> </model> </vdb> 3. you get an exception 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti ng batch 404:Not Found at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat aProtocolAPI.java:248) at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat aProtocolAPI.java:163) at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109) at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7 4) at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147) at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71) at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45) at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red hat-7.jar:8.4.1-redhat-7] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1 -redhat-7.jar:8.4.1-redhat-7] at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45] at org.jboss.threads.JBossThread.run(JBossThread.java:122) Here's a reference to the google issue that's causing our issue: https://code.google.com/p/google-visualization-api-issues/issues/detail?i...