当前页面: 开发资料首页 → JSP 专题 → 关于向数据库中插入中文字符失败的问题,请大侠们指点........

关于向数据库中插入中文字符失败的问题,请大侠们指点........

摘要: 关于向数据库中插入中文字符失败的问题,请大侠们指点........

我用的是oracle数据库
为什么我在表中插入字符串数据时,怎么会出现以下提示,或者插入的数据显示成乱码,不知道是什么原因请大侠们帮指点一下是什么原因......
[WARN ] 2006-10-13 12:55:08 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1461, SQLState: 72000
[ERROR] 2006-10-13 12:55:08 org.hibernate.util.JDBCExceptionReporter - ORA-01461: can bind a LONG value only for insert into a LONG column

[WARN ] 2006-10-13 12:55:08 org.hibernate.util.JDBCExceptionReporter - SQL Error: 1461, SQLState: 72000
[ERROR] 2006-10-13 12:55:08 org.hibernate.util.JDBCExceptionReporter - ORA-01461: can bind a LONG value only for insert into a LONG column

[ERROR] 2006-10-13 12:55:08 org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at filters.HibernateFilter.doFilter(HibernateFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tom

---

你的字段类型是LONG，当然不能插入字符了。

---

我没有设成long型啊,数据类型就是string型啊
<?xml version="1.0"?>
hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">



column="S2000"
name="S2000"
type="integer"
>