Java is case sensitive, this is the way JDBC wants you to work. The Exception is generated by JDBC, not due to an error from MySQL. I would recommend checking JDBC documentation.
Aman Raheja http://www.techquotes.com On Wed, 2004-07-21 at 10:55, Ying Lu wrote: > Hello, > > I have a question about column name case sensitive. Currently, we use > MySQL 3.23.32 running on Linux. > > I am trying to use JDBC to get email from table T1 > > T1( > id char(3), > name varchar(12), > Email varchar(16) > ) > > Now If I say, > try{ > ... > > String email = > getString("email"); //here I > got Exception saying "Column name cannot be found" > ... > }catch(Exception e){ > > System.err.println(e); > > } > > If I change the exception line to > getString("Email"); > > everyting is all right. > > > In MySQL documentation, on all OS, there should not have column name > case sensitive problem, right? But how come I changed the column name to > the same format as saved in table T1 it works; otherwise, I got exception? > > Thanks a lot! > Emi > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]