程序中根本就没有用到long类型,数字、英文能正常插入;插入是中文时就报以下错误。。
Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into pms2_obj2 (name, version, url, description, creationTime, status, id) values (?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception isjava.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
原因是:我项目中的数据库驱动包是对的,但jboss中的却是低版本(D:\jboss-4.2.2.GA-lims\server\default\lib替换成较新版),我用的是ojdbc14.jar
ojdbc14.jar和class12.jar有时会有冲突,建议保留其一