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