JDBC driver has issues with VARCHAR(24)

All of my VARCHAR(24) columns are reported as size 7 from
java.sql.DatabaseMetaData::getColumns. All other sizes from 1 to 49 report
the correct COLUMN_SIZE.

Any ideas?

The following program shows the problem (using 1.2.2828.100 against SQL
Server 2005):

import java.sql.* ;

class JDBCQuery
{
public static void main( String args[] )
{
try
{
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" ) ;
Connection conn =
DriverManager.getConnection("jdbc:sqlserver://colo3:1433;databaseName=test",
"test", "test");

Statement stmt = conn.createStatement();
String ctable = "CREATE TABLE TEST (f1 varchar(1)";
for (int i = 2; i < 50; i++)
{
ctable = ctable + ",f" + i + " varchar(" + i + ")";
}
ctable = ctable + ")";
System.out.println(ctable);

stmt.execute(ctable);

java.sql.DatabaseMetaData meta = conn.getMetaData();
ResultSet set = meta.getColumns(conn.getCatalog(), null, "TEST", null);
while (set.next())
{
System.out.println(set.getString("COLUMN_NAME") + ", " +
set.getString("TYPE_NAME") + ", " + set.getString("COLUMN_SIZE"));
}
stmt.execute("DROP TABLE TEST");
}
catch( SQLException se )
{
System.out.println( "SQL Exception: " + se.getMessage()) ;
}
catch( Exception e )
{
System.out.println( e ) ;
}
}
}

C:\temp>java -cp ".;sqljdbc.jar" JDBCQuery
CREATE TABLE TEST (f1 varchar(1),f2 varchar(2),f3 varchar(3),f4
varchar(4),f5 varchar(5),f6 varchar(6),f7 varchar(7),f8
varchar(,f9 varchar(9),f10 varchar(10),f11 varchar(11),f12 varchar(12),f13
varchar(13),f14 varchar(14),f15 varchar(15)
,f16 varchar(16),f17 varchar(17),f18 varchar(1,f19 varchar(19),f20
varchar(20),f21 varchar(21),f22 varchar(22),f23 var
char(23),f24 varchar(24),f25 varchar(25),f26 varchar(26),f27 varchar(27),f28
varchar(2,f29 varchar(29),f30 varchar(30)
,f31 varchar(31),f32 varchar(32),f33 varchar(33),f34 varchar(34),f35
varchar(35),f36 varchar(36),f37 varchar(37),f38 var
char(3,f39 varchar(39),f40 varchar(40),f41 varchar(41),f42 varchar(42),f43
varchar(43),f44 varchar(44),f45 varchar(45)
,f46 varchar(46),f47 varchar(47),f48 varchar(4,f49 varchar(49))
f1, varchar, 1
f2, varchar, 2
f3, varchar, 3
f4, varchar, 4
f5, varchar, 5
f6, varchar, 6
f7, varchar, 7
f8, varchar, 8
f9, varchar, 9
f10, varchar, 10
f11, varchar, 11
f12, varchar, 12
f13, varchar, 13
f14, varchar, 14
f15, varchar, 15
f16, varchar, 16
f17, varchar, 17
f18, varchar, 18
f19, varchar, 19
f20, varchar, 20
f21, varchar, 21
f22, varchar, 22
f23, varchar, 23
f24, varchar, 7
f25, varchar, 25
f26, varchar, 26
f27, varchar, 27
f28, varchar, 28
f29, varchar, 29
f30, varchar, 30
f31, varchar, 31
f32, varchar, 32
f33, varchar, 33
f34, varchar, 34
f35, varchar, 35
f36, varchar, 36
f37, varchar, 37
f38, varchar, 38
f39, varchar, 39
f40, varchar, 40
f41, varchar, 41
f42, varchar, 42
f43, varchar, 43
f44, varchar, 44
f45, varchar, 45
f46, varchar, 46
f47, varchar, 47
f48, varchar, 48
f49, varchar, 49

Rick Spickelmier wrote:

> All of my VARCHAR(24) columns are reported as size 7 from
> java.sql.DatabaseMetaData::getColumns. All other sizes from 1 to 49 report
> the correct COLUMN_SIZE.
>
> Any ideas?

Hi. This is a bug in the driver. The sp_columns stored procedure
being called by the driver for the actual data is correct, and
returns the right values, but the driver is improperly taking
all that data and 'filtering' it via PrecisionFilter, which interprets
17 and 53 as ODBC values, and these are converted to 7 and 15
respectively.

Joe Weinstein at BEA Systems