Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: General error; is occuring

 
Huzefa Zohaib
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
" java.sql.SQLException: General error " is occuring on the following code.
Please explain why and does it mean.

 
Jason Cox
Ranch Hand
Posts: 287
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A "General Error" generally means there is something wrong with your SQL query. More than likely one of the values you are inserting doesn't match the SQL Data Type you are trying to insert it into. My guess would be the Messages column as the most likely culprit. Don't focus on that too much, it could be another problem with the statement, but definitely check your SQL query and make sure it can handle what you're trying to put into it.
You might also consider using pstmt.executeUpdate() as a best practice. Though I suppose it doesn't really matter if you're never doing anything with the return value of the execution.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic