Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2949

Issue querying Google Spreadsheet

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • 8.4.1
    • Misc. Connectors
    • None

      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@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

            rhn-engineering-shawkins Steven Hawkins
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: