lihongtao
发贴: 131
积分: 41
|
于 2003-02-25 11:40
前两天看见MySQL发布了3.0.0稳定版的驱动,迫不及待地替换了原来的2.0.14。结果发现该驱动由未解决的BUG: PreparedStatement stmt = conn.prepareStatement("SELECT USER_ID, GW, USER_NAME FROM DB_USER WHERE USER_NAME=? AND PWD=PASSWORD"); stmt.setString(1, userName); stmt.setString(2, userPassword); ResultSet rst = stmt.executeQuery(); if (rst.next()) { String id = rst.getString("USER_ID"); userView = new UserView("id", userName); } 结果抛出异常: java.sql.SQLException: Column 'USER_ID' not found. at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2278) at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1815) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:167) 换回原来的驱动一切正常
|