SQL and Java datatypes in FreeTDS

Fabio Galarraga fabio at mrree.gub.uy
Mon Jan 8 14:52:30 EST 2001


Hi to all:
I'm using freetds_jdbc.snapshot.jar with JDK 1.2.2 to connect a SQL
Server.
I have the following Java code:

.....
   int number;

   Class.forName ("com.internetcds.jdbc.tds.Driver");
   Connection con = DriverManager.getConnection (url, user, password);
   Statement stmt = con.createStatement ();
   ResultSet rs = stmt.executeQuery (consulta);
   if (rs.next ()){
      number=rs.getInt(1)+1;
.....

When I run this code, the last line generate a SQLException with error:
"Internal error. Don't know how to convert from java.sql.Types DECIMAL to
an long"

This code works with ODBC-JDBC driver.

What's the problem? 
Is getInt method implemented in freetds_jdbc.snapshot.jar? 


Best regards,
Fabio Galarraga
fabio at mrree.gub.uy



More information about the FreeTDS mailing list