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.
Little google search reveals that, this is a SQL Server JDBC Driver bug. See http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/2c908b45-6f75-484a-a891-5e8206f8844f/
This will likely be fixed at some point in the Microsoft JDBC driver 4.0, which you can download at http://www.microsoft.com/download/en/details.aspx?id=11774 However at this time it has still not been addressed.
We had good experience and recommend the open source JTDS drivers for SQL Server, which you can get at http://jtds.sourceforge.net/
From your experience and the msdn forum thread it appears their issue is still not addressed, so we'll amend the suggestion above.
> BTW, I get major/minor errors when using JTDS.
You have to use an appropriate version. 1.3.0 is for Java 1.7 based upon the MANIFEST.MF. If you're using an older JRE, then you'll want one of the 1.2.x releases.