Re: smallint mapping issue

From: Xavier Poinsard <xpoinsard(at)openpricer(dot)com>
To: Christian Cryder <c(dot)s(dot)cryder(at)gmail(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: smallint mapping issue
Date: 2005-07-28 16:40:41
Message-ID: 42E90A89.3040501@openpricer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Christian Cryder a écrit :
> We are in the midst of trying to move to Postgres from MS SQL. Our
> current app consists of about 7500 lines of code (this doesn't count
> our custom OR mapping middleware). We have over 2500 references to
> Short's - because that's how NetDirect's MS SQL drivers return
> smallints. It's also how MySQL returns them, and I _think_ IBM's DB2
> returns them that way as well (I just uninstalled my demo version of
> DB2, so I can't easily verify).
> [...]
> b) where it really complicates things is that our current application
> is running in production on a db that returns values differently. Now,
> it's easy to say "tell them to fix their drivers", but realistically,
> that's not an option w/ MS (and I think you guys know this).

Did you try the jTDS driver for Sql server (
http://jtds.sourceforge.net/ ) ?

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mark Lewis 2005-07-28 17:11:09 Re: smallint mapping issue
Previous Message Kevin Grittner 2005-07-28 16:28:55 Re: smallint mapping issue