DV Google Spreadsheet gives NullPointerException with OAuth2 AuthMethod
Issue
- Configured Google Spreadsheet Resource Adapter with OAuth2 AuthMethod, but see below in the server.log:
WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 1) IJ000604: Throwable while attempting to get a new connection: null: java.lang.NullPointerException
at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.<init>(SpreadsheetConnectionImpl.java:55)
at org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory$1.getConnection(SpreadsheetManagedConnectionFactory.java:58)
at org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory$1.getConnection(SpreadsheetManagedConnectionFactory.java:55)
at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:70) [teiid-api-8.7.6.6_2-redhat-1.jar:8.7.6.6_2-redhat-1]
Environment
- Red Hat JBoss Data Virtualization (DV)
- Google Spreadsheet Resource Adapter configured as:
<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:/DSgoogle" enabled="true" use-java-context="true" pool-name="DSgoogle">
<config-property name="AuthMethod">OAuth2</config-property>
<config-property name="SpreadsheetName">DSGoogle</config-property>
<config-property name="BatchSize">200</config-property>
<config-property name="RefreshToken">refreshtoken</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.