SQLServerDatabaseMetaData.getColumns -> IS_AUTOINCREMENT returns SMALLINT while JDBC defines it as BOOLEAN

Question

I am running:

 

 

Microsoft SQL Server 10.00.2531

Microsoft SQL Server JDBC Driver 3.0 3.0.1119.0

 

 

Calling DatabaseMetaData.getColumns() for a table and then checking the ResultSetMetaData reveals that the IS_AUTOINCREMENT column is reported by the ResultSetMetaData as being SMALLINT rather than STRING as it is defined in JDBC.

 

Please advise.

Answer 1

The metadata of the columns is not right, however if you use getString on the column you will still get a string as defined by JDBC and get YES or NO values.

---

Mugunthan

Answer 2

Yes I know getString() should be used. However, will the problem be fixed in a future version of the JDBC driver?

Answer 3

There are no immediate plans to fix it but it is possible this would be fixed in a future release.

---

Mugunthan

Answer 4

Any news whether this has been or is planned to be fixed?

Answer 5

Any news on this? The 4.0 driver still doesn't report this correctly.

That information should be properly reported by the driver that claims to be JDBC compliant.

Answer 6

however if you use getString on the column you will still get a string as defined by JDBC and get YES or NO values.

---

Mugunthan

That is not true. getString() returns "NO" even if the column was defined as an identity column.