Re: SMALLINT datatype conversion error

Piotr:

See reply to same post in the SQL Server Data Access forum here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=619049&SiteID=1&mode=1.

thanks
-shelby

Shelby Goerlitz
Microsoft SQL Server Data Programmability

"Piotr Uhruski" <Piotr Uhruski@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42B4C326-0A6B-4A07-BAE5-5616E4A1C2DA@xxxxxxxxxxxxxxxx
Hi all,

We've just stumbled on a 1.0 version incompatibility with the JDBC specs.

Problem: A table with SMALLINT column. According to JDBC specs version 3.0
(p.B-179) and 4.0 (p.221)), the value should be converted to Integer type.

Unfortunatelly we get a Short object :(

Now, I remember, this case was also affecting old JSQLConnect driver from
DataDirect. Could that problem sneak to new MS driver too?

Please let me know any resolution to this problem if exists.

Cheers,
Piotr


.

Loading