 | | | BUG in 3.1.10: retrieving INT value | BUG in 3.1.10: retrieving INT value 2005-07-11 - By Andre de Jesus
Back
In the following, news is defined as:
CREATE TABLE news (
id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT;
);
If I execute the following code:
Class.forName("com.mysql.jdbc.Driver  ");
Connection
conn=DriverManager.getConnection("jdbc:mysql://localhost/test");
PreparedStatement st=conn.prepareStatement("SELECT id FROM
news");
ResultSet rs=st.executeQuery();
while(rs.next()) {
Object obj=rs.getObject("id");
System.out.println(obj);
}
rs.close();
st.close();
conn.close();
With driver version 3.1.8 it works OK: id = 1.
With driver version 3.1.10 it works NOT OK: id = 4294967297 (???).
If I use statements instead of prepared statements, it works OK.
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/java?unsub=mysql@(protected)
|
|
|