AFAIK, LOB classes in MS SQL JDBC driver are implemented quite badly. Try to use jtds driver instead: http://jtds.sourceforge.net/
Good luck. Denis. > We use jdo to access the data in data base. If the table without blob column we can retrieve the data. But if the table has some columns with blob type, we can just insert a row into data base and can not retrieve them back. When we try to fetch them out. It just report the error msg "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1". If we use size() method, it report msg "org.exolab.castor.jdo.PersistenceException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported method: ResultSet.last". > > It real make us confused. Whether the problem is of ms sql 2000, its jdbc driver or castor 0.9.4.3? > our database configuration file is as following: > <!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version 1.0//EN" > "http://castor.exolab.org/jdo-conf.dtd";> > <database name="OraDB" engine="sql-server" > > <driver class-name="com.microsoft.jdbc.sqlserver.SQLServerDriver" > url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=OraDB"> > <param name="user" value="sa" /> > <param name="password" value="sa"/> > <param name="SelectMethod" value="Cursor" /> > </driver> > <mapping href="mapping.xml"/> > </database> > > Is there any methods to solve this problem? > > ----------------------------------------------------------- > If you wish to unsubscribe from this mailing, send mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
