ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Biondi" <Ste...@schemalogic.com>
Subject RE: about sqlserver2000 text and ntext field
Date Wed, 14 Jun 2006 17:43:33 GMT
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.
 
http://jtds.sourceforge.net
 
The MS SQL2005 JDBC driver is much better. It may work with SQL2000 as
well.


________________________________

From: RZG [mailto:renzenggang@gmail.com] 
Sent: 14 June 2006 07:15
To: user-java@ibatis.apache.org
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]
 
but i removed the text field from the resultmapping ,then this mapping
id is ok?
 
-- 
RenZenggang
Renzenggang@gmail.com
Renzenggang@csii.com
MSN:rzg117@hotmail.com 
Blog: http://rzg.itpub.net
 

Mime
View raw message