Hibernate插入异常

[xryy002]

Hibernate:
insert
into
kpxmdb.dbo.xm_zj
(name, xb, mz, csdate, zcid, zw, gznx, email, gzdw, txdz, lxdh, lxsj, csgzqk, dwyj, zgbmyj, kjjyj, kjtyj, username, password)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
org.hibernate.exception.DataException: could not insert: [com.kp.zjk.model.XmZj]
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:184)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:83)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:207)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteUpdate(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 134 more

[nisuifen]

表字段长度不够咯。。

[nisuifen]

看不到数据？
你用的是什么数据库？
重新连接数据库 能不能看到数据？ 好像有些数据库有 会话隔离的功能。

[小爽昵称已被占用]

1.类型不匹配，比较数据，找到原因。。
2.数据太长。。怀疑有textarea。。手动改数据库

[FrogKing_7]

不太清楚

使用Hibernate处理数据(转载) ：


www.phome.asia/forum/thread/15735.html

[中国匠心]

类型不匹配，长度太长了。你所谓的没有插入成功，但是有插入语句，开启事务了吗？是调用的createSQLQuery()吗？

[xulinzhou]

插入的数据问题

[蹭饭熊]

支持楼上。。。。。。。。。。。。

[xryy002]

3
1111111111111113
Hibernate:
insert
into
kpxmdb.dbo.xm_zj
(name, xb, mz, csdate, zcid, zw, gznx, email, gzdw, txdz, lxdh, lxsj, csgzqk, dwyj, zgbmyj, kjjyj, kjtyj, username, password)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)




控制台显示成功的插入语句，但是数据库里面就是没有数据，那是怎么回事啊~~在线等~！

[不姓贾_请叫我甄先生]

[Quote=引用 3 楼 xryy002 的回复:]

控制台显示成功的插入语句，但是数据库里面就是没有数据，那是怎么回事啊~~在线等~！
[/Quote]
他显示成功的插入语句，此时还在缓存中，还没真正传到数据库里，问题估计是你的变量类型不匹配

[sl514]

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据
表字段长度不够

[skran]

要插入的数据太长了吧

[happyzhxi]

[Quote=引用 5 楼 sl514 的回复:]

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据
表字段长度不够
[/Quote]

支持