SQL Server JDBC - SQL Server 2005, jdbc error/bug?

Author

SQL Server 2005, jdbc error/bug?

Gary at CCB

2005-07-15, 8:23 pm

Hi,

I'm using the latest SQL Server 2005 and jdbc driver. (both downloaded
this week 7/15/05)

I'm trying to insert xml data into an xml column and am getting this error:
com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would
be truncated.

My preliminary testing worked fine. I was trying to load up some production
xml, which is
probably much larger than my original tests.

Any clues as how to mitigate this?
Are there limits to how large an xml document can be loaded through the jdbc
interface?
Can they be changed/configured?

Gary at CCB

2005-07-18, 11:23 am

"Gary at CCB" wrote:

> Hi,
>
> I'm using the latest SQL Server 2005 and jdbc driver. (both downloaded
> this week 7/15/05)
>
> I'm trying to insert xml data into an xml column and am getting this error:
> com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would
> be truncated.
>
> My preliminary testing worked fine. I was trying to load up some production
> xml, which is
> probably much larger than my original tests.
>
> Any clues as how to mitigate this?
> Are there limits to how large an xml document can be loaded through the jdbc
> interface?
> Can they be changed/configured?

This was not an xml problem at all.
It turned out to be overflowing of a different column varchar(64) in the
same table.
It would be nice if the field to be truncated could be identified in the
error message.

Angel Saenz-Badillos[MS]

2005-07-20, 1:23 pm

Thanks for downloading the new driver, glad to hear any feedback. We have a
long way to go in terms of error messages and we probably won't get to this
until shortly before release. The best way to track this issue is to file a
bug on the product feeedback center:

http://lab.msdn.microsoft.com/produ...ck/default.aspx

Let me know if this works out well for you, I am not personaly familiar with
this system but have high expectations for it.

--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/

"Gary at CCB" < GaryatCCB@discussion
s.microsoft.com> wrote in message
news:496891C0-C50D-4035-9C9C- BFBC717E57DA@microso
ft.com...
>
>
> "Gary at CCB" wrote:
>
>
>
> This was not an xml problem at all.
> It turned out to be overflowing of a different column varchar(64) in the
> same table.
> It would be nice if the field to be truncated could be identified in the
> error message.

Sponsored Links