{"action":"created","issue":{"url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/1176","repository_url":"https://api.github.com/repos/baomidou/mybatis-plus","labels_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/1176/labels{/name}","comments_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/1176/comments","events_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/1176/events","html_url":"https://github.com/baomidou/mybatis-plus/issues/1176","id":448051269,"node_id":"MDU6SXNzdWU0NDgwNTEyNjk=","number":1176,"title":"日期转换不支持java8的LocalDateTime","user":{"login":"MeAdhere","id":43978683,"node_id":"MDQ6VXNlcjQzOTc4Njgz","avatar_url":"https://avatars3.githubusercontent.com/u/43978683?v=4","gravatar_id":"","url":"https://api.github.com/users/MeAdhere","html_url":"https://github.com/MeAdhere","followers_url":"https://api.github.com/users/MeAdhere/followers","following_url":"https://api.github.com/users/MeAdhere/following{/other_user}","gists_url":"https://api.github.com/users/MeAdhere/gists{/gist_id}","starred_url":"https://api.github.com/users/MeAdhere/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MeAdhere/subscriptions","organizations_url":"https://api.github.com/users/MeAdhere/orgs","repos_url":"https://api.github.com/users/MeAdhere/repos","events_url":"https://api.github.com/users/MeAdhere/events{/privacy}","received_events_url":"https://api.github.com/users/MeAdhere/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2019-05-24T08:48:54Z","updated_at":"2019-05-24T09:16:48Z","closed_at":"2019-05-24T08:55:24Z","author_association":"NONE","body":"### 当前使用版本(3.1.1)\r\n数据库mysql，数据库字段datetime，java字段LocalDateTime\r\n\r\n\r\n\r\n### 重现步骤：\r\n实体有两个字段;\r\n /**\r\n     * 记录创建时间\r\n     */\r\n    private LocalDateTime createTime;\r\n\r\n    /**\r\n     * 记录更新时间\r\n     */\r\n    private LocalDateTime updateTime;\r\n\r\n直接调用mapper.selectList(QueryWrapper)\r\n\r\n\r\n\r\n\r\n### 报错信息\r\njava.lang.IllegalStateException: Failed to execute ApplicationRunner\r\n\tat org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:807) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\tat org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:794) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:324) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\tat org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\tat com.ycxsx.pay.PayApplication.main(PayApplication.java:45) [classes/:na]\r\nCaused by: org.springframework.dao.TransientDataAccessResourceException: Error attempting to get column 'create_time' from result set.  Cause: java.sql.SQLException: Conversion not supported for type java.time.LocalDateTime\r\n; Conversion not supported for type java.time.LocalDateTime; nested exception is java.sql.SQLException: Conversion not supported for type java.time.LocalDateTime\r\n\tat org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:110) ~[spring-jdbc-5.1.2.RELEASE.jar:5.1.2.RELEASE]\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.2.RELEASE.jar:5.1.2.RELEASE]\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.2.RELEASE.jar:5.1.2.RELEASE]\r\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.1.2.RELEASE.jar:5.1.2.RELEASE]\r\n\tat org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[mybatis-spring-2.0.1.jar:2.0.1]\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-2.0.1.jar:2.0.1]\r\n\tat com.sun.proxy.$Proxy65.selectList(Unknown Source) ~[na:na]\r\n\tat org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-2.0.1.jar:2.0.1]\r\n\tat com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:158) ~[mybatis-plus-core-3.1.1.jar:3.1.1]\r\n\tat com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:76) ~[mybatis-plus-core-3.1.1.jar:3.1.1]\r\n\tat com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62) ~[mybatis-plus-core-3.1.1.jar:3.1.1]\r\n\tat com.sun.proxy.$Proxy66.selectList(Unknown Source) ~[na:na]\r\n\tat com.ycxsx.pay.PayApplication.run(PayApplication.java:33) [classes/:na]\r\n\tat org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:804) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]\r\n\t... 5 common frames omitted\r\nCaused by: java.sql.SQLException: Conversion not supported for type java.time.LocalDateTime\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4654) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.JDBC4ResultSet.getObject(JDBC4ResultSet.java:531) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4661) ~[mysql-connector-java-5.1.35.jar:5.1.35]\r\n\tat com.zaxxer.hikari.pool.HikariProxyResultSet.getObject(HikariProxyResultSet.java) ~[HikariCP-3.2.0.jar:na]\r\n\tat org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:38) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:28) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyAutomaticMappings(DefaultResultSetHandler.java:521) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:402) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:354) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:328) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:301) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:194) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67) ~[mybatis-plus-core-3.1.1.jar:3.1.1]\r\n\tat org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.1.jar:3.5.1]\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]\r\n\tat java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]\r\n\tat org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-2.0.1.jar:2.0.1]\r\n\t... 13 common frames omitted\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/comments/495536862","html_url":"https://github.com/baomidou/mybatis-plus/issues/1176#issuecomment-495536862","issue_url":"https://api.github.com/repos/baomidou/mybatis-plus/issues/1176","id":495536862,"node_id":"MDEyOklzc3VlQ29tbWVudDQ5NTUzNjg2Mg==","user":{"login":"MeAdhere","id":43978683,"node_id":"MDQ6VXNlcjQzOTc4Njgz","avatar_url":"https://avatars3.githubusercontent.com/u/43978683?v=4","gravatar_id":"","url":"https://api.github.com/users/MeAdhere","html_url":"https://github.com/MeAdhere","followers_url":"https://api.github.com/users/MeAdhere/followers","following_url":"https://api.github.com/users/MeAdhere/following{/other_user}","gists_url":"https://api.github.com/users/MeAdhere/gists{/gist_id}","starred_url":"https://api.github.com/users/MeAdhere/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MeAdhere/subscriptions","organizations_url":"https://api.github.com/users/MeAdhere/orgs","repos_url":"https://api.github.com/users/MeAdhere/repos","events_url":"https://api.github.com/users/MeAdhere/events{/privacy}","received_events_url":"https://api.github.com/users/MeAdhere/received_events","type":"User","site_admin":false},"created_at":"2019-05-24T09:16:48Z","updated_at":"2019-05-24T09:16:48Z","author_association":"NONE","body":"> #1165\r\n\r\n你好，我这这里不是用的druid，用的是HiKariCP"}}
{"actor":{"display_login":"MeAdhere"}}