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

[Van Halbert (JIRA)]

Van Halbert created TEIID-2949:
----------------------------------

             Summary: 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 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.2.3#6260)