JDBC请求参数未传递给H2数据库
运行时环境:Java-17-Spring-JDBC
Maven依赖关系:
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.6</version>
<relativePath/>
</parent>
<properties>
<java.version>17</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.212</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>runtime</scope>
</dependency>
</dependencies>
参数如下:
sql = "select * from storedProc(:param0, :param1, :param2)"
paramsQuery = {param0=palomnic, param1=20220515, param2=20220515}
请求执行:
List<T> jdbc.query(String sql, Map<String, Object> paramsQuery, RowMapper<T> rowMapper);
for nates ParyParameterJdbCtemplate JDBC;
错误发生在过程的正文StordProc
db H2 据报道,所有参数= null
连接到DB PostgreSQL时如何执行相同的代码,
如何正确传递DB H2的参数?
Runtime environment: java-17-spring-jdbc
Maven dependencies:
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.6</version>
<relativePath/>
</parent>
<properties>
<java.version>17</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>2.1.212</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<scope>runtime</scope>
</dependency>
</dependencies>
The parameters are passed like this:
sql = "select * from storedProc(:param0, :param1, :param2)"
paramsQuery = {param0=palomnic, param1=20220515, param2=20220515}
Request execution:
List<T> jdbc.query(String sql, Map<String, Object> paramsQuery, RowMapper<T> rowMapper);
for NamedParameterJdbcTemplate jdbc;
The error occurs in the body of the procedure storedProc
db h2
it is reported that all parameters = null
The same code is executed without errors when connecting to db postgresql
How to correctly pass parameters for db h2 ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论