Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQL Server 2005, jdbc error/bug?

  
   Database Forums (Home) -> JDBC Driver RSS
Next:  Windows security  
Author Message
Gary at CCB

External


Since: Jul 15, 2005
Posts: 1



(Msg. 1) Posted: Fri Jul 15, 2005 4:21 pm
Post subject: SQL Server 2005, jdbc error/bug?
Archived from groups: microsoft>public>sqlserver>jdbcdriver (more info?)
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?

 >> Stay informed about: SQL Server 2005, jdbc error/bug? 
Back to top
Login to vote
Gary at CCB

External


Since: Jul 18, 2005
Posts: 1



(Msg. 2) Posted: Mon Jul 18, 2005 9:36 am
Post subject: RE: SQL Server 2005, jdbc error/bug? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"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.

 >> Stay informed about: SQL Server 2005, jdbc error/bug? 
Back to top
Login to vote
Try this once

External


Since: Jun 20, 2008
Posts: 1



(Msg. 3) Posted: Fri Jun 20, 2008 12:23 am
Post subject: RE: SQL Server 2005, jdbc error/bug? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
HI,

u mite be exceeding the limit while passing data ra.
means passing data is more length than field length in DB...
check it once...

Regards
kalyani




"Gary at CCB" wrote:

>
>
> "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.
 >> Stay informed about: SQL Server 2005, jdbc error/bug? 
Back to top
Login to vote
Evan T. Basalik (MSFT)

External


Since: Mar 06, 2007
Posts: 49



(Msg. 4) Posted: Tue Jun 24, 2008 8:31 pm
Post subject: RE: SQL Server 2005, jdbc error/bug? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Unfortunately, SQL Server is who generates the error and SQL Server does not notify the offending column. This means there is no way for any provider to
get that information.

Evan
--------------------
>Thread-Topic: SQL Server 2005, jdbc error/bug?
>thread-index: AcjSpnp/rv94JfjbTBGajQmLysAQKQ==
>X-WBNR-Posting-Host: 207.46.192.207
>From: =?Utf-8?B?VHJ5IHRoaXMgb25jZQ==?=
>References:
>Subject: RE: SQL Server 2005, jdbc error/bug?
>Date: Fri, 20 Jun 2008 00:23:04 -0700
>Lines: 42
>Message-ID:
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
>Newsgroups: microsoft.public.sqlserver.jdbcdriver
>Path: TK2MSFTNGHUB02.phx.gbl
>Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.jdbcdriver:530
>NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
>X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
>
>HI,
>
>u mite be exceeding the limit while passing data ra.
>means passing data is more length than field length in DB...
>check it once...
>
>Regards
>kalyani
>
>
>
>
>"Gary at CCB" wrote:
>
>>
>>
>> "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.
>

Evan T. Basalik
This posting is provided “AS IS” with no warranties, and confers no rights.
 >> Stay informed about: SQL Server 2005, jdbc error/bug? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to install 2005 JDBC driver v1.2 on weblogic -

JDBC Driver Support for SQL 2005 Schemas? - Anyone know if the JDBC driver supports SQL 2005 schemas? If so, which version. When we use the JDBC driver, it seems to report back database roles instead of schemas, SQL 2000 style. Thanks

SQL Error with CTP JDBC Driver 1.1 - Starting up our application server encounters an error with the 1.1 CTP JDBC driver against a SQL Server 2005 SP1 server. The identical process succeeds with the 1.0 driver. The error received is: "The conversion from VARCHAR to CHAR is unsuppo...

Error when comparing against empty string using JDBC 2005 .. - I am having a problem with JDBC 2005 Beta when comparing against an empty string. tate : S1093 Message: Index out of range1 Valid range is 1 to 0 Error : 0 com.microsoft.sqlserver.jdbc.SQLServerException: Index out of range1 Valid range is 1 to 0..

MSS 2005 JDBC error - The conversion from int to TIMESTAMP.. - We are running regression tests fro our product against MSS 2005 and the new jdbc driver. However we are getting the following error message: “com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to TIMESTAMP is unsupported” ..
   Database Forums (Home) -> JDBC Driver All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]