Bug 1381229 - Salesfroce - NPE if using multi-value INSERT
Summary: Salesfroce - NPE if using multi-value INSERT
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid, Documentation
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: GA
: 6.3.0
Assignee: David Le Sage
QA Contact: Juraj Duráni
David Le Sage
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-10-03 13:22 UTC by Juraj Duráni
Modified: 2017-06-26 04:21 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: Known Issue
Doc Text:
If the user issues a multi-value INSERT SQL statement with SalesForce, they will encounter a null-pointer exception.
Clone Of:
Environment:
Last Closed: 2017-06-26 04:21:53 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JDV7-69 0 Major Closed Salesfroce - NPE if using multi-value INSERT 2018-10-03 22:04:54 UTC
Red Hat Issue Tracker TEIID-4487 0 Major Resolved NPE if using multi-value prepared INSERT 2018-10-03 22:04:54 UTC

Description Juraj Duráni 2016-10-03 13:22:38 UTC
Description of problem:
If user issues multi-value insert, Teiid throws NPE.

Sample code
PreparedStatement ps = con.prepareStatement("INSERT INTO Dvqe__c (InternalID__c,MatrixID__c) VALUES (?,?),(?,?),(?,?)");
ps.setInt(1, 1);
ps.setString(2, uniqueMatrixID + "01");
ps.setInt(3, 2);
ps.setString(4, uniqueMatrixID + "02");
ps.setInt(5, 3);
ps.setString(6, uniqueMatrixID + "03");
int uc = ps.executeUpdate();

Exception
14:12:39,934 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue3) TEIID30019 Unexpected exception for request 7kiAJNRuK+I4.1: java.lang.NullPointerException
    at org.teiid.query.resolver.command.SetQueryResolver.checkSymbolTypes(SetQueryResolver.java:160) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.command.SetQueryResolver.resolveSetQuery(SetQueryResolver.java:86) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.command.SetQueryResolver.resolveCommand(SetQueryResolver.java:68) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:273) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.command.SetQueryResolver.resolveCommand(SetQueryResolver.java:61) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:273) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.command.InsertResolver.resolveProceduralCommand(InsertResolver.java:86) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.ProcedureContainerResolver.resolveCommand(ProcedureContainerResolver.java:143) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:273) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:127) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:402) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.Request.processRequest(Request.java:470) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.PreparedStatementRequest.processRequest(PreparedStatementRequest.java:294) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:642) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
    at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]

Comment 1 JBoss JIRA Server 2016-10-03 17:32:52 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-4487 to Resolved

Comment 6 David Le Sage 2017-05-11 03:30:08 UTC
Updating with release note for known issue.

Comment 9 David Le Sage 2017-06-16 03:24:18 UTC
Thanks. Wording amended as per Jan's suggestion.  

URL:  https://doc-stage.usersys.redhat.com/documentation/en-us/red_hat_jboss_data_virtualization/6.3/html-single/release_notes/


Note You need to log in before you can comment on or make changes to this bug.