Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

ResultSet.getString(String columnName) in Mysql  RSS feed

 
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!