Bug 1231769
| Summary: | Solr translator - batched update with more than one query gets stack | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Juraj Duráni <jdurani> | ||||
| Component: | Teiid | Assignee: | Van Halbert <vhalbert> | ||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Juraj Duráni <jdurani> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | high | ||||||
| Version: | 6.1.0 | CC: | atangrin, dlesage, vhalbert | ||||
| Target Milestone: | ER1 | ||||||
| Target Release: | 6.3.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| 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.
|
Story Points: | --- | ||||
| Clone Of: | Environment: |
Version 6.1.2
|
|||||
| Last Closed: | 2016-08-24 11:38:43 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: | |||||||
| Attachments: |
|
||||||
Steven Hawkins <shawkins> updated the status of jira TEIID-3528 to Resolved Steven Hawkins <shawkins> updated the status of jira TEIID-3528 to Closed Verified. |
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();