This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL JDBC Error

 
krishan go
Greenhorn
Posts: 8
  • 0
  • 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
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The statement "res.next();" may throw SQLError if the resultset is empty!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic