[teiid-issues] [JBoss JIRA] Closed: (TEIID-1408) SalesForce.com - Unable to get managed connection - java.lang.NullPointerException

SalesForce.com - Unable to get managed connection - java.lang.NullPointerException ---------------------------------------------------------------------------------- Key: TEIID-1408 URL: https://issues.jboss.org/browse/TEIID-1408 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 7.1.1 Environment: Linux server, SOA-P ER6 Reporter: Warren Gibson Assignee: Steven Hawkins Fix For: 7.1.1, 7.3 Attachments: salesforce-ds.xml, salesforceVDB.vdb Connection to SalesForce.com with the attached SalesForce VDB and DS file works in ER5 but is failing in ER6. It is failing with the NullPointer below. If the URL property in the DS file is removed a connection can be made and queries work successfully. 2010-12-21 13:01:26,835 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue237) [Ljava.lang.Object;@1b66915 [TeiidProcessingException]Unable to get managed connection for salesforce 1 [TranslatorException]Unable to get managed connection for salesforce 2 [ResourceException]Unable to get managed connection for salesforce 3 [JBossResourceException]Unexpected throwable while trying to create a connection: null; - nested throwable: (java.lang.NullPointerException) 4 [NullPointerException] at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:371) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:214) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:154) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:274) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:107) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:150) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:105) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:115) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:250) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:184) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:636) Caused by: [TranslatorException]Unable to get managed connection for salesforce 1 [ResourceException]Unable to get managed connection for salesforce 2 [JBossResourceException]Unexpected throwable while trying to create a connection: null; - nested throwable: (java.lang.NullPointerException) 3 [NullPointerException] at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:146) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:198) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:281) at org.teiid.dqp.internal.process.DataTierTupleSource.access$000(DataTierTupleSource.java:71) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:123) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:120) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:108) ... 6 more Caused by: javax.resource.ResourceException: Unable to get managed connection for salesforce at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:381) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941) at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:53) at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:144) ... 12 more Caused by: org.jboss.resource.JBossResourceException: Unexpected throwable while trying to create a connection: null; - nested throwable: (java.lang.NullPointerException) at org.jboss.resource.JBossResourceException.rethrowAsResourceException(JBossResourceException.java:61) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:304) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404) ... 17 more Caused by: java.lang.NullPointerException at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.login(SalesforceConnectionImpl.java:111) at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.<init>(SalesforceConnectionImpl.java:76) at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:76) at org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory$1.getConnection(SalesForceManagedConnectionFactory.java:71) at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:70) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:639) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:273) ... 19 more