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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-2949.
---------------------------------


> Issue 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
>
> 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 at 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?id=1476



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)