Support multiple queries in a single statement
维护者通常 1 天内回复
还没有人认领这个 Issue。
评估
调研方向
Start in CorePreparedStatement, where the issue says the batch array is allocated from the parameter count. Trace how parameter positions are mapped when a prepared statement contains multiple SELECT statements, then inspect nearby tests for prepared statements and multi statement handling. Done means executing the described repeated parameter query no longer throws ArrayIndexOutOfBoundsException.
由索引模型根据 Issue 内容生成。
描述
I'm using this JDBC driver in the Apache Incubator Guacamole project, with MyBatis and Guice, to try to make the SQLite database available as an authentication back-end for the product. In a couple of places in the code (1, 2), there are prepared statements passed to the JDBC drivers that contain multiple select statements from different tables, each terminated by a semicolon. This allows the Java code to make a single method call that runs both queries and returns a single result map, and keeps the code simple. It works perfectly fine for MySQL, PostgreSQL, and SQL Server, but generates this ArrayIndexOutOfBoundsException when used with this SQLite JDBC driver.
When the batch array is allocated in the CorePreparedStatement class, it's allocated based on the number of parameters. However, when multiple select statements are used that expect the same parameters to be passed, there will be x * y number of positions, where x is the parameter count and y is the number of SELECT statements, which is what results in the index out of bounds exception.
I'm not sure if batch needs to be dynamically allocated or resized, or if the size that it needs to be can be computed from other available parameters to get the total position count, but the current method does not allow for multiple statements to be prepared properly.
- 主要语言
- Java
- 星标
- 3.3k
- 派生
- 676
- 平均合并
- 1 天 15 小时
- 30 天内合并 PR
- 18
环境准备
- 没有 Dockerfile 或 Docker Compose 文件
- 没有 Pull Request 模板
- 阅读贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
xerial/sqlite-jdbc 的其他 Issue
-
triage
难度 2/5 1-3 小时 新手友好度 72/100
xerial/sqlite-jdbc#1515 ·
维护者通常 1 天内回复
-
triage
难度 2/5 1-3 小时 新手友好度 74/100
xerial/sqlite-jdbc#1514 ·
维护者通常 1 天内回复
-
triage
难度 2/5 1-3 小时 新手友好度 78/100
xerial/sqlite-jdbc#1513 ·
维护者通常 1 天内回复
-
triage
难度 2/5 1-3 小时 新手友好度 72/100
xerial/sqlite-jdbc#1512 ·
维护者通常 1 天内回复
-
SIGSEGV (exit 134) in bundled `rightstr()` when the length argument is a large negative number可能已有人在做 @sarthakdev143-lite 于 2 天前认领。 未关闭help wanted impacts:JNI
难度 4/5 1-2 天 新手友好度 38/100
xerial/sqlite-jdbc#1508 ·
维护者通常 1 天内回复
查看 xerial/sqlite-jdbc 的全部 Issue
相似的 Issue
-
vips-drift
难度 2/5 1-3 小时 新手友好度 74/100
Stirling-Tools/JPDFium#300 ·
维护者通常 1 天内回复
-
hermes-queue
难度 1/5 1-3 小时 新手友好度 85/100
chrisalunlloyd2-sudo/mindpalace#403 ·
维护者通常 1 天内回复
-
Guidelines: document how to build a use case against a local, unpublished Flow/browserless-test change可能已有人在做 @totally-not-ai 今天认领。 未关闭
难度 1/5 1-3 小时 新手友好度 88/100
vaadin/use-cases#452 · 1 条评论 ·
维护者通常 1 天内回复
-
area/storage area/storage/sql
难度 2/5 1-3 小时 新手友好度 78/100
Apicurio/apicurio-registry#11159 ·
维护者通常 1 天内回复
-
Area/Configuration Type/Improvement
难度 2/5 1-3 小时 新手友好度 68/100
ballerina-platform/static-code-analysis-tool#217 ·
维护者通常 1 天内回复