Recently I tried to use teiid with sql 2008 server.But I am unable to see the columns in the tables imported when I import Metadata from JDBC database.

the Error that I get is,columns cannot be imported as the conversion from char to smallint is unsupported.

N.B: I have used sqljdbc4 from Microsoft sql jdbc driver 3.0. I did not get this error when I used driver(sqljdbc4) from Microsoft sql jdbc 2.0 but with this jar I am unable to access certain tables in the database.