hibernate mysql 报错简单问题

[code="java"]
Hibernate: update tb_news_radio set state='审核否决', shenhe_name='admin', shenhe_time=now() where id=135
2012-02-05 12:31:08,984 [http-5000-1] ERROR org.hibernate.util.JDBCExceptionReporter - Data truncation: Data truncated for column 'shenhe_time' at row 1
org.hibernate.exception.DataException: could not execute update query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1168)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
at com.acec.house.service.admin.AdminManager.shipinPass(AdminManager.java:442)
at com.acec.house.service.admin.AdminManager$$FastClassByCGLIB$$c5f9ca65.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.acec.house.service.admin.AdminManager$$EnhancerByCGLIB$$2536b346.shipinPass()
at com.acec.house.actions.admin.AdminAction.shipinPass(AdminAction.java:1002)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'shenhe_time' at row 1
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:717)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3031)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1241)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
... 87 more

报这个错。我在数据库直接执行sql语句可以执行。
public void shipinPass(Integer id, String pass, String userName) {
if(pass.equals("true"))
manager.createQuery("update NewsRadioEO set state='审核通过',shenheName='"+userName+"',shenheTime=now() where id="+id).executeUpdate();
else
manager.createQuery("update NewsRadioEO set state='审核否决',shenheName='"+userName+"',shenheTime=now() where id="+id).executeUpdate();
}
这样却不行了，我把shenheTime=now() 改成shenheTime='2012-05-05'却可以执行
求指导
[/code]

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

4条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
long2007 2012-02-07 12:51
关注
建议你做两种尝试：
1.你把now()外面加上单引：
if(pass.equals("true"))

manager.createQuery("update NewsRadioEO set state='审核通过',shenheName='"+userName+"',shenheTime='now()' where id="+id).executeUpdate();
看hibernate是否会把你的now()直接交给数据库处理。
2.你把那个now()用java.util.Date数据类型得到然后赋过去。
if(pass.equals("true"))

manager.createQuery("update NewsRadioEO set state='审核通过',shenheName='"+userName+"',shenheTime='" + new SimpleDateFormat("yyyy-MM-dd").format(new Date()) + "' where id="+id).executeUpdate();

第二种虽然肯定可用，但是多实例化了两个对象，我想你最好先尝试一下第一种方式，不行再采用第二种方式，即用java来获得当前时间。

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(3条)

报告相同问题？

关注问题

hibernate mysql 报错简单问题 hibernate
2012-02-05 12:36

回答 4 已采纳建议你做两种尝试： 1.你把now()外面加上单引： if(pass.equals("true")) manager.createQuery("update News
java搭建hibernate框架报错 hibernate java
2023-01-23 18:00

回答 3 已采纳首先，确认数据库正确连接:检查数据库能连接上吗，用数据库连接工具能打开看到数据库表吗。其次，你用的jdk版本是多少， JDK 8 中有关反射相关的功能自从 JDK 9 开始就已经被限制了，为了兼容原先
hibernate5.0.6报错Unknown entity java 数据库
2015-12-22 16:13

回答 2 已采纳你是使用配置文件配置entity的，把class那一串去了就行了
MySQL报错3031_hibernate mysql 报错简单问题
2021-01-21 15:41

weixin_39716800的博客 Hibernate: update tb_news_radio set state='审核否决', shenhe_name='admin', shenhe_time=now() where id=1352012-02-05 12:31:08,984 [http-5000-1] ERROR org.hibernate.util.JDBCExceptionReporter - Data ...
Java Hibernate运行问题 hibernate java mysql
2015-11-27 14:55

回答 3 已采纳少了jta.jar包列 Hibernate会调用jta.jar的内容加进去就OK了
hibernate 配置文件报错 hibernate 数据库
2017-01-03 11:00

回答 2 已采纳 http://blog.csdn.net/z28126308/article/details/52914490
jpa 再windows下没问题，但到linux就报错 hibernate java mysql
2020-01-14 10:22

回答 1 已采纳可能是你linux下的sql版本有问题，下一个和windows一样版本的试试 ![图片说明](https://img-ask.csdn.net/upload/202001/14/1578971755
hibernate-mysql报错
2020-11-23 13:15

不会飞的青蛙的博客报错信息: org.hibernate.MappingException: Cannot use identity column key generation with <union-subclass> mapping for: com.atguigu.hibernate.union.subclass.Student at org.hibernate.persister....
hibernate如何配置mysql主键生成策略？ hibernate java mysql
2015-11-02 12:11

回答 1 已采纳 Hibernate各种主键生成策略与配置详解Hibernate各种主键生成策略与配置详解Hibernate各种主键生成策略与配置详解----------------------同志你好，我是CSDN问
学习hibernate+spring的时候数据源一直报错网上办法不行不知道哪里有问题. hibernate intellij-idea java spring
2020-04-29 09:42

回答 2 已采纳报错信息提示是你的日志组件，缺少实现。需要你把log4j2的核心包引进来。
spring Data Jpa 项目发布linux sql大写报错问题 java
2019-09-18 16:28

回答 1 已采纳 Hibernate注释下的自定义架构实现扩展org.hibernate.cfg.ImprovedNamingStrategy 命名策略，然后在配置文件中指向自己的命名配置文件即可 ```
bae java mysql_BAE基础版使用Hibernate连接MySql报错
2021-01-26 16:59

简 Ai的博客但是改成BAE的MySql数据库以后，运行的时候报错配置如下org.hibernate.dialect.MySQL5Dialectjdbc:mysql://sqld.duapp.com:4050/com.mysql.jdbc.Driver查看stdout.log 如下#15:09:46,515 INFO DriverManagerConnecti...
JAVA问题：hibernate的自动建表功能配置完了也不成功，求教 hibernate java mysql
2016-03-21 15:20

回答 3 已采纳这个是个简单的例子，你的Role类配置映射有一个set集合多对多映射，而类定义时却没有这个成员变量呢。这篇文章跟你的例子类似，你对照看看吧。 http://m.blog.csdn.ne
hibernate3连接mysql8报错_报错 MySQL8.0 hibernate5.8.0
2021-01-25 15:13

武子奇的博客 org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]at org.hibernate.service.internal.AbstractServiceRegistryImpl.createSe...
hibernate mysql 中文乱码_使用Hibernate和mysql中文乱码问题
2021-03-19 08:33

小辛Zing的博客今天遇到mysql和Hibernate的乱码问题，花了好一会。最后，终于解决了。现在从头整理一下解决乱码问题思路。乱码问题说到底是字符集不同造成的。如果从头到尾，都是使用的同一个支持该种字符的字符集，就没什么问题...
没有解决我的问题, 去提问

悬赏问题

¥15 如何用stata画出文献中常见的安慰剂检验图
¥15 c语言链表结构体数据插入
¥40 使用MATLAB解答线性代数问题
¥15 COCOS的问题COCOS的问题
¥15 FPGA-SRIO初始化失败
¥15 MapReduce实现倒排索引失败
¥15 ZABBIX6.0L连接数据库报错，如何解决？(操作系统-centos)
¥15 找一位技术过硬的游戏pj程序员
¥15 matlab生成电测深三层曲线模型代码
¥50 随机森林与房贷信用风险模型

hibernate mysql 报错 简单问题

4条回答 默认 最新

悬赏问题

hibernate mysql 报错简单问题

4条回答默认最新