search

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Apache License 2.0
20k stars 2.94k forks source link

useServerPrepStmts doesn't get mysql time(3) milliseconds #1440

Open untitled2 opened 5 years ago

untitled2 commented 5 years ago

Environment

HikariCP version: 3.3.1
JDK version     : 12.0.1
Database        : MySQL
Driver version  : 8.0.16

With mysql time(3) data type, jdbcTemplate getString() will not retrieve milliseconds when "useServerPrepStmts" is set to "true".

quaff commented 5 years ago

I can't reproduce this, and it sounds like mysql driver issue, have you tried with native DriverManager not connection pool?

jzdayz commented 4 years ago

Obviously it is a driver problem, hikariCp will delegate the behavior of the resultSet to the actual resultSet