Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet.getString(String columnName) in Mysql

 
Arron Zhang
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
friends,
when I use getString(String columnName) in Mysql,
Exception:
java.sql.SQLException: Column 'User' not found.
why?
 
Arron Zhang
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
but when I use getString(int i)
the program run successfully!
 
DC Dalton
Ranch Hand
Posts: 287
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What kind of server are you running on? On a unix/linux box the column names are VERY case sensitive. Ive run itno this developing on a win2k machine then deploying to a Linux box & OOOPPPSS fudged the case. Check that again. Besides that its pretty cut & dry, spell it right, case right, it should work fine.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic