[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
来源:互联网 发布:天津java培训学校 编辑:程序博客网 时间:2024/05/22 08:06
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not initialize a collection:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:236)
. . . . . .省略掉的这一部分是堆栈信息
使用SQLServer 数据库时,可能发生此异常,原因是微软自己的jdbc驱动不支持同一个记录的字段的重复读取,因为微软加入了text,image这种类型的支持,就限制了字段的回读功能.
(我在使用hibernate级联查询的时候出现了这种异常lazy=false的级联查询)
解决方法:按照顺序(从左到右的顺序)读取字段,例如(getString(1),getString(2),getString(3)....);当然这个是微软jdbc驱动的一个bug,我们也可以不用他的驱动,自己到网上下载jtds.jar驱动,使用这种驱动就不会出现上面的异常了.
- [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
- java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 4.
- java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row dat
- java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row dat
- ResultSet can not re-read row data for column 1.
- ResultSet can not re-read row data for column 1.
- ResultSet can not re-read row data for column
- ResultSet can not re-read row data for column
- ResultSet can not re-read row data for column
- ResultSet can not re-read row data for column
- ResultSet can not re-read row data for column 4
- ResultSet can not re-read row data for column X
- ResultSet can not re-read row data for column X
- ResultSet can not re-read row data for column
- ResultSet can not re-read row data for column 3.
- sqlserver报“ResultSet can not re-read row data for column”错误的解决办法
- 微软JDBC驱动的问题 :ResultSet can not re-read row data for column
- Microsoft JDBC "ResultSet Can Not Re-Read Row Data" Error
- 女人与电脑
- POJ1061
- libtorrent快把人折磨疯了
- Javascript的使用技巧大全
- 十一前夕,有些人表现得不咋的.....................
- [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
- javamail的bug
- 【转】推介30本ASP.NET书
- 寻找用例的方法
- Hibernate一对多多对多查询的排序
- ASP.Net学习笔记(绝对是笔记)
- 学会批处理,用心学很容易
- asp.net学习步骤(转)asp.net学习步骤(转)
- PHP 实现多服务器共享 SESSION 数据