Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 51972 invoked from network); 14 Jun 2006 15:27:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 14 Jun 2006 15:27:16 -0000 Received: (qmail 22807 invoked by uid 500); 14 Jun 2006 15:27:16 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 22274 invoked by uid 500); 14 Jun 2006 15:27:14 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 22263 invoked by uid 99); 14 Jun 2006 15:27:14 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jun 2006 08:27:14 -0700 X-ASF-Spam-Status: No, hits=0.3 required=10.0 tests=HTML_MESSAGE,MAILTO_TO_SPAM_ADDR X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [83.247.21.92] (HELO wis.nl) (83.247.21.92) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Jun 2006 08:27:13 -0700 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C68FC6.F3162850" Subject: RE: about sqlserver2000 text and ntext field X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Date: Wed, 14 Jun 2006 17:26:46 +0200 Message-ID: <50CA25BD6EEA954FA592C097399942E30E4645B3@CM1.wis.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: about sqlserver2000 text and ntext field thread-index: AcaPvPtY5cWEyK91RyWAi6v3422KWAACeyyA From: "Niels Beekman" To: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C68FC6.F3162850 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Maybe you can fiddle with the order of the properties, see http://support.microsoft.com/kb/824106. =20 Niels =20 ________________________________ From: RZG [mailto:renzenggang@gmail.com]=20 Sent: woensdag 14 juni 2006 16:15 To: user-java@ibatis.apache.org Subject: about sqlserver2000 text and ntext field =20 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 : =20 --- The error occurred in config/sqlmapping/plugins.xml. =20 --- The error occurred while applying a result map. =20 --- Check the plugins.pluginsResultMap. =20 --- Check the result mapping for the 'visitCounter' property. =20 --- 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] =20 but i removed the text field from the resultmapping ,then this mapping id is ok? =20 --=20 RenZenggang Renzenggang@gmail.com Renzenggang@csii.com MSN:rzg117@hotmail.com=20 Blog: http://rzg.itpub.net =20 ------_=_NextPart_001_01C68FC6.F3162850 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Maybe you can fiddle with the order = of the properties, see http://support.microsoft.= com/kb/824106.

 

Niels

 

From: RZG [mailto:renzenggang@gmail.com]
Sent: woensdag 14 juni = 2006 16: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?

 

------_=_NextPart_001_01C68FC6.F3162850--