Bug 1381229
| Summary: | Salesfroce - NPE if using multi-value INSERT | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> |
| Component: | Teiid, Documentation | Assignee: | David Le Sage <dlesage> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Juraj Duráni <jdurani> |
| Severity: | unspecified | Docs Contact: | David Le Sage <dlesage> |
| Priority: | unspecified | ||
| Version: | 6.3.0 | CC: | aszczucz, blafond, drieden, jolee, jstastny, mbaluch, thauser, vhalbert |
| Target Milestone: | GA | Keywords: | Documentation |
| Target Release: | 6.3.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| 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.
|
Story Points: | --- |
| Clone Of: | Environment: | ||
| Last Closed: | 2017-06-26 04:21:53 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Steven Hawkins <shawkins> updated the status of jira TEIID-4487 to Resolved Updating with release note for known issue. 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/ |
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]