Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL JDBC Error

 
krishan go
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a simple program where i create two tables in a database using jdbc and sql.



on executing the code i get an "SQL ERROR" from the catch block.on further investigation i see that the error is from the /*error line*/ which i marked. what am i doing wrong???

-krishan


Moderator comment: I have edited your post to add code tags and to apply proper indenting..
They make your code more readable.
Please use code tags around your code for your future posts.
 
Andrey Kozhanov
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is returned by res.getString("user_name") on line 15?

If null, SQL Error is expected result.
 
Madhan Sundararajan Devaki
Ranch Hand
Posts: 312
Java MS IE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The statement "res.next();" may throw SQLError if the resultset is empty!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic