首页 新闻 搜索 专区 学院

C3P0方式访问MySQL,QueryRunner.query出错:incompatible types, cannot convert java.sql.Timestamp to java.time.LocalDateTime

0
[待解决问题]

JavaWeb通过C3P0访问MySQL QueryRunner.query出错:
incompatible types, cannot convert java.sql.Timestamp to java.time.LocalDateTime

错误:
StudentDaoImpl.findTemperature()...sql = select tb_stu_temperature.* , tb_user.name from tb_stu_temperature inner join tb_user on tb_stu_temperature.username = tb_user.username limit 0, 10
java.sql.SQLException: Cannot set collectTime: incompatible types, cannot convert java.sql.Timestamp to java.time.LocalDateTime Query: select tb_stu_temperature.* , tb_user.name from tb_stu_temperature inner join tb_user on tb_stu_temperature.username = tb_user.username limit 0, 10 Parameters: []
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:527)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:391)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:347)
at com.sdbi.dao.impl.StudentDaoImpl.findTemperature(StudentDaoImpl.java:121)
at com.sdbi.service.impl.StudentServiceImpl.findTemperature(StudentServiceImpl.java:25)
at com.sdbi.servlet.StudentServlet.listTemperature(StudentServlet.java:188)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sdbi.servlet.BaseServlet.service(BaseServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

POJO类:

MySQL表

数据

熊猫Panda先生的主页 熊猫Panda先生 | 菜鸟二级 | 园豆:204
提问于:2022-05-19 12:36
< >
分享
所有回答(1)
0
熊猫Panda先生 | 园豆:204 (菜鸟二级) | 2022-05-21 08:01
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册