I'm using SQL Server 7 (Desktop), accessed via JDK 1.2's JDBC-ODBC
bridge under Windows 98 (both SQL Server and client).
SQL Server 7 has a new datatype, "uniqueidentity." When I try to get
my class to access data from a column of this type (via
ResultSet::getString()), I get an error "Numeric value out of range."
(Other column types work fine, though.) When I examine the metadata
for this "uniqueidentity" column, I see that the type is "-11," which
seems a little suspect.
I'm pretty new to Java (and JDBC) - at this point, I'm not even sure
if this is a problem with my Java code, with JDK 1.2's JDBC component,
with my version of ODBC, or with SQL Server 7. Has anyone else run
into this problem?