ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Hixson <mhix...@activerain.com>
Subject Re: String or binary data would be truncated
Date Wed, 20 Sep 2006 21:01:23 GMT
Thanks, Larry.  I'll keep looking.
   -M@

On Sep 20, 2006, at 1:05 PM, Larry Meadors wrote:

> That message comes from SQL Server, and IIRC, SQL Server doesn't tell
> you the field either. :(
>
> Larry
>
>
> On 9/20/06, Matthew Hixson <mhixson@activerain.com> wrote:
>> I'm receiving the following error upon an insert to one of our
>> tables.  Is there any way to get iBatis to state exactly which field
>> it is that is failing?  I've tried investigating this by hand but due
>> to the number of columns in this table and the time constraints we
>> are under I'm looking for my favorite solution to software dev
>> problems:  get the software to do it for me.  Is this telling me that
>> a field was the empty string (where it says: violated by SQL '')?
>>    Any help is greatly appreciated.
>>     -M@
>>
>> 20 Sep 2006 12:54:48:282 ERROR (FooImpl.java:574) - [There was an
>> exception within executeFooProcess(): (SqlMapClient operation): data
>> integrity violated by SQL ''; nested exception is
>> com.ibatis.common.jdbc.exception.NestedSQLException:
>> --- The error occurred in com/activerain/model/sqlmaps-sqlserver/
>> FooSQLMap.xml.
>> --- The error occurred while applying a parameter map.
>> --- Check the insertTargusInfo-InlineParameterMap.
>> --- Check the statement (update failed).
>> --- Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
>> for JDBC][SQLServer]String or binary data would be truncated.]
>>
>>
>>
>>
>>

--
Matthew Hixson
360-542-0501
mhixson@activerain.com




Mime
View raw message