The MS SQL 2000 JDBC driver has this issue where you can
only call getString on the resultset once for an ntext column.
I would recommend using the jTDS driver instead. It's an open
source type 4 driver and this problem will go away if you
do.
The MS SQL2005 JDBC driver is much better. It may work with
SQL2000 as well.
From: RZG [mailto:[EMAIL PROTECTED]
Sent: 14 June 2006 07:15
To: [email protected]
Subject: about sqlserver2000 text and ntext field
hi all,
how to operate text or ntext type
field in java ?
when i call a query with text resultmapping sqlmapping id,the error occured
:
--- The error occurred in config/sqlmapping/plugins.xml.
--- The error occurred while applying a result map.
--- Check the plugins.pluginsResultMap.
--- Check the result mapping for the 'visitCounter' property.
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 11.]; SQL was [(mapped statement)] for task [SqlMapClientTemplate]
--- The error occurred while applying a result map.
--- Check the plugins.pluginsResultMap.
--- Check the result mapping for the 'visitCounter' property.
--- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 11.]; SQL was [(mapped statement)] for task [SqlMapClientTemplate]
but i removed the text field from the resultmapping ,then this mapping id
is ok?
