Bug 1231769 - Solr translator - batched update with more than one query gets stack
Summary: Solr translator - batched update with more than one query gets stack
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER1
: 6.3.0
Assignee: Van Halbert
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-06-15 11:38 UTC by Juraj Duráni
Modified: 2016-08-24 11:38 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
If a Solr translator PreparedStatement.executeBatch() has more than one query the user will encounter an error.
Clone Of:
Environment:
Version 6.1.2
Last Closed: 2016-08-24 11:38:43 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
Server log (693.71 KB, text/plain)
2015-06-15 11:38 UTC, Juraj Duráni
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3528 0 Major Closed Solr translator - batched update with more than one query gets stack 2016-08-09 05:21:01 UTC

Description Juraj Duráni 2015-06-15 11:38:21 UTC
Created attachment 1038926 [details]
Server log

Describe the issue: 
PreparedStatement.executeBatch() with more than one query gets stack. For more details see server.log.
However batch of size 1 and Statement.executeBatch() run without problems.
The issue is not present in 6.1.1 version.





[1] - OK
[2] - OK
[3] - issue

[1]
Statement s = con.createStatement();
s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(61,61)");
s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(62,62)");
s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(63,63)");
s.addBatch("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(64,64)");
int[] updCount = s.executeBatch();

[2]
PreparedStatement s = con.prepareStatement("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(?,?)");
s.setInt(1, 61);
s.setString(2, "61");
s.addBatch();
int[] updCount = s.executeBatch();

[3]
PreparedStatement s = con.prepareStatement("INSERT INTO BQT1.SmallA (IntKey,StringKey) VALUES(?,?)");
s.setInt(1, 61);
s.setString(2, "61");
s.addBatch();
s.setInt(1, 62);
s.setString(2, "62");
s.addBatch();
int[] updCount = s.executeBatch();

Comment 1 JBoss JIRA Server 2015-06-15 12:55:15 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3528 to Resolved

Comment 2 JBoss JIRA Server 2016-01-26 18:00:55 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3528 to Closed

Comment 3 Juraj Duráni 2016-06-15 13:29:30 UTC
Verified.


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